这个Mysql怎么优化
9511
- vvx.cc2011-06-28论坛元老7669
- # mysql conf /etc/my.cnf
- -
- port = 3306
- socket = /tmp/mysql.sock
- port = 3306
- socket = /tmp/mysql.sock
- skip-external-locking
- key_buffer_size = 128M
- max_allowed_packet = 1M
- table_open_cache = 256
- sort_buffer_size = 1M
- read_buffer_size = 1M
- read_rnd_buffer_size = 2M
- myisam_sort_buffer_size = 8M
- thread_cache_size = 8
- query_cache_size= 16M
- thread_concurrency = 8
- max_connections = 300
- wait_timeout = 30
- interactive_timeout = 30
- max_connect_errors = 9
- long_query_time = 1
- tmp_table_size = 16M
- #log-bin=mysql-bin
- #binlog_format=mixed
- #server-id = 1
- quick
- max_allowed_packet = 8M
- no-auto-rehash
- key_buffer_size = 12M
- sort_buffer_size = 1M
- read_buffer = 1M
- write_buffer = 1M
- interactive-timeout复制代码