Viewing ALL queries to MySQL...

RH · Post by RH » Mon 18 Sep 2006 17:45

Is there anyway to view all the queries that the MySQL server gets ?

I tried to drop the TMySQlMonitor component on the the form of the demo project "Loader". Then I started CoreLabs DBMonitor. The DBMonitor showed some sql queries, but not all. For instance pressing the load button on the "loader" demo form, causes inserts into the database. However these inserts were not shown...

Is there a way to inspect simply EVERY transaction between an application and the MySQL Database. Even a use statement, a statement fetching record count... Evereything in detail ?

I am thinking about something like a packet sniffer, that intercepts every thing between the database server and the application.

I appreciate any input

Kind regards

Zagawa · Post by **Zagawa** » Tue 19 Sep 2006 09:44

Hello,

I think you should see that :

http://dev.mysql.com/doc/refman/5.0/en/query-log.html

RH · Post by RH » Tue 19 Sep 2006 18:47

thats all I need. Thanks

Antaeus · Post by **Antaeus** » Wed 20 Sep 2006 11:00

We have not added logging to TMyLoader component because of performance reasons. TMyLoader is destined for extremely quick loading data to the server, so logging would slow down loading. TMyLoader executes commands with Connection.ExecSQL() method. This method also does not support logging, so all queries executed by this method will not be logged.