MySQL Forums
Forum List  »  Performance

Query Slow remotely versus locally?
Posted by: Mike Petit
Date: November 30, 2004 12:46PM

Hi folks -

I'm running Mysql 4 on Debian with a 2.6 kernel.

I connect to this server using Coldfusion 5 using the Merant mySQL driver. Performance is poor.

One thing I am noticing is that if I take a query from the slow queries log that run for, say, 13 seconds, and enter mysql from the command line and execute the query directly, it will run in more like 1 second. Why would there be such a differential for the same query?

Put another way, does the slow queries log record the time mySQL spends on the query, or does it add other delays such as network time into the calculation? I cannot figure out why the same query would run 10 times slower when submitted from a different server...ideas?

Thanks to all!

Options: ReplyQuote

Written By
Query Slow remotely versus locally?
November 30, 2004 12:46PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.