key_buffer_size = 512M
max_allowed_packet = 128M
table_open_cache = 512
sort_buffer_size = 64M
read_buffer_size = 64M
read_rnd_buffer_size = 128M
myisam_sort_buffer_size = 2048M
thread_cache_size = 64
query_cache_size= 2048M
#innodb_use_native_aio = 0
default_storage_engine = InnoDB
innodb_buffer_pool_size = 64G
innodb_file_per_table = 1
innodb_log_file_size = 256M
innodb_buffer_pool_instances = 8
innodb_flush_log_at_trx_commit = 0
innodb_flush_method = O_DSYNC
innodb_io_capacity = 20000
max_connections=5000
max_user_connections=1500
wait_timeout=120
interactive_timeout=120
long_query_time=60
변경 후
[client]
port=3306
socket=/run/mysqld/mysqld.sock
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4
[mysqld_safe]
socket=/run/mysqld/mysqld.sock
[mysqld]
user=mysql
pid-file=/run/mysqld/mysqld.pid
socket=/run/mysqld/mysqld.sock
port=3306
basedir=/usr
datadir=/var/lib/mysql
tmpdir=/tmp
lc-messages-dir=/usr/share/mysql
log_error=/var/log/mysql/error.log
collation-server = utf8mb4_unicode_520_ci
init-connect='SET NAMES utf8mb4'
character-set-server = utf8mb4
symbolic-links=0
local-infile=0
skip-external-locking
key_buffer_size = 512M
max_allowed_packet = 128M
table_open_cache = 512
sort_buffer_size = 64M
read_buffer_size = 64M
read_rnd_buffer_size = 128M
myisam_sort_buffer_size = 512M
thread_cache_size = 64
query_cache_size= 128
#innodb_use_native_aio = 0
default_storage_engine = InnoDB
innodb_buffer_pool_size = 58G
innodb_file_per_table = 1
innodb_log_file_size = 256M
innodb_buffer_pool_instances = 16
innodb_flush_log_at_trx_commit = 0
innodb_flush_method = O_DSYNC
innodb_io_capacity = 20000
max_connections=5000
max_user_connections=1500
wait_timeout=120
interactive_timeout=120
long_query_time=60
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/
글쓴이 | 제목 | 날짜 | |
---|---|---|---|
변신로봇 | 주말 잘 보내시고 계시져?? [1] [1] | 2002/11/17 | 12388 |
letz | 배고프오.. [5] | 2002/11/04 | 12393 |
502 | 502입니다. ^^ [1] | 2002/12/15 | 12399 |
바보야 | No Subject (guest) | 2003/10/22 | 12418 |
슈퍼쿠니 | 윈도우7 설치 후 한 작업들 | 2010/07/25 | 12420 |
미나리엄마 | 으핫!안녕하세요 [1] | 2002/11/24 | 12421 |
민지 | 나 머리빠마했어..+_+ [1] | 2002/10/21 | 12451 |
Jasmine | 아따 오랜만에 들렀서라 -_-/ [2] | 2002/11/10 | 12452 |
Cien | 한동안. [1] | 2003/06/16 | 12461 |
지진;) | 안녕하세요~ [1] | 2003/05/27 | 12464 |
이온디 | 깔루아 밀크 마시고 싶당~ ㅠㅠ | 2010/04/30 | 12485 |
민지 | ㅜ_ㅜ [18] | 2002/10/27 | 12488 |
민서 | 안녕? [1] | 2002/11/17 | 12489 |
불럽 | 허거 [1] | 2008/12/04 | 12504 |
Jaekie | 방문객이 참 많네요? [4] | 2010/11/21 | 12528 |
crash | -_- [1] | 2002/11/29 | 12529 |
RUSHIS | 안녕하세요^^ [2] | 2010/05/18 | 12556 |
쿠키소다 | 이보슈~생일이람서~ [1] | 2002/12/16 | 12579 |
슈퍼쿠니 | xe 레이아웃 참조 스킨 | 2010/07/10 | 12605 |
릿비 | ^_^ 후~ [1] | 2009/03/17 | 12616 |