MySQL and lots of writes to big table

Discussion in 'MySQL' started by MySQLGEEK, Aug 29, 2006.

  1. MySQLGEEK

    MySQLGEEK New Member

    Joined:
    Aug 29, 2006
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    0
    I am not sure if this question makes sense, but I have been tasked to find this out:
    What is largest amount of writeable data that MySql can handle before croaking, if the frequency of writes to the same table is about 1 per second? Do we really need Oracle or its ilk to handle a 150 megabyte database that has some fairly light concurrent traffic inserting/updating the same very large table? What if we had 2 tables, one for users A to M and another for users N to Z (just an example, don't take me literally.)
    The MySql would be running under Linux on an Intel Dual 1.5Ghz system with 1 GB memory, pretty fast RAID 5 disks.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice