Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

join_buffer_size = 2M
tmp_table_size = 24M
max_heap_table_size = 24M
query_cache_size = 256M
key_buffer_size = 512M
thread_cache_size = 4
table_cache = 500
table_open_cache = 96
innodb_buffer_pool_size = 27M
share|improve this question

marked as duplicate by ceejayoz, jscott, Sven, HTTP500, Nathan C Jul 26 '13 at 15:06

This question was marked as an exact duplicate of an existing question.

It's impossible to give you a meaningful answer without a better idea as to the workload on the database.

You might try which will, after leaving the database running under normal conditions for a couple of days, give you some recommendations for changes.

share|improve this answer
So do I need to copy and paste ? and where i need to do this? – user183207 Jul 26 '13 at 15:03
Follow the link -- it's a script you can download and run on your mysql server. – Flup Jul 26 '13 at 15:04
could you please let me know if there how i can find an expert who can debug and optimize my mysql? I am ready to pay for this job. – user183207 Jul 26 '13 at 15:56
Hi, here is the output – user183207 Jul 26 '13 at 18:09
>> MySQLTuner 1.2.0 - Major Hayden <> >> Bug reports, feature requests, and downloads at >> Run with '--help' for additional options and output filtering -------- General Statistics -------------------------------------------------- [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.1.70-cll [OK] Operating on 64-bit architecture – user183207 Jul 26 '13 at 18:11

Not the answer you're looking for? Browse other questions tagged or ask your own question.