Firs of all, thanks for the responses.
To get you more details to chew on. We found the problem and solved it but I would be glad to see how other would attack the problem with this extra information:
Basically on every hit the database write a row in a table in MySQL. The server gets about 5 hits per second from web clients (at least that's what the Apache status said). As long as the above table has 1-2000 rows things work fine the load is around 0 (mostly on the positive side ;) with ocassionally jumpingto 0.30
When the table is around 20.000 rows the load goes up to what I
described in my previous
message.
As this is mostly a logging table we decided to keep it below 2000 rows all the time. What would you do to solve this problem ?
A pure guess, but you might want to look at removing indexes from that table.
Baruch
================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
