MySQL Connector/Net Trace
NickName:Simon Hodgson Ask DateTime:2009-09-15T16:05:46

MySQL Connector/Net Trace

Does anyone know a way to enabled Tracing using a TraceListener for the MySQL Connector/net I'd like it to log the SQL Queries that are actually run against the DB, i.e. see the SQL with the parameter values substituted in.

Copyright Notice:Content Author:「Simon Hodgson」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/1425809/mysql-connector-net-trace

Answers
Vladislav Rastrusny 2009-09-16T14:19:22

You can use slow_query_log paramter for inspecting queries that come to your server as of mysql 5.1.21. Just set slow_query_log = 0 and use the option --log-slow-queries[=file_name]. That's all.",


More about “MySQL Connector/Net Trace” related questions

MySQL Connector/Net Trace

Does anyone know a way to enabled Tracing using a TraceListener for the MySQL Connector/net I'd like it to log the SQL Queries that are actually run against the DB, i.e. see the SQL with the parame...

Show Detail

Is MySQL Connector/Net backward compatible?

If I have a MySQL server 5.1, can I use all the onnectors from version 5.1 and above?: Connector/Net 6.1 Connector/Net 6.0 Connector/Net 5.2 Connector/Net 5.1 Clicking http://dev.mysql.com/downlo...

Show Detail

MySQL .NET Connector 6.7.4

I'm am unable to use MySQL Connector 6.7.4 with my local asp.net provider, a security message is being shown saying that it doesn't have the GAC security accesss, anyone know if there's any chance ...

Show Detail

Issues with MySQL Connector Net 6.8.3

So I was getting some problems with connecting .NET and MySQL and figured there was something wrong with the connector. Went into my control panel -> uninstall/repair -> repair MySQL Connector Net ...

Show Detail

MySQL .NET Connector documentation confusion

MySQL 5.0 Connector.NET Examples states: GetBytes returns the number of available bytes in the field. In most cases this is the exact length of the field. However, MySQL 5.0 Connector.NET

Show Detail

MySQL .NET Connector package

I have a few projects that use MySQL Connector for .NET, either directly or through NHibernate. Very simple question: in order to avoid maintaining the Mysql.Data.dll assembly on every project and...

Show Detail

MySQL connector net 6.9.9 setup wizard ended prematurely

I've been running into a couple of issues trying to use the entity framework in visual studio with an MySql database. I Figured I'd just try and reinstall the MySQL Connector net, I uninstalled using

Show Detail

Connection pooling in the MySQL .NET Connector

I'm creating a website in asp.net and mysql, I noticed that the performance of connection pooling in the mysql .net connector is horrible to say the least! For example sql server is 10x times faste...

Show Detail

Very slow opening MySQL connection using MySQL Connector for .net

I am trying to solve the problem of very long response times from MySQL when opening a connection using the MySQL Connector for .net. I have installed MySQL 5.5 running on an Azure VM (Server 2008...

Show Detail

MySQL .NET Connector 6.9.8

I recently had to uninstall and reinstall the MySQL suite, including the connectors for MySQL. Apparently, the .NET connector never properly uninstalled and when I went to reinstall the connector...

Show Detail