On Wed, 2003-05-28 at 13:30, Steven Critchfield wrote: > Don't use Mysql. if you ever have had to deal with it in a production > environment that works it over, you will know that as it reaches it's > limits, it starts a death spiral that is very difficult to recover from. > For our software on a dual P3 866 with a gig of ram, the limit was > around 1.5 queries a second fairly mixed update, inserts, and selects. > Total file size of the database was under 200meg, and was fully cached > so even though we had hardware raid 5 across 4 10K rpm ultra160 drives, > it shouldn't have mattered for the selects. >
I'd check what configuration problem you have with mysql then. Uptime: 48 days 1 hour 42 min 6 sec Threads: 15 Questions: 376005206 Slow queries: 22 Opens: 214 Flush tables: 1 Open tables: 64 Queries per second avg: 90.531 This is a mixture of inserts updates and selects as well. slashdot.org runs mysql at loads way over this, and it continues to run, although its very select heavy most likely.
signature.asc
Description: This is a digitally signed message part