Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
share|improve this question

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

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1 Answer 1

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

You might try mysqltuner.pl 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 mysqltuner.pl ? 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 <major@mhtx.net> >> Bug reports, feature requests, and downloads at mysqltuner.com >> 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.