Moeller, Thorsten, AO wrote:
Hi,
is there a possibility to collect the sql statements issued to a mysql
db to analyse them??
perhaps there is an extra tool or script for this??
Thanks for any suggestions!
I don't know about collecting all queries, but we're doing this in
our my.cnf file:
# install slow query log
long_query_time = 10
log_slow_queries = /var/log/httpd/mysql_slow_query.log
On a server running 4.0.20
It's not a box I set up, so I don't know if you have to do
anything special to get it working, but I've noticed that
it's there, and is working. Might be what you're looking for.
Yani
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]