Hello,
To get started, have you tried enabling the slow query log?
http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
"The slow query log can be used to find queries that take a long time to
execute and are therefore candidates for optimization."
Jimmy Guerrero
Sr Product Manager
MyS
in DB is taking
Regards,
Mikhail Berman
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 20, 2007 10:34 AM
To: Ben Edwards
Cc: mysql@lists.mysql.com
Subject: Re: Getting list of queries run against a database
Ben, there's a slow query log feature
Ben Edwards wrote:
We are having a problem with out mysql database (4.2) and think we may
have indexes missing. What we are trying to do is find out the most
popular queries that run. We know there are not may and that they are
relatively simple.
Does anyone know of a tool that allows us to se
mysql@lists.mysql.com
Subject: Re: Getting list of queries run against a database
Ben, there's a slow query log feature that may be just what you're
looking
for:
http://dev.mysql.com/doc/refman/4.1/en/slow-query-log.html
There's an analysis script that will show you the most popul
Ben, there's a slow query log feature that may be just what you're looking
for:
http://dev.mysql.com/doc/refman/4.1/en/slow-query-log.html
There's an analysis script that will show you the most popular slow queries,
too, '*mysqldumpslow'.
You can take those queries and use the EXPLAIN feature to