• # 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复制代码