??????????
????????????skip-name-resolve
????skip-name-resolve??????????DNS??????????MySQL????????DNS???????????????μ???????????MySQL???????????????DNS????????????????????ò????????????????????????????ip??????????????localhost?????127.0.0.1
???????y????
???????????????????????????????ο?????????????????г????????????????????н????????????

 

MySQL???? ????????
table_open_cache ???????????????????????????????????????????512
query_cache_type ?????????innodb???棬?????0????????MyISAM???棬?????1?????д???????????????2
query_cache_size ???????????????е?????????????????256MB
binlog_cache_size ?????2MB??4MB?????????????????????д??????????????????????????????????32MB
key_buffer_size ????????MyISAM???棬?????????????????MyISAM????????????????￡??????????ο?? 512MB
bulk_insert_buffer_size ???????????????????????????????????????????????????????????????????32MB
innodb_buffer_pool_size ????????InnoDB???棬??????????????????InnoDB????????????????￡?????????50% ~ 80%???
innodb_log_buffer_size ?????1MB????????????????????????????4MB ~ 16MB
innodb_max_dirty_pages_pct ??????????????????????????????????????????90
max_connections ?????????????????ù???????????????????100??????256 - 512
back_log ????????50?????? 128 - 256
wait_timeout ?????interactive_timeout?????28800??8С?????????120 ~ 300
 
????
?????????????MySQL????
????# ?????MySQL???????
????mysql> show global status like 'Thread_%';
????# ?????MySQL???????
????mysql> show global variables like '%binlog%';