Results 1 to 7 of 7
  1. #1

    massive rows of DB and RAM & CPU?

    hello,

    i have a website it has a mysql DB its not big(only 150 mb) but has massive rows about 400,000 rows in one table of it. 2000 IP users / per day.
    so my php queries a lot of data from mysql DB.... now i am face to choosing correct RAM and CPU for my website. i have two setting which one i should select?

    1-setting 4G RAM and 2G CPU.

    2-setting 2G RAM and 4G CPU

    for me 1st or 2nd one is OK?
    i can choose only one of them... not both 4G. thanks...waiting the responses... thanks to all..

  2. #2
    any answers , thanks.

  3. #3
    waiting for you....

  4. #4
    Join Date
    Jan 2006
    Location
    Alabama
    Posts
    1,276
    It all depends on the types of queries you are running and the intensity of them.

    For example: we have a write-intensive database with well over 800,000,000 rows (the biggest tables have about 350,000,000 each) and is around 115GB that requires basically no CPU, but I have to use about 56GB of RAM for this database to allow it to run smoothly. It's worth noting that this database has tens of millions of rows purged from it daily as well (otherwise we'd be talking hundreds of billions here and the sheer disk size would be ridiculous).

    On the contrary, I have a few databases with only a few hundred thousand rows that require very little RAM but eat CPU like there's no tomorrow.

    In the end, the size and number of rows aren't all that relevant in choosing. It's more about the efficiency of the queries, and how well your DB is indexed.
    KnownHost Managed VPS Specialists
    Fully Managed VPS and Dedicated Servers

    KnownHost is hiring!
    Click here for more information!

  5. #5
    Join Date
    Apr 2002
    Location
    Southern California
    Posts
    114
    What @KnownHost-Jonathan said is correct so use this to help you. If most or all your queries use a defined index then CPU is not as important but if your queries are ad-hock the CPU is very important.
    Dennis Romano - based in Southern California
    PHP applications Developer & Backend website programmer

  6. #6
    thank you very much for your answers... my query is more every time queries whole table. seems need more RAM.

  7. #7
    my query is very simple like this:
    select id, title from table1 order by views;

    to query this efficiently and quickly which setting is correct:


    1-setting 4G RAM and 2G CPU.
    2-setting 2G RAM and 4G CPU

    which one? 1st or 2nd one is OK?
    thanks waiting the answers.

Similar Threads

  1. Replies: 0
    Last Post: 04-08-2013, 02:17 AM
  2. Replies: 0
    Last Post: 03-09-2013, 09:02 AM
  3. Replies: 0
    Last Post: 03-06-2013, 08:49 AM
  4. Replies: 0
    Last Post: 02-24-2013, 10:47 AM
  5. Replies: 0
    Last Post: 02-21-2013, 08:09 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •