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.


Attachment: signature.asc
Description: This is a digitally signed message part

Reply via email to