mysql参数调优常例

tigerjxh

--join_buffer_size=1044480(1m)
The size of the buffer that is used for full joins.
--key_buffer_size=256M
The size of the buffer used for index blocks. Increase
this to get better index handling (for all reads and
multiple writes) to as much as you can afford; 64M on a
256M machine that mainly runs MySQL is quite common.
--max_write_lock_count=#
After this many write locks, allow some read locks to run
in between.
--myisam_sort_buffer_size=64M
The buffer that is allocated when sorting the index when
doing a REPAIR or when creating indexes with CREATE INDEX
or ALTER TABLE.
--read_buffer_size=1M
Each thread that does a sequential scan allocates a
buffer of this size for each table it scans. If you do
many sequential scans, you may want to increase this
value.
--sort_buffer_size=64M
Each thread that needs to do a sort allocates a buffer of
this size.
--table_cache=1024 The number of open tables for all threads.
--tmp_table_size=33M
if an in-memory temporary table exceeds this size, MySQL
will automatically convert it to an on-disk MyISAM table.
--max_tmp_tables=# Maximum number of temporary tables a client can keep open
at a time.
--max_write_lock_count=#
After this many write locks, allow some read locks to run
in between.
--thread_concurrency=#
Permits the application to give the threads system a hint
for the desired number of threads that should be run at
the same time.
--thread_cache_size=#
How many threads we should keep in a cache for reuse.


本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u2/67466/showart_1077025.html