mysql参数调优常例

--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.