MySQL Performance Tuning Primer Script

**Jordan** · 14 February, 2009, 08:10 AM

Tuning the performance of MySQL can be a really hard job to do.
There are many thinks to consider and no two servers are identical so there is no universal solution.
Tuning Primer is a script that will help you tune your mysql installation by providing very healthy recommendations based on past mysql records.
For the script to be efficient you must run the mysql server for at least 48 hours.

Installation is extremely simple:

1. Download The Script

wget http://day32.com/MySQL/tuning-primer.sh

2. Change the permissions for the file

chmod 755 tuning-primer.sh

3. Run It
./tuning-primer.sh

# Apply the sugesttions

Found This Script Works Perfect!

Enjoy!

**Will.Spencer** · 14 February, 2009, 09:21 AM

That is one damned fine script.

Docs are here: Sundry MySQL Scripts and Docs

**Jordan** · 14 February, 2009, 10:38 AM

Thanks Will,

**aceeca** · 15 February, 2009, 01:53 AM

Maybe you all know about it, another one I recommend is:

MysqlTuner: MySQLTuner - MySQLTuner

**Will.Spencer** · 16 February, 2009, 09:35 AM

Also very nice!

MySQL can be $%^$%^&$%^U& rocket science to optimize properly. These really help.

**rldowling03** · 2 March, 2009, 08:17 AM

I used the script but do not understand what it did/does

Does it automatically do the adjustments for you?

I am confused, lol

**Will.Spencer** · 2 March, 2009, 12:45 PM

Both scripts just print out recommended changes to your my.cnf file. You must evaluate the recommendations and make the changes yourself.

They helped me improve MySQL performance here. My remaining MySQL performance issues here are the result of bad code.

**kleszcz** · 10 March, 2009, 21:50 PM

Thanks, I was really looking for this type of tools. Im going to improve my shopping cart system.

**stickycarrots** · 10 March, 2009, 22:56 PM

I just code everything perfect and then don't have to worry about these things...

**Will.Spencer** · 12 March, 2009, 11:19 AM

Originally Posted by stickycarrots

I just code everything perfect and then don't have to worry about these things...

Blahahahahaaha!

These script do a bit with MySQL coding, but they relate more to editing your systems my.cnf file to match the hardware and the requirements.

My largest remaining issue is that too many tables are being created on disk, but that's because the coders are using BLOB and TEXT columns.