Update: actually, sometimes the query executes normally. About every third execution shows the strange behaviour described below, and only when executed through the cgi, never when executed directly from the command line.
One would think that this must be related to the cgi, but it does _not_ happen when the cgi is directed to a different mysql server... all servers are solaris sparc, but the working server has 2G ram, the failing server has 1G ram... which also should be plenty, right? (key_buffer_size=500M/300M) -- Roger * I wrote: > 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
