gdb 調試MySQL

在編譯安裝完MySQL後，就可以使用gdb來跟蹤mysql伺服器的執行了。

gdb --args /usr/local/mysql/libexec/mysqld

(gdb) b mysql_select
Breakpoint 1 at 0x8228b7d: file sql_select.cc, line 2315.
(gdb) b my_net_read
Breakpoint 2 at 0x81a13e4: file net_serv.cc, line 993.
(gdb) run
Starting program: /usr/local/mysql/libexec/mysqld
[Thread debugging using libthread_db enabled]
[New Thread 0xb7feeb70 (LWP 1373)]
[Thread 0xb7feeb70 (LWP 1373) exited]
[New Thread 0xb77edb70 (LWP 1374)]
110225 22:36:33 [Note] Event Scheduler: Loaded 0 events
110225 22:36:33 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.34-debug'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

此時在登陸用戶端，通過另外一個shelll運行mysql用戶端

gdb會出現如下資訊：

[New Thread 0xb77ccb70 (LWP 1410)]
[Switching to Thread 0xb77ccb70 (LWP 1410)]

Breakpoint 2, my_net_read (net=0x85610bc) at net_serv.cc:993
993      if (!net->compress)
(gdb)

表明設定斷點成功。