Daniel, On Dec 16, 2007 12:37 PM, Daniel Caune <[EMAIL PROTECTED]> wrote: > > -----Message d'origine----- > > De: Mark Leith [mailto:[EMAIL PROTECTED] > > Envoyé: dimanche, décembre 16, 2007 04:53 > > À: Daniel Caune > > Cc: mysql@lists.mysql.com > > Objet: Re: Monitoring and analysis tool > > > > Daniel Caune wrote: > > > Hi, > > > > > > Our MySQL server used for our development environment is slowing down, > > > certainly because of a massive query execution by different processes. > > > We are trying to determine which kind of query is the most executed and > > > on which database instance(s). > > > > > > We are quite novice in administrating MySQL. We imagine that we can > > > configure MySQL so that it logs every queries executed in its > > > queries.log file. However is there any analysis tool that would import > > > this log file and that would generate a complete report providing the > > > number of similar queries (same DML order on the same table) per > > > databases per minute? > > > > > > P.S.: we are using mytop and innotop, but it seems that they don't > > > support such a feature. We see a lot of different queries executed > > > against MySQL but we can't figure out, which kind of queries is the most > > > executed, on which database. > > > > > > > Turn on the slow query log (log_slow_queries), set long_query_time to 1 > > (second), and then use the mysqldumpslow tool to aggregate all of the > > slow queries: > > > > Thanks. However how can I trace every queries run against MySQL traced into > slow-queries.log in order to use the mysqldumpslow tool? "The minimum and > default values of long_query_time are 1 and 10, respectively." It seems that > I can't set 0 for long_query_time.
Correct. But if you are willing to patch your server, you can: http://www.mysqlperformanceblog.com/2007/10/31/new-patch-for-mysql-performance/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
