Activity Stream
48,167 MEMBERS
6828 ONLINE
besthostingforums On YouTube Subscribe to our Newsletter besthostingforums On Twitter besthostingforums On Facebook besthostingforums On facebook groups

Page 1 of 4 123 ... LastLast
Results 1 to 10 of 31
  1.     
    #1
    Super Member

    Default 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:

    Code: 
    wget http://mysqltuner.com/mysqltuner.pl
    Make executable:

    Code: 
    chmod 755 mysqltuner.pl
    Run MySQLTuner:

    Code: 
    ./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:

    Code: 
    /etc/my.cnf
    If you don't understand what it is telling you ask me here
    Sp32 Reviewed by Sp32 on . 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

    So kiss me and smile for me, say that you'll wait for me <'3

  2.   Sponsored Links

  3.     
    #2
    Member
    Website's:
    mytinydick.com
    Does it have to be a dedi? Can it be a simple VPS?

    Bad bitch in my chevy.

  4.     
    #3
    Retired NinJa
    Website's:
    loledhard.com
    i guess this can be used even on VPSes



    You don't hate Justin bieber.You hate the fact you ain't Justin Bieber!

  5.     
    #4
    It begins...
    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.

  6.     
    #5
    JGM
    Cheers Sp32 will have to check this out! Are the codes the same on Debian?

    JGM.

  •     
    #6
    Super Member
    Yeah, I'd assume this will work the same on Debian.

    So kiss me and smile for me, say that you'll wait for me <'3

  •     
    #7
    Banned
    Website's:
    LinkDDL.com DDLShack.net IhateDowntime.co
    If you are using cPanel you can run this command.

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

  •     
    #8
    Retired NinJa
    Website's:
    loledhard.com
    should be bumped

    Actual this sqltuner seems sexy.....



    You don't hate Justin bieber.You hate the fact you ain't Justin Bieber!

  •     
    #9
    Member
    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

    Made by Envee :P

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



    Thanks

    JGM.

  • Page 1 of 4 123 ... LastLast

    Thread Information

    Users Browsing this Thread

    There are currently 1 users browsing this thread. (0 members and 1 guests)

    Similar Threads

    1. [Hiring] someone to optimize DLE script
      By downfreak in forum Completed Transactions
      Replies: 4
      Last Post: 25th Sep 2011, 05:31 AM
    2. [Hiring] Someone to optimize Mysql
      By samipk in forum Completed Transactions
      Replies: 3
      Last Post: 19th Jul 2011, 09:01 PM
    3. mysql usage 99.8%|Site Not Loading|Please help to optimize
      By raj1126 in forum Technical Help Desk Support
      Replies: 18
      Last Post: 11th Nov 2010, 05:59 AM
    4. Looking for someone to optimize Wordpress and IPB
      By Neokenzo in forum Webmaster Discussion
      Replies: 2
      Last Post: 24th Nov 2009, 05:50 PM
    5. How to optimize mysql
      By vgnheart in forum Server Management
      Replies: 1
      Last Post: 20th Jun 2009, 10:59 AM

    Tags for this Thread

    BE SOCIAL