Haai, I'm experiencing the following problem:
I have a dual 1 Ghz machine running RH 7.1 running mysql server version 3.23.39. Everything is just based on default configurations as provided by the rpms. This machine has 1 client (a java program running on another machine) that does some serious inserting and updating on the database. The insert and update statements are done on different tables, i.e. 1 insert on table A, 1 update on table B. We measure about 15000 inserts and 15000 updates per minute, i.e. 30000 write operations per minute are performed. After +/- 2000000 write operations the performance suddenly drops to +/- 12000 write operations per minute. If we restart our client application without emptying the tables, we are back on the average of 30000 write operations per minute. And again after +/- 2000000 write operations the mysterious performance drop occurs again... Is mysql doing some automatic maintenance or something else? Help in giving an explanation for this behaviour is much appriciated. Greetings, Jeroen. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
