mysql优化脚本！

[mysqld] #port = 3306 #socket = /tmp/mysql.sock #socket = /var/lib/mysql/mysql.sock #skip-locking key_buffer = 128M max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 1M net_buffer_length = 16K myisam_sort_buffer_size = 1M max_connections=120 #addnew config wait_timeout =120 back_log=100 read_buffer_size = 1M thread_cache=32 #skip-innodb #skip-bdb #skip-name-resolve join_buffer_size=512k query_cache_size = 64M interactive_timeout=120 long_query_time=10 log_slow_queries= /usr/local/mysql/slow_query.log query_cache_type= 1 # Try number of CPU's*2 for thread_concurrency thread_concurrency = 4

Post a comment — Trackback URI RSS 2.0 feed for these comments This entry (permalink) was posted on Saturday, August 16, 2008, at 12:45 pm by askie. Filed in LAMP, mysql and tagged mysql, 优化, 脚本.

记录与PHP的PK经历