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 is still slow after optimization on VPS

Discussion in 'Workarounds and Optimization' started by gengle53022, Nov 22, 2010.

  1. gengle53022

    gengle53022 Registered

    Joined:
    Nov 21, 2010
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Hi all,
    I have optimized mysql settings in my VPS, but my site is still much slower than the same site which is on a shared server.

    The VPS is with 8 CPUs and 1G RAM.

    and here is my.inf:
    Is there something wrong with the my.cnf?

    By the way, when I tried to add some innodb options into my.cnf (like innodb_buffer_pool_size), it always failed to restart mysql....what's the matter?

    Thanks for any suggestions.

    ----
    Stephen
     
  2. GaryT

    GaryT Well-Known Member

    Joined:
    May 19, 2010
    Messages:
    321
    Likes Received:
    3
    Trophy Points:
    16
    run mysql tuner and see what it suggests, Posts the outputs.


    Run:

    wait for finish then run:

    Post the outputs :)
     
Loading...

Share This Page