Go4Expert (http://www.go4expert.com/)
-   MySQL (http://www.go4expert.com/forums/mysql-forum/)
-   -   MySQL and lots of writes to big table (http://www.go4expert.com/forums/mysql-lots-writes-table-t1293/)

MySQLGEEK 29Aug2006 09:04

MySQL and lots of writes to big table
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.

All times are GMT +5.5. The time now is 01:44.