MySQL ODBC Connector - Collect SQL Statements

Author

Collect SQL Statements

Moeller, Thorsten, AO

2006-01-26, 4:56 pm

------ _=_NextPart_001_01C6
21C3.793FE62B
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

> Hi,=20
>=20
> is there a possibility to collect the sql statements issued to a mysql
> db to analyse them??=20
>=20
> perhaps there is an extra tool or script for this??=20
>=20
> Thanks for any suggestions!=20
>=20
>=20
>=20

------ _=_NextPart_001_01C6
21C3.793FE62B--

Yani Copas

2006-01-26, 4:56 pm

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/mysql? unsub...sie.nctu.edu.tw

Sponsored Links