Hi Sriram,

On 05/17/2014 10:00 AM, sriram patil wrote:
Hi Alexander,

I wanted to run mysqld in debug mode to check the trace file and get to
know workflow of SQL commands. I tried following command

mysqld --user=<username> --debug

Then, after connecting I executed some commands. But, the trace file is
not created in /tmp folder.

Is there anything I need to do while building the source code in order
for the debug mode to work?

Make sure that you compile a debug binary rather than
a release binary (which is default).


I usually compile and install like this:

cmake . -DCMAKE_BUILD_TYPE=Debug -DCMAKE_INSTALL_PREFIX=/opt/mariadb-10.0
make
make install


The "-DCMAKE_BUILD_TYPE=Debug" part is responsible to enable a debug build.


Note, you can check which version you're running by using this SQL query:


SELECT VERSION();


In case of a debug build it will be:

+-----------------------+
| version()             |
+-----------------------+
| 10.0.11-MariaDB-debug |
+-----------------------+


and in case of a release build it will be just:

+-----------------+
| version()       |
+-----------------+
| 10.0.10-MariaDB |
+-----------------+


Note, before re-running cmake, it's usually a good idea to remove
its cache file like this:

rm CMakeCache.txt



Thanks,
Sriram

_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Reply via email to