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.

We have a dedicated server, a very powerful one, and I don't believe we are getting the most out of MySQL. Even when running ultra-heavy processes that take a very long time to complete, I'm showing minimal CPU & memory usage, as if we have a gattling gun at our disposal, and we're using it to shoot BB's.

I would like to create a setup where MySQL is taking FULL ADVANTAGE of the powerful setup we have going. What kind of settings do I need to add to my.cnf in order to make this happen?

Additionally, I was wondering if there was any way we could control which user accounts would have access to higher performance-levels. Most of the accounts on our server are clients of ours. We have one account specifically that would like to have a giant share of the overall DB usage. Is this possible?

share|improve this question
2  
percona.com –  dmourati Aug 14 '13 at 16:34
    
more specifically Percona Online Tools and MySQL Performance Blog if you want to go at it yourself. Hire Percona or another MySQL consulting organization if you can't figure it out. –  yoonix Aug 14 '13 at 18:19
    
Thank you both. We may end up going the consulting route. Was hoping this might be a simpler solution like serverfault.com/questions/321805/…. Perhaps I should just try these settings first and see where it takes us... –  FurryWombat Aug 14 '13 at 20:42
    
-1 because you didn't even say what storage engine your using. –  HTTP500 Aug 14 '13 at 21:24
    
It's a combination of MyISAM for most, and InnoDB for order & customer tables. –  FurryWombat Aug 15 '13 at 19:34
add comment

closed as too broad by Grant, Falcon Momot, Ward, EEAA, squillman Aug 15 '13 at 12:03

There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer

up vote 0 down vote accepted

It's a very hard thing, it depends on maany maaany other things including database structures. If you want to follow optimal settings and have some improvement with one our post, then only thing I can suggest is to use some tools like this:

https://raw.github.com/major/MySQLTuner-perl/master/mysqltuner.pl

Hire good DBA/Sysadmin.

P.S. MySQL server performance cannot be adjusted for particular DB/user/table etc.

share|improve this answer
add comment

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