Results 1 to 10 of 10

Thread: MySQL Performance Tuning Primer Script

  1. #1

    Post MySQL Performance Tuning Primer Script

    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!

  2. That is one damned fine script.

    Docs are here: Sundry MySQL Scripts and Docs
    Submit Your Webmaster Related Sites to the NB Directory
    I swear, by my life and my love of it, that I will never live for the sake of another man, nor ask another man to live for mine.

  3. #3

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

    MysqlTuner: MySQLTuner - MySQLTuner

  5. Also very nice!

    MySQL can be $%^$%^&$%^U& rocket science to optimize properly. These really help.
    Submit Your Webmaster Related Sites to the NB Directory
    I swear, by my life and my love of it, that I will never live for the sake of another man, nor ask another man to live for mine.

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

    Does it automatically do the adjustments for you?

    I am confused, lol

  7. 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.
    Submit Your Webmaster Related Sites to the NB Directory
    I swear, by my life and my love of it, that I will never live for the sake of another man, nor ask another man to live for mine.

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

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

  10. Quote Originally Posted by stickycarrots View Post
    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.
    Submit Your Webmaster Related Sites to the NB Directory
    I swear, by my life and my love of it, that I will never live for the sake of another man, nor ask another man to live for mine.

Similar Threads

  1. [WTS] Groupon clone script in PHP / Mysql
    By condo123 in forum Sites
    Replies: 0
    Last Post: 1 September, 2010, 13:22 PM
  2. Replies: 0
    Last Post: 21 April, 2010, 17:35 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •