Results 1 to 10 of 10

Thread: MySQL Performance Tuning Primer Script

  1. #1
    Jordan is offline Newbie Net Builder
    Join Date
    Dec 2008
    Posts
    59
    Blog Entries
    1
    Thanks
    83
    Thanked 8 Times in 5 Posts

    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. Thanked by:

    kleszcz (10 March, 2009), Will.Spencer (16 February, 2009)

  3. #2
    Will.Spencer's Avatar
    Will.Spencer is offline Retired
    Join Date
    Dec 2008
    Posts
    5,033
    Blog Entries
    1
    Thanks
    1,010
    Thanked 2,327 Times in 1,258 Posts
    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.

  4. #3
    Jordan is offline Newbie Net Builder
    Join Date
    Dec 2008
    Posts
    59
    Blog Entries
    1
    Thanks
    83
    Thanked 8 Times in 5 Posts

  5. #4
    aceeca is offline Unknown Net Builder
    Join Date
    Feb 2009
    Posts
    3
    Thanks
    0
    Thanked 3 Times in 2 Posts
    Maybe you all know about it, another one I recommend is:

    MysqlTuner: MySQLTuner - MySQLTuner

  6. Thanked by:

    kleszcz (10 March, 2009), Will.Spencer (16 February, 2009)

  7. #5
    Will.Spencer's Avatar
    Will.Spencer is offline Retired
    Join Date
    Dec 2008
    Posts
    5,033
    Blog Entries
    1
    Thanks
    1,010
    Thanked 2,327 Times in 1,258 Posts
    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.

  8. #6
    rldowling03's Avatar
    rldowling03 is offline Newbie Net Builder
    Join Date
    Jan 2009
    Location
    Adelaide, Australia
    Posts
    25
    Thanks
    1
    Thanked 1 Time in 1 Post
    I used the script but do not understand what it did/does

    Does it automatically do the adjustments for you?

    I am confused, lol

  9. #7
    Will.Spencer's Avatar
    Will.Spencer is offline Retired
    Join Date
    Dec 2008
    Posts
    5,033
    Blog Entries
    1
    Thanks
    1,010
    Thanked 2,327 Times in 1,258 Posts
    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.

  10. #8
    kleszcz's Avatar
    kleszcz is offline Unknown Net Builder
    Join Date
    Mar 2009
    Posts
    6
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Thanks, I was really looking for this type of tools. Im going to improve my shopping cart system.

  11. #9
    stickycarrots's Avatar
    stickycarrots is offline Experienced Net Builder
    Join Date
    Dec 2008
    Location
    QuickInbox.com
    Posts
    753
    Blog Entries
    6
    Thanks
    18
    Thanked 86 Times in 59 Posts
    I just code everything perfect and then don't have to worry about these things...

  12. #10
    Will.Spencer's Avatar
    Will.Spencer is offline Retired
    Join Date
    Dec 2008
    Posts
    5,033
    Blog Entries
    1
    Thanks
    1,010
    Thanked 2,327 Times in 1,258 Posts
    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
  •