Tracking SQL Calls From MS Access to MySQL
I'm trying to 'see' the SQL statements that are sent from MS Access 2003 to MySQL via ODBC.
I've tried ODBC Tracing, but it's painfully slow, producing very large log files which are very difficult to read.
For example, and insert looked like this:
"INSERT INTO `tracking` (`contract_id`,`bp_id`,`csi_1`,`csi_2a`,`csi_2b`,`csi_code`,`item_number`,`csi_code_display`,`csi_name`)
VALUES (?,?,?,?,?,?,?,?,?)\ 0"
It doesn't show the values, I think they are coded separately as SQLBindParameters, but I can't make out the values in those either.
Is there an alt开发者_高级运维ernate/better method that I can use to simply see the full SQL statements?
MTIA
MySQL Proxy should do what you're after.
I don't know why this question popped up today in the "new questions" list, but it did, and I just Googled "sql profiler for mysql" and came up with this:
http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html
I don't know if it is better, or if it works with the version of MySQL used by the original question, but I thought it might be useful to others who came to the question.
精彩评论