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 seconds to execute or didn't use indexes See http://dev.mysql.com/doc/refman/5.0/en/log-files.html for more info on setting up and analyzing these logs. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -----Original Message----- From: Moeller, Thorsten, AO [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 25, 2006 9:15 AM To: mysql@lists.mysql.com Subject: Collect SQL Statements 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! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
