MySQL ODBC Connector - Collect SQL Statements

Author

Collect SQL Statements

Moeller, Thorsten, AO

2006-01-26, 4:56 pm

------ _=_NextPart_001_01C6
21C2.0BF6C67A
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

Hi,=20

is there a possibility to collect the sql statements issued to a mysql
db to analyse them??=20

perhaps there is an extra tool or script for this??=20

Thanks for any suggestions!=20

------ _=_NextPart_001_01C6
21C2.0BF6C67A--

Jimmy Guerrero

2006-01-26, 4:56 pm

Hello,

MySQL has a few logs that can assist you in capturing statements:

1. The query log shows client connections and executed statements=20
2. The binary log shows all statements that change data (also used for
replication)=20
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,=20

Jimmy Guerrero, Senior Product Manager
MySQL Inc, www.mysql.com =20
Houston, TX USA

-----Original Message-----
From: Moeller, Thorsten, AO [mailto:Thorsten.Moeller@atosorigin.com]=20
Sent: Wednesday, January 25, 2006 9:15 AM
To: mysql@lists.mysql.com
Subject: Collect SQL Statements

Hi,=20

is there a possibility to collect the sql statements issued to a mysql =
db to
analyse them??=20

perhaps there is an extra tool or script for this??=20

Thanks for any suggestions!=20

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links