Generating trace files for MySQL

traceFiles
MySQL should be compiled with debug on option to enable trace file generation. Issue mysqld -V command to find out if it shall been compiled with debug option. If the version number ends with -debug,then the binary is compiled with support for trace files.

The default way of generating the trace files is to invoke mysqld as under:
  • mysqld --debug.
The size of the trace file is huge with this option. You can limit the output in trace file by invoking mysqld as under:
  • mysqld --debug=d,info,error,query,general,where :o,/tmp/mysqld.trace

For more info refer to the following URL:
  • http://www.tol.it/doc/MySQL/appendixC.html
  •  http://dev.mysql.com/doc/refman/5.1/de/the-dbug-package.html
Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Ritu Kamboj

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today