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.

Do i need to upgrade my server

Discussion in 'Database Discussions' started by actived, Feb 7, 2013.

  1. actived

    actived Well-Known Member

    Mar 30, 2012
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    Website Owner
    Hi foilks,
    I have a single huge web application which now has a 5GB database, around 150 tables, with a few million rows in some of the bigger tables.
    We also run a testing branch of the web application which means another 5GB database and sometimes the load that goes with it.
    This setup runs on a reputed cloud VPS with 2 cores and 2 GB RAM.

    Of the 2GB RAM, 1GB is allotted in total to Mysql while the rest is for the server as it has cpanel, mailing lists, ftp server, etc all in use. We also use CSF+LFD.

    We get about 2-3 hits per second on both web apps - main and testing.

    I've partitioned all big tables (by range so that regularly used table no partition has more than 40k rows), cached a lot of stuff here and there and so on.

    Do I need to upgrade the server - if yes, would cores help or would RAM help?

    Innodb tuning suggests that I give 80% of RAM to Mysql - but that would leave just 400MB for the server - which would definitely not be enough.

    I've done several iterations of mysql tuning (buffer pool size, query_cache, files_limit, etc etc) a few times over and settled on my current config.

    I want to know whether
    ( a ) I'm running a superbly tuned setup - achieving a great feat running on 2GB
    ( b ) I'm just about tuning the system to have it running and I need to do more to fully extract the power of the hardware.

    This question is very important to us because the cost of adding 1-2 RAM / cores permanently is a bit high for our startup budget.

    PS: Does running mailman create excess load even if it doesnt relay more than a dozen mails a week?

    Thanks in advance,

Share This Page