Optimize MySQL - MySQLTuner

[Sp32]

Hiya guys, if any of you own a dedicated server and want to reduce the MySQL load hopefully I can help. Before doing the following steps it is advised to have had the MySQL service running for at least 24 hours, preferred 48 hours +

CentOS:

Download MySQLTuner:

wget http://mysqltuner.com/mysqltuner.pl

Make executable:

chmod 755 mysqltuner.pl

Run MySQLTuner:

./mysqltuner.pl

Then the output will display what you need to do/can do to increase performance. Most of the configuration will lay in the following file:

/etc/my.cnf

If you don't understand what it is telling you ask me here

Sp32 Reviewed by Sp32 on 7th Dec 2011. Optimize MySQL - MySQLTuner Hiya guys, if any of you own a dedicated server and want to reduce the MySQL load hopefully I can help. Before doing the following steps it is advised to have had the MySQL service running for at least 24 hours, preferred 48 hours + CentOS: Download MySQLTuner: wget http://mysqltuner.com/mysqltuner.plMake executable: chmod 755 mysqltuner.plRun MySQLTuner: Rating: 5

[Djlatino]

Does it have to be a dedi? Can it be a simple VPS?

[CJ]

i guess this can be used even on VPSes

[Lifetalk]

Yes. As long as you have root, you can run MySQLTuner. Excellent program, and works a fucking treat when you need to optimize your SQL.

[JGM]

Cheers Sp32 will have to check this out! Are the codes the same on Debian?

JGM.

[Sp32]

Yeah, I'd assume this will work the same on Debian.

[c0rrupt]

If you are using cPanel you can run this command.

/usr/local/cpanel/3rdparty/mysqltuner/mysqltuner.pl

[CJ]

should be bumped

Actual this sqltuner seems sexy.....

[Putin]

mysql cpu load is 465% at the moment.

I ran mysqltuner and it pointed a few issues - I'll report back and tell you if they helped reduce the load

update: didn't do me any favours. I know it's probs the php running - many crawlers - just a shame that they use so much load

[JGM]

Hey Sp32 could you take a look at this please for me I am rather lost



Thanks

JGM.