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 fi
Hello,
MySQL has a few logs that can assist you in capturing statements:
1. The query log shows client connections and executed statements
2. The binary log shows all statements that change data (also used for
replication)
3. The slow log shows all queries that took more than long_query_time
se
