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/
글쓴이 | 제목 | 날짜 | |
---|---|---|---|
좀비마스터 | 재 난입 -_-; [3] | 2004/05/24 | 10675 |
dindi | ^^ [1] | 2004/05/25 | 10968 |
coolboy | 안녕하세요~~눈팅만 하다...;;; [1] | 2004/05/29 | 10344 |
유승철 | 써핑중 우연히 들렀습니다.. [1] | 2004/06/01 | 10514 |
크리스 | 아하하하하...ㅋㅋ [1] | 2004/06/01 | 10466 |
☜Dr.Maeno☞ | 뭔가 끄적이고 갑니다 [1] | 2004/06/02 | 9760 |
Lois | 와봤어요^^ [1] | 2004/06/04 | 10067 |
모노 | 뭐야 이거 +_+ [1] | 2004/06/08 | 10100 |
DiNE | 방갑습니다 [1] | 2004/06/08 | 10346 |
명정보 | 정낙훈씨 연락 바랍니다. [2] | 2004/06/10 | 9922 |
한드쟌 | 웹서핑하다 넘어짐 | 2004/06/16 | 10719 |
김승애 | 정낙훈씨 | 2004/06/28 | 11205 |
박민수 | 구경잘했습니다.^^ | 2004/07/13 | 11110 |
RECLUSE | 낙훈씨 잘 살고 있죠? | 2004/07/19 | 10978 |
swf. | 어쩔까?; | 2004/08/06 | 10872 |
민지 | 제목도써? [1] | 2004/08/16 | 10816 |
날아라루나 | +_+ | 2004/08/22 | 3502 |
lime | 리디님 이벤트 참여중...-0- | 2004/09/26 | 10817 |
민지 | 나야낙훈아 [1] | 2004/09/30 | 10467 |
DiNE | 안녕하세욧 [1] | 2004/10/24 | 10648 |