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.

MySQL optimize

Discussion in 'Workarounds and Optimization' started by lukapaunovic, Aug 6, 2012.

  1. lukapaunovic

    lukapaunovic Active Member

    Joined:
    Jul 29, 2012
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Užice, Serbia
    cPanel Access Level:
    Root Administrator
    Hi, I bought this dedicated server
    /http://www.hetzner.de/en/hosting/produkte_rootserver/x4/
    I installed cPanel. And I want to sell shared hosting on it.
    Will that be ok?

    I have big CPU usage by MYSQL...
    And I do not know how to optimize it,
    There is much topics about this... but I did not find out anything helpful...

    This is my.cnf file


    Code:
    [mysqld]
    innodb_file_per_table=1
    local-infile=0
    
     
    #1 lukapaunovic, Aug 6, 2012
    Last edited: Aug 7, 2012
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,474
    Likes Received:
    202
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Not sure what you mean that you found nothing helpful. This forum and others have many complete topics full of suggestions.

    Sure thing, you're off to a good start. :)

    Your system already has default preconfigured files you can use to get started that you might like to know about. If you open each of these files and read the top part you'll find out more about them. Pick one that's closest to your system, rename it and replace the default my.cnf with the new one you just renamed to my.cnf and you're off to the races.

    MySQL :: MySQL 5.1 Reference Manual :: 4.2.3.3 Using Option Files
    This thread has a very useful tool you might like to read about here:
    mysqlmymonlite.sh server stats gathering tool for cPanel Server - cPanel Forums

    That thread even has a video to explain things and makes understanding things a bit easier.

    Until someone comes by to diagnose your server for you and provide some more useful tips, the above should get you going in the right direction.


    HTH!
     
  3. lukapaunovic

    lukapaunovic Active Member

    Joined:
    Jul 29, 2012
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Užice, Serbia
    cPanel Access Level:
    Root Administrator
    Sorry, but I did not asked you for cPanel I asked you is this dedicated enough good for shared hosting...
    But never mind.

    I want to move to this server

    /http://www.hetzner.de/en/hosting/produkte_rootserver/ex5
    And I wanted to ask you, is this processor

    Intel® Core™ i7-920 Quadcore
    incl. Hyper-Threading Technology

    Better than

    AMD Athlon 64 X2 5600+ ?

    Because, Intel processor have 4 cores * 2660 MHZ, that is 10640 MHZ
    and AMD processor have 2 cores, but he is
    2 * 2800 = 5600 MHZ

    10640 divided by 5600

    Is 1,9
    So, it means, Intel processor is 1,9 times faster...
     
    #3 lukapaunovic, Aug 7, 2012
    Last edited: Aug 7, 2012
  4. toslim

    toslim Registered

    Joined:
    Aug 7, 2012
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    How can learn my sql optimize? What is my SQL optmize?
     
  5. lukapaunovic

    lukapaunovic Active Member

    Joined:
    Jul 29, 2012
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Užice, Serbia
    cPanel Access Level:
    Root Administrator
    Go and open your own topic... :mad:
     
  6. lukapaunovic

    lukapaunovic Active Member

    Joined:
    Jul 29, 2012
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Užice, Serbia
    cPanel Access Level:
    Root Administrator
    I just want to say a little update, x4 server is a crap, never buy it for shared hosting purposes!
    I bought Hetzner Online AG: Dedicated Server EX 5 and I am really satisficted!
    8 core cpu :)
    Never higher load than 2:00 but I have 3 sites with 10 000 unique visits per day!
    That is awesome!
     
  7. concerto49

    concerto49 Member

    Joined:
    Nov 1, 2012
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    DataCenter Provider
    If you really do need high performance with lots of visitors etc I would recommend no less than hardware (raid card) raid 10 and/or ssd cache. Unless you've got complex calculations you'll be disk/network bound.
     
Loading...

Share This Page