MySQL源码分析整理稿.docxVIP

MySQL源码分析Jon Yao编译安装为了实现MySQL的更高级别的性能调优，我们通常需要理解其内部实现机制，并对其进行优化调试。在下面的系列中，我们会分别介绍MySQL的部分内部实现机制。首先我们介绍如何从源代码部署一台MySQL服务器。下载MySQL源码/downloads/?本文中演示使用的是mysql-5.5.8版本。安装环境：[root@localhost ~]# uname -aLinux nx 2.6.35-24-generic #42-Ubuntu SMP Thu Dec 2 01:41:57 UTC 2010 i686 GNU/Linux[root@localhost ~]# gcc -vUsing built-in specs.Target: i686-linux-gnuConfigured with: ../src/configure -v --with-pkgversion=Ubuntu/Linaro 4.4.4-14ubuntu5 --with-bugurl=file:///usr/share/doc/gcc-4.4/README.Bugs --enable-languages=c,c++,fortran,objc,obj-c++ --prefix=/usr --program-suffix=-4.4 --enable-shared --enable-multiarch --enable-linker-build-id --with-system-zlib --libexecdir=/usr/lib --without-included-gettext --enable-threads=posix --with-gxx-include-dir=/usr/include/c++/4.4 --libdir=/usr/lib --enable-nls --with-sysroot=/ --enable-clocale=gnu --enable-libstdcxx-debug --enable-objc-gc --enable-targets=all --disable-werror --with-arch-32=i686 --with-tune=generic --enable-checking=release --build=i686-linux-gnu --host=i686-linux-gnu --target=i686-linux-gnuThread model: posixgcc version 4.4.5 (Ubuntu/Linaro 4.4.4-14ubuntu5)添加运行MySQL程序的mysql用户(root权限)：groupadd mysqluseradd mysql –g mysqlcmake . -DCMAKE_BUILD_TYPE:STRING=Release -DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql -DCOMMUNITY_BUILD:BOOL=ON -DENABLED_PROFILING:BOOL=ON -DENABLE_DEBUG_SYNC:BOOL=OFF -DINSTALL_LAYOUT:STRING=STANDALONE -DMYSQL_DATADIR:PATH=/usr/local/mysql/data -DMYSQL_MAINTAINER_MODE:BOOL=OFF -DWITH_EMBEDDED_SERVER:BOOL=ON -DWITH_EXTRA_CHARSETS:STRING=all -DWITH_SSL:STRING=bundled -DWITH_UNIT_TESTS:BOOL=OFF -DWITH_ZLIB:STRING=bundled -LHmake make install配置配置MySQL的参数，可以support-files下配置文件的模板：跳转到MySQL安装路径，cmake指定的地址：/usr/local/mysqlcp support-files/f /etc/fvi /etc/f#//////////////////////////////////////////////# Uncomment the following if you are using InnoDB tablesinnodb_data_home_dir = /usr/local/mysql/datainnodb_data_file_path = ibdata1:10M:autoextendinnodb_log_group_home_dir = /usr/local/mysql/data# You can set .._