Devart Forums

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

Hello,

I think you should see that :

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

thats all I need. Thanks

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.