mysql 최적화 my.ini 파일 설정

[mysqld] datadir=/home/mysql/ tmpdir=/home/mysqltmp #max_connections = 175 #was 175 max_connections = 80 #max_connect_errors = 350 #was 250 max_connect_errors = 250 safe-show-database skip-locking key_buffer = 1024M # was 128M max_allowed_packet = 6M myisam_sort_buffer_size = 64M #old settings, for 900 ish max maxconn #sort_buffer_size = 32M #read_buffer_size = 32M #read_rnd_buffer_size = 32M so..

원문링크 : mysql 최적화 my.ini 파일 설정