This question already has an answer here:
I have a 3GB server with the below settings. The issue I am facing is when I pull some records through the admin panel of my site, sometimes it works well, but most of the times it process very slow.
Can you please suggest the settings?
[mysqld] max_connections=500 join_buffer_size = 2M tmp_table_size = 24M max_heap_table_size = 24M query_cache_size = 256M key_buffer=128M key_buffer_size = 512M thread_cache_size = 4 table_cache = 500 table_open_cache = 96 innodb_buffer_pool_size = 27M slow_query_log local-infile=0