Re: limiting load of mysql

[Michael Widenius]

Hi!

<cut>

Andreas> Yes, but we have about 300 updates/inserts per second, from which 80% are
Andreas> updates...
Andreas> And these are absolute high priority ! Nothing lames more than old data :-)
Andreas> BTW we use no locks. Only for a temp table, which isn't queried often...

In this case you may want to try MySQL 3.23.8;  At least the inserts
should not lock the tables (assumes you don't do many deletes).

Using delay_key_writes on some tables may also help a lot!
(I recently update the MySQL manual with this)

Regards,
Monty