Hi, we have a mysql server with a strange behaviour: when we execute a query, it takes about 5 seconds, even for simple selects which should return almost immediately.
I run "mysqladmin --sleep=1 processlist" to see what happens, and the process is in 'sleep' mode for 5 seconds. I never see the actual query, I don't know if it sleeps for 5 seconds, then execute the query, or if it executes the query, then sleeps for 5 seconds. The returned result is correct. We have tried different queries, the result is the same for all. The server have been working for months, and we have never seen this behaviour before. We did some changes today (tried to configure replication), but undoing the changes did not make the error disappear... The error only happens when we run the query from our python-based cgi, not when we run the same query directly from the command line (using "mysql -v -v -v database<statement.sql" it shows a execution time of 0.09 sec). The error does not happen when we run it against a different mysql server (with identical database, our future slave), using the same cgi... Platform is solaris sparc, version is 3.23.39. Have anyone seen this behaviour before? -- Roger --------------------------------------------------------------------- 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
