Hi we have what we think is a bug regarding an insert (or an update) during times of heavy load on the mysql server. Our application should perform an insert in one table and updates on two other tables but the insert is performed up to 9 times.
I'm not entierly sure that the problem is NOT in out application (PHP CGI which is run via crontab) but I checked it 2 times and 2 collegues checked it too seperatly so it should be okay. It can't be a problem with slow queries because we log them and non of the affected tables show up in the log. The job that is responsible for the high load on the server is a mysqlhotcopy FROM the database where the affected tables reside in to a new DB which isn't used at that time. There is much work and time needed to replicate the error so I would like to know beforehand what I can do to get logs or anything else to track down that problem. Any help or suggestions would be appreciated. Regards -------------------------------------------------- Stefan Immel |N|O|C Network Operation Center -+-+-+------- | Grove Auf der Stuecke 6 Tel. +49 2773-8167-0 35708 Haiger / Germany Fax +49 2773-8167-20 -------------------------------------------------- mailto:[EMAIL PROTECTED] http://www.grove.de "There is always hope, only because it is the one thing nobody's figured out how to kill yet." ~ Galen, Crusade "Racing The Night" -------------------------------------------------- http://www.nocr2.de -> NOC R2 die Lösung für den IT-Workflow -------------------------------------------------- --------------------------------------------------------------------- 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
