The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Best MySQL Optimizing Guide

Discussion in 'Database Discussions' started by JannuBl22t, Dec 16, 2011.

  1. JannuBl22t

    JannuBl22t Member

    Joined:
    Dec 7, 2010
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Hey there!

    Do you guys know the best MySQL optimizing guide.. I haven't optimized my MySQL and it's super slow so I would like to optimize it little bit.

    Thank you in advance
     
  2. alphawolf50

    alphawolf50 Well-Known Member

    Joined:
    Apr 28, 2011
    Messages:
    186
    Likes Received:
    2
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    I've never watched this, but it is presented by the cPanel folks.
    MySQL Optimization | cPanel Video Site

    Also, anything by Peter Zaitsev is pretty much gold. i.e. What to tune in MySQL Server after installation - MySQL Performance Blog

    If that doesn't help, the community is usually willing to help out. If you'd like assistance, please post the following:
    • Hardware specs (#cpu cores, RAM)
    • Contents of /etc/my.cnf
    • Output of mysqltuner.pl
    • Output of top

    Please place the output of any commands/scripts inside CODE tags so that it is easier for everyone to read.
     
    #2 alphawolf50, Dec 16, 2011
    Last edited: Dec 16, 2011
  3. tank

    tank Well-Known Member

    Joined:
    Apr 12, 2011
    Messages:
    236
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Chicago, IL
    cPanel Access Level:
    Root Administrator
    Just watched and looked at both of these. Gold is right. thanks alphawolf50. It seems I am never done learning.
     
Loading...

Share This Page