Best MySQL Optimizing Guide

JannuBl22t

Member
Dec 7, 2010
9
0
51
Hey there!

Do you guys know the best MySQL optimizing guide.. I haven't optimized my MySQL and it's super slow so I would like to optimize it little bit.

Thank you in advance
 

alphawolf50

Well-Known Member
Apr 28, 2011
186
2
68
cPanel Access Level
Root Administrator
I've never watched this, but it is presented by the cPanel folks.
MySQL Optimization | cPanel Video Site

Also, anything by Peter Zaitsev is pretty much gold. i.e. What to tune in MySQL Server after installation - MySQL Performance Blog

If that doesn't help, the community is usually willing to help out. If you'd like assistance, please post the following:
  • Hardware specs (#cpu cores, RAM)
  • Contents of /etc/my.cnf
  • Output of mysqltuner.pl
  • Output of top

Please place the output of any commands/scripts inside CODE tags so that it is easier for everyone to read.
 
Last edited: