MySQL tunning

See also:

• Tuning a MySQL server in 5 minutes

• max_connections - set to the same (or a little bigger than) as MaxChildren from apache if you’re only using one mysql connection per request (this is most common)
• key_buffer_size - Set to roughly half your available ram.
• thread_cache_size - set it until show status like ‘threads_created’ quits increasing.
• table_cache_size - set until show status like ‘opened_tables’ quits increasing. If you have thousands of tables this might not be possible