Although a debugger can be used to debug your application, you may find it beneficial to turn on the debug traces of the connector. Some problems happen randomly which makes them difficult to debug using a debugger. In such cases, debug traces and protocol files are more useful because they allow you to trace the activities of all instances of your program.
DTrace is a very powerful technology to trace any application without having to develop an extra trace module for your application. Unfortunately, DTrace is currently only available on Solaris, Mac OS X 10.5, and FreeBSD.
MySQL Connector/C++ can write two trace files:
Trace file generated by the MySQL client library
Trace file generated internally by MySQL Connector/C++
The first trace file can be generated by the underlying MySQL
client library (
libmysqlclient). To enable this
trace, the connector will call the
mysql_debug() C API function
internally. Because only debug versions of the MySQL client
library are capable of writing a trace file, compile MySQL Connector/C++
against a debug version of the library to use this trace. The
trace shows the internal function calls and the addresses of
internal objects as shown here:
>mysql_stmt_init | >_mymalloc | | enter: Size: 816 | | exit: ptr: 0x68e7b8 | <_mymalloc | >init_alloc_root | | enter: root: 0x68e7b8 | | >_mymalloc | | | enter: Size: 2064 | | | exit: ptr: 0x68eb28 [...]
The second trace is the MySQL Connector/C++ internal trace. It is available
with debug and nondebug builds of the connector as long as you
have enabled the tracing module at compile time using
cmake -DMYSQLCPPCONN_TRACE_ENABLE:BOOL=1. By
default, tracing functionality is not available and calls to trace
functions are removed by the preprocessor.
Compiling the connector with tracing functionality enabled causes two additional tracing function calls per each connector function call. For example:
| INF: Tracing enabled <MySQL_Connection::setClientOption >MySQL_Prepared_Statement::setInt | INF: this=0x69a2e0 | >MySQL_Prepared_Statement::checkClosed | <MySQL_Prepared_Statement::checkClosed | <MySQL_Prepared_Statement::setInt [...]
Run your own benchmark to find out how much this will impact the performance of your application.
A simple test using a loop running 30,000
INSERT SQL statements showed no
significant real-time impact. The two variants of this application
using a trace enabled and trace disabled version of the connector
performed equally well. The runtime measured in real time was not
significantly impacted as long as writing a debug trace was not
enabled. However, there will be a difference in the time spent in
the application. When writing a debug trace, the I/O subsystem may
become a bottleneck.
In summary, use connector builds with tracing enabled carefully. Trace-enabled versions may cause higher CPU usage even if the overall runtime of your application is not impacted significantly.
The example from
demonstrates how to activate the debug traces in your program.
Currently they can only be activated through API calls. The traces
are controlled on a per-connection basis. You can use the
setClientOptions() method of a connection
object to activate and deactivate trace generation. The MySQL
client library trace is always written to a file, whereas the
connector's protocol messages are printed to the standard output.
sql::Driver *driver; int on_off = 1; /* Using the Driver to create a connection */ driver = get_driver_instance(); std::auto_ptr< sql::Connection > con(driver->connect(host, user, pass)); /* Activate debug trace of the MySQL client library (C API) Only available with a debug build of the MySQL client library! */ con->setClientOption("libmysql_debug", "d:t:O,client.trace"); /* Connector/C++ tracing is available if you have compiled the driver using cmake -DMYSQLCPPCONN_TRACE_ENABLE:BOOL=1 */ con->setClientOption("client_trace", &on_off);