mysql 源码编译步骤

本文简述在linux环境下编译调试mysql源码方法。

1. 下载源码并解压。下载路径：http://www.mysql.com/downloads/mysql/ 选择source包下载。
2. 解压。tar -xvf mysql-5.1.48.tar.gz
3. 编译。我采用的编译选项为：./configure --prefix=/usr/local/mysql-dbg --with-extra-charsets=complex --enable-thread-safe-client --enable-local-infile --disable-shared --with-innodb --with-debug CC="gcc" CFLAGS="-g  -fno-omit-frame-pointer" CXX="gcc" CXXLAGS="-g -fno-omit-frame-pointer"
4. make & make install.(可以不make install)
5. 使用mysql_install_db 安装启动所需的系统表
6. 在代码目录下找到mysqld 二进制文件 
7. [root@d sql]# ll /home/XXX/mysql-source-code/mysql-5.1.48/sql/mysqld
   -rwxr-xr-x 1 XXX users 30594997 Oct 27 15:57 /home/XXX/mysql-source-code/mysql-5.1.48/sql/mysqld
8. 使用gdb 调试,设置断点，设置启动参数。
9. [root@dwbasis130005 sql]# gdb mysqld GNU gdb Fedora (6.8-37.el5) Copyright (C) 2008 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html> This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "x86_64-redhat-linux-gnu"... (gdb) b MYSQL_BIN_LOG::write [0] cancel [1] all [2] MYSQL_BIN_LOG::write(THD*, st_io_cache*, Log_event*, bool) at log.cc:4721 [3] MYSQL_BIN_LOG::write(Log_event*) at log.cc:4198 > 3 Breakpoint 1 at 0x64e516: file log.cc, line 4198 (gdb) r --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql-5-1-48/ --datadir=/home/mysql/mysql-data/ --user=mysql --log-error=/home/mysql/mysql-data/error.log --pid-file=/home/mysql/mysql-data//dwbasis130004.sqa.cm4.pid --socket=/tmp/mysql.sock --port=3306 Starting program: /home/wuting/mysql-source-code/mysql-5.1.48/sql/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql-5-1-48/ --datadir=/home/mysql/mysql-data/ --user=mysql --log-error=/home/mysql/mysql-data/error.log --pid-file=/home/mysql/mysql-data//dwbasis130004.sqa.cm4.pid --socket=/tmp/mysql.sock --port=3306 Starting program: /home/wuting/mysql-source-code/mysql-5.1.48/sql/mysqld --defau[Thread debugging using libthread_db enabled] lts-file=/etc/my.cnf --basedir=/usr/local/mysql-5-1-48/ --datadir=/home/mysql/my[New Thread 0x2b48ea2f3500 (LWP 9184)] [New Thread 0x42915940 (LWP 9187)] [Thread 0x42915940 (LWP 9187) exited] 101028 14:43:32 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead. sql-data/ --user=mysql --log-error=/home/mysql/mysql-data/error.log --pid-file=/home/mysql/mysql-data//dwbasis130004.sqa.cm4.pid --socket=/tmp/mysql.sock --port=3306[New Thread 0x42915940 (LWP 9188)] [New Thread 0x40b54940 (LWP 9189)] [New Thread 0x41555940 (LWP 9190)] [New Thread 0x43316940 (LWP 9191)] [New Thread 0x43d17940 (LWP 9192)] [Thread 0x43d17940 (LWP 9192) exited] [New Thread 0x44718940 (LWP 9193)] [New Thread 0x45119940 (LWP 9194)] [New Thread 0x45b1a940 (LWP 9195)] [New Thread 0x4651b940 (LWP 9196)] [New Thread 0x41596940 (LWP 9197)] [New Thread 0x415d7940 (LWP 9199)] [Switching to Thread 0x415d7940 (LWP 9199)]  
10. 通过客户端发送一条request, 如 insert 等，既可以在服务器上观察。
11. Breakpoint 1, MYSQL_BIN_LOG::write (this=0xe0ff20, event_info=0x415d54f0) at log.cc:4198 4198 bool MYSQL_BIN_LOG::write(Log_event *event_info) (gdb) Starting program: /home/wuting/mysql-source-code/mysql-5.1.48/sql/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql-5-1-48/ --datadir=/home/mysql/mysql-data/ --user=mysql --log-error=/home/mysql/mysql-data/error.log --pid-file=/home/mysql/mysql-data//dwbasis130004.sqa.cm4.pid --socket=/tmp/mysql.sock --port=3306 Undefined command: "Starting". Try "help". (gdb) Undefined command: "Starting". Try "help". (gdb) bt #0 MYSQL_BIN_LOG::write (this=0xe0ff20, event_info=0x415d54f0) at log.cc:4198 #1 0x000000000058a8f9 in THD::binlog_query (this=0x5a97bb0, qtype=THD::ROW_QUERY_TYPE, query_arg=0x5aecdd0 "insert into example value(1,2)", query_len=30, is_trans=false, suppress_use=false, errcode=0) at sql_class.cc:3961 #2 0x000000000062e0de in mysql_insert (thd=0x5a97bb0, table_list=<value optimized out>, fields=@0x5a99f90, values_list=@0x5a99fd8, update_fields=@0x5a99fc0, update_values=@0x5a99fa8, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:921 #3 0x00000000005b2845 in mysql_execute_command (thd=0x5a97bb0) at sql_parse.cc:3206 #4 0x00000000005b30ae in mysql_parse (thd=0x5a97bb0, inBuf=0x5aecdd0 "insert into example value(1,2)", length=30, found_semicolon=0x415d6dd0) at sql_parse.cc:5994 #5 0x00000000005b432a in dispatch_command (command=COM_QUERY, thd=0x5a97bb0, packet=0x5ae8da1 "insert into example value(1,2)", packet_length=<value optimized out>) at sql_parse.cc:1241 #6 0x00000000005b5316 in do_command (thd=0x5a97bb0) at sql_parse.cc:882 #7 0x00000000005a4f58 in handle_one_connection (arg=<value optimized out>) at sql_connect.cc:1134 #8 0x00000033e12064a7 in start_thread () from /lib64/libpthread.so.0 #9 0x00000033e0ad3c2d in clone () from /lib64/libc.so.6 (gdb)