How to config mysql-server for heavy load
- by Rasmus
Im in the process of setting up a new database server. I have been running a few mysql database servers before and it has been working okay.
But i would like to hear the recommended setup for my server. For example, what should i set the max connection, query_cache_size, table_cache and so on.
I have arround 4-600 per second:
Open tables: 112…