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/
No Subject (guest)
2003-12-12No Subject (guest)
2004-01-02nex:)
2003-09-18netlify
2023-04-02Merry Christmas~☆
2002-12-22MariaDB 메모리 설정값 변경
2024-05-11LG Uplus 인터넷 속도측정
2024-05-14lg u+
2011-10-12KT에서 SK로 바꾼 후 티셉티콘 방문자도 줄어든 느낌
2024-05-30KT 유심 SK 기계에 넣기
2013-11-18jyp퍼블리싱 견적 짜야하는데 어렵네요 ㅠ
2020-11-04IT 프리랜서 커뮤니티, 어떤 게 필요할까요.
2023-12-19http://snoopybox.co.kr/1402
2011-04-14git 마우스패드 좋네요-_-)/
2022-12-22Eond 홈페이지
2021-12-26CI 디자인
2014-01-16bootmgr 파일을 지우고 나서 부팅이 안된다;;
2010-07-25bbobbi.co.kr 소액자동연장결제 취소하기
2010-12-01AVG 프리 + Comodo 백신 설치~
2013-06-26AMD 서버 운영 중
2024-06-01
댓글 0
댓글작성칸으로