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 ? Gabor ================================================================= 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]
