maria-developers team mailing list archive

[Alexander Barkov <bar@xxxxxxxxxxx>]

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