Using the Debugging Facility

SQL Output

A debugging facility is available from the tsmariadb process. Execute this program with the following syntax to activate the debugger.

tsmariadb -dn

n

Currently the only debug level is 1. This sends the generated SQL statements to the log file (/usr/lib/basic/tsmariadb.debug). The output in the log file contains a separate line for each generated SQL statement prefixed by the child tsmariadb process id.

While tsmariadb

is active, output for all clients (located on the same server) is sent to one

tsmariadb.debug file.

If the tsmariadb.debug file is copied, output will continue to be placed in the renamed file until the parent tsmariadb process is terminated. A subsequent Basic session would then use a new tsmariadb.debug.

Process Identification

A method is available to associate the child process tsmariadb process with the client process. Execute this program with the following syntax to enable this feature.

tsmariadb -s

By including the –s argument on the tsmariadb command, each time the client logs into the server, information is sent to the tsmariadb.pid file. This file is located in /usr/lib/basic. The format of the information is as follows;

Line 1

parent tsmariadb process

Line 2 – n [child tsmariadb process] [client host name] [client basic process]

From the TS DataServer for MariaDB Reference, version 8.9.1. Open this page in the PDF