> -----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. -- Daniel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
