MySQL Forums
Forum List  »  Performance

Re: Need Perfomance / Tuning Help
Posted by: Jay Pipes
Date: November 21, 2005 06:31AM

By default, the slow query log in MySQL 5.0+ will log any query which takes over long_query_time to complete *and* and query on which a full table scan has been performed, so you could try to upgrade from 4.1 if this is a real benefit. Also, you can try to run mytop or some other utility to show the processlist and SQL code executing.

You can read more about the slow query log here:

and also you might read this chapter on Profiling:

As far as your server variables go, it's tough to recommend anything without knowing a bit more about your server and setup. Could you provide the output of SHOW STATUS? Thanks

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster?

Options: ReplyQuote

Written By
November 21, 2005 05:38AM
Re: Need Perfomance / Tuning Help
November 21, 2005 06:31AM
November 21, 2005 07:26AM
November 22, 2005 08:21PM
November 23, 2005 07:19AM
November 23, 2005 08:54AM

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.