Focus On Oracle

Installing, Backup & Recovery, Performance Tuning,
Troubleshooting, Upgrading, Patching

Oracle Engineered System


当前位置: 首页 » 技术文章 » MySQL

Build Mysql Debug Release from Source Code 5.7.15

MySQL是一个关系型数据库管理系统,由瑞典MySQL AB 公司开发,目前属于Oracle旗下产品。MySQL在WEB应用方面MySQL是最好的关系数据库管理系统应用软件之一。MySQL所使用的SQL语言是用于访问数据库的最常用标准化语言。MySQL软件采用了双授权政策,它分为社区版和商业版,由于其体积小、速度快、总体拥有成本低,尤其是开放源码这一特点,一般中小型网站的开发都选择 MySQL 作为网站数据库。



首先我们需要从官网上下载mysql源码,然后尝试编译为Debug版本。可以更多的了解编译过程,进而可以更好的让我们理解MySQL。

登录http://dev.mysql.com/downloads/mysql/


下载Generic Linux (Architecture Independent), Compressed TAR Archive Includes Boost Headers

http://dev.mysql.com/downloads/file/?id=465370



安装需要的包和编译器

yum install ncurses ncurses-devel
yum install cmake
yum groupinstall "Development Tools"
[root@ohs2 opt]# yum install ncurses ncurses-devel
Loaded plugins: refresh-packagekit, security, ulninfo
Setting up Install Process
Package ncurses-5.7-4.20090207.el6.x86_64 already installed and latest version
Package ncurses-devel-5.7-4.20090207.el6.x86_64 already installed and latest version
Nothing to do
[root@ohs2 opt]# yum install cmake
Loaded plugins: refresh-packagekit, security, ulninfo
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package cmake.x86_64 0:2.8.12.2-4.el6 will be installed
--> Finished Dependency Resolution
Warning: RPMDB altered outside of yum.
Installed:cmake.x86_64 2.8.12.2-4.el6                                                                                                                           
Complete!
[root@ohs2 opt]# yum groupinstall "Development Tools"
Loaded plugins: refresh-packagekit, security, ulninfo
Setting up Group Process
Package flex-2.5.35-9.el6.x86_64 already installed and latest version
Package gcc-4.4.7-17.el6.x86_64 already installed and latest version
Package redhat-rpm-config-9.0.3-51.0.1.el6.noarch already installed and latest version
Package rpm-build-4.8.0-55.el6.x86_64 already installed and latest version
Package 1:make-3.81-23.el6.x86_64 already installed and latest version
Package patch-2.6-6.el6.x86_64 already installed and latest version
Package 1:pkgconfig-0.23-9.1.el6.x86_64 already installed and latest version
Package gettext-0.17-18.el6.x86_64 already installed and latest version
Package automake-1.11.1-4.el6.noarch already installed and latest version
Package bison-2.4.1-5.el6.x86_64 already installed and latest version
Package libtool-2.2.6-15.5.el6.x86_64 already installed and latest version
Package autoconf-2.63-5.1.el6.noarch already installed and latest version
Package gcc-c++-4.4.7-17.el6.x86_64 already installed and latest version
Package binutils-2.20.51.0.2-5.44.el6.x86_64 already installed and latest version
Package patchutils-0.3.1-3.1.el6.x86_64 already installed and latest version
Package byacc-1.9.20070509-7.el6.x86_64 already installed and latest version
Package indent-2.2.10-7.el6.x86_64 already installed and latest version
Package systemtap-2.9-4.0.1.el6.x86_64 already installed and latest version
Package diffstat-1.51-2.el6.x86_64 already installed and latest version
Package elfutils-0.164-2.el6.x86_64 already installed and latest version
Package cvs-1.11.23-16.el6.x86_64 already installed and latest version
Package rcs-5.7-37.el6.x86_64 already installed and latest version
Package subversion-1.6.11-15.el6_7.x86_64 already installed and latest version
Package gcc-gfortran-4.4.7-17.el6.x86_64 already installed and latest version
Package 1:doxygen-1.6.1-6.el6.x86_64 already installed and latest version
Package intltool-0.41.0-1.1.el6.noarch already installed and latest version
Package git-1.7.1-4.el6_7.1.x86_64 already installed and latest version
Package ctags-5.8-2.el6.x86_64 already installed and latest version
Package cscope-15.6-7.el6.x86_64 already installed and latest version
Package swig-1.3.40-6.el6.x86_64 already installed and latest version
Warning: Group development does not have any packages.
No packages in any requested group available to install or update
[root@ohs2 opt]# 

查看编译器版本
[root@ohs2 opt]# cmake -version
cmake version 2.8.12.2
[root@ohs2 opt]# make --version
GNU Make 3.81
Copyright (C) 2006  Free Software Foundation, Inc.
This is free software; see the source for copying conditions.
There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE.

This program built for x86_64-redhat-linux-gnu
[root@ohs2 opt]# gcc --version
gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-17)
Copyright (C) 2010 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
[root@ohs2 opt]# 

Preconfiguration setup

[root@ohs2 opt]# which mysql
/usr/bin/mysql
[root@ohs2 opt]#
移除默认安装的mysql包
[root@ohs2 ~]# rpm -qa|grep mysql
mysql-5.1.73-7.el6.x86_64
mysql-devel-5.1.73-7.el6.x86_64
mysql-libs-5.1.73-7.el6.x86_64
mysql-server-5.1.73-7.el6.x86_64
mysql-connector-odbc-5.1.5r1144-7.el6.x86_64
[root@ohs2 ~]# rpm -e --nodeps mysql-5.1.73-7.el6.x86_64
[root@ohs2 ~]# rpm -e --nodeps mysql-devel-5.1.73-7.el6.x86_64
[root@ohs2 ~]# rpm -e --nodeps mysql-libs-5.1.73-7.el6.x86_64
[root@ohs2 ~]# rpm -e --nodeps mysql-server-5.1.73-7.el6.x86_64
[root@ohs2 ~]# rpm -e --nodeps mysql-connector-odbc-5.1.5r1144-7.el6.x86_64
[root@ohs2 ~]# rpm -qa|grep mysql
[root@ohs2 ~]# rm -fr /usr/lib/mysql
[root@ohs2 ~]# rm -fr /usr/include/mysql
[root@ohs2 ~]# rm -f /etc/my.cnf
[root@ohs2 ~]# rm -fr /var/lib/mysql
[root@ohs2 ~]#
[root@ohs2 ~]# groupadd mysql
[root@ohs2 ~]# useradd -r -g mysql -s /bin/false mysql
[root@ohs2 ~]# 

Beginning of source-build specific instructions
[root@ohs2 ~]# cd /opt/
[root@ohs2 opt]# cmake -E tar zxvf mysql-boost-5.7.15.tar.gz 三个解压命令都可以
                             tar zxvf mysql-boost-5.7.15.tar.gz
                             gunzip < mysql-boost-5.7.15.tar.gz | tar xvf -
[root@ohs2 opt]# cd mysql-5.7.15/
[root@ohs2 mysql-5.7.15]# cmake -DWITH_DEBUG=1 -DWITH_BOOST=/opt/mysql-5.7.15/boost/boost_1_59_0
-- Running cmake version 2.8.12.2
-- Found Git: /usr/bin/git (found version "1.7.1")
-- Configuring with MAX_INDEXES = 64U
-- The C compiler identification is GNU 4.4.7
-- The CXX compiler identification is GNU 4.4.7
-- Check for working C compiler: /usr/bin/cc
-- Check for working C compiler: /usr/bin/cc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Check for working CXX compiler: /usr/bin/c++
-- Check for working CXX compiler: /usr/bin/c++ -- works
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- Looking for SHM_HUGETLB
-- Looking for SHM_HUGETLB - found
-- Looking for sys/types.h
-- Looking for sys/types.h - found
-- Looking for stdint.h
-- Looking for stdint.h - found
-- Looking for stddef.h
-- Looking for stddef.h - found
-- Check size of void *
-- Check size of void * - done
-- SIZEOF_VOIDP 8
-- Performing Test HAVE_C_FLOATING_POINT_OPTIMIZATION_PROBLEMS
-- Performing Test HAVE_C_FLOATING_POINT_OPTIMIZATION_PROBLEMS - Failed
-- Performing Test HAVE_CXX_FLOATING_POINT_OPTIMIZATION_PROBLEMS
-- Performing Test HAVE_CXX_FLOATING_POINT_OPTIMIZATION_PROBLEMS - Failed
-- MySQL 5.7.15
-- Packaging as: mysql-5.7.15-Linux-x86_64
-- Local boost dir /opt/mysql-5.7.15/boost/boost_1_59_0
-- Found /opt/mysql-5.7.15/boost/boost_1_59_0/boost/version.hpp
-- BOOST_VERSION_NUMBER is #define BOOST_VERSION 105900
-- BOOST_INCLUDE_DIR /opt/mysql-5.7.15/boost/boost_1_59_0
-- Performing Test HAVE_LLVM_LIBCPP
-- Performing Test HAVE_LLVM_LIBCPP - Failed
-- Looking for include file pthread.h
-- Looking for include file pthread.h - found
-- Looking for pthread_create
-- Looking for pthread_create - not found
-- Looking for pthread_create in pthreads
-- Looking for pthread_create in pthreads - not found
-- Looking for pthread_create in pthread
-- Looking for pthread_create in pthread - found
-- Found Threads: TRUE  
-- Looking for floor
-- Looking for floor - not found
-- Looking for floor in m
-- Looking for floor in m - found
-- Looking for gethostbyname_r
-- Looking for gethostbyname_r - found
-- Looking for bind
-- Looking for bind - found
-- Looking for crypt
-- Looking for crypt - not found
-- Looking for crypt in crypt
-- Looking for crypt in crypt - found
-- Looking for setsockopt
-- Looking for setsockopt - found  -- Looking for include files curses.h, term.h
-- Looking for include files curses.h, term.h - found
-- Looking for include file termios.h
-- Looking for include file termios.h - found
-- Looking for include file termio.h
-- Looking for include file termio.h - found
-- Looking for include file unistd.h
-- Looking for include file unistd.h - found
-- Looking for include file sys/wait.h
-- Looking for include file sys/wait.h - found
-- Looking for include file sys/param.h
-- Looking for include file sys/param.h - found
-- Looking for include file fnmatch.h
-- Looking for include file fnmatch.h - found
-- Looking for include file sys/un.h
-- Looking for include file sys/un.h - found
-- Looking for include file vis.h
-- Looking for include file vis.h - not found
-- Looking for include file sasl/sasl.h
-- Looking for include file sasl/sasl.h - found
-- Looking for include file sys/devpoll.h
-- Looking for include file sys/devpoll.h - not found
-- Looking for include file sys/epoll.h
-- Looking for include file sys/epoll.h - found
-- Looking for TAILQ_FOREACH
-- Looking for TAILQ_FOREACH - found
-- Looking for _aligned_malloc
-- Looking for _aligned_malloc - not found
-- Looking for backtrace
-- Looking for backtrace - found
-- Looking for printstack
-- Looking for printstack - not found
-- Looking for index
-- Looking for index - found
-- Looking for clock_gettime
-- Looking for clock_gettime - found
-- Looking for cuserid
-- Looking for cuserid - found
-- Looking for directio
-- Looking for directio - not found
-- Looking for ftruncate
-- Looking for ftruncate - found
-- Looking for compress
-- Looking for compress - not found
-- Looking for crypt
-- Looking for crypt - found
-- Looking for dlopen
-- Looking for dlopen - found
-- Looking for fchmod
-- Looking for fchmod - found
-- Looking for fcntl
-- Looking for fcntl - found
-- Looking for fdatasync
-- Looking for fdatasync - found
-- Looking for fdatasync
-- Looking for fdatasync - found
-- Looking for fedisableexcept
-- Looking for fedisableexcept - found
-- Looking for fseeko
-- Looking for fseeko - found
-- Looking for fsync
-- Looking for fsync - found
-- Looking for gethostbyaddr_r
-- Looking for gethostbyaddr_r - found
-- Looking for gethrtime
-- Looking for gethrtime - not found
-- Looking for getnameinfo
-- Looking for getnameinfo - found
-- Looking for getpass
-- Looking for getpass - found
-- Looking for getpassphrase
-- Looking for getpassphrase - not found
-- Looking for getpwnam
-- Looking for getpwnam - found
-- Looking for getpwuid
-- Looking for getpwuid - found
-- Looking for getrlimit
-- Looking for getrlimit - found
-- Looking for getrusage
-- Looking for getrusage - found
-- Looking for initgroups
-- Looking for initgroups - found
-- Looking for issetugid
-- Looking for issetugid - not found
-- Looking for getuid
-- Looking for getuid - found
-- Looking for geteuid
-- Looking for geteuid - found
-- Looking for getgid
-- Looking for getgid - found
-- Looking for getegid
-- Looking for getegid - found
-- Looking for lstat
-- Looking for lstat - found
-- Looking for madvise
-- Looking for madvise - found
-- Looking for malloc_info
-- Looking for malloc_info - found
-- Looking for memrchr
-- Looking for memrchr - found
-- Looking for mlock
-- Looking for mlock - found
-- Looking for mlockall
-- Looking for mlockall - found
-- Looking for mmap64
-- Looking for mmap64 - found
-- Looking for poll
-- Looking for poll - found
-- Looking for posix_fallocate
-- Looking for posix_fallocate - found
-- Looking for posix_memalign
-- Looking for posix_memalign - found
-- Looking for pread
-- Looking for pread - found
-- Looking for pthread_condattr_setclock
-- Looking for pthread_condattr_setclock - found
-- Looking for pthread_sigmask
-- Looking for pthread_sigmask - found
-- Looking for readdir_r
-- Looking for readdir_r - found
-- Looking for readlink
-- Looking for readlink - found
-- Looking for realpath
-- Looking for realpath - found
-- Looking for setfd
-- Looking for setfd - not found
-- Looking for sigaction
-- Looking for sigaction - found
-- Looking for sleep
-- Looking for sleep - found
-- Looking for stpcpy
-- Looking for stpcpy - found
-- Looking for stpncpy
-- Looking for stpncpy - found
-- Looking for strlcpy
-- Looking for strlcpy - not found
-- Looking for strndup
-- Looking for strndup - found
-- Looking for strnlen
-- Looking for strnlen - found
-- Looking for strlcat
-- Looking for strlcat - not found
-- Looking for strsignal
-- Looking for strsignal - found
-- Looking for fgetln
-- Looking for fgetln - not found
-- Looking for strsep
-- Looking for strsep - found
-- Looking for tell
-- Looking for tell - not found
-- Looking for vasprintf
-- Looking for vasprintf - found
-- Looking for memalign
-- Looking for memalign - found
-- Looking for nl_langinfo
-- Looking for nl_langinfo - found
-- Looking for ntohll
-- Looking for ntohll - not found
-- Looking for clock_gettime
-- Looking for clock_gettime - found
-- Looking for epoll_create
-- Looking for epoll_create - found
-- Looking for inet_ntop
-- Looking for inet_ntop - found
-- Looking for kqueue
-- Looking for kqueue - not found
-- Looking for timeradd
-- Looking for timeradd - found
-- Looking for timerclear
-- Looking for timerclear - found
-- Looking for timercmp
-- Looking for timercmp - found
-- Looking for timerisset
-- Looking for timerisset - found
-- Looking for include file sys/time.h
-- Looking for include file sys/time.h - found
-- Looking for include file sys/times.h
-- Looking for include file sys/times.h - found
-- Looking for times
-- Looking for times - found
-- Looking for gettimeofday
-- Looking for gettimeofday - found
-- Looking for lrand48
-- Looking for lrand48 - found
-- Looking for TIOCGWINSZ
-- Looking for TIOCGWINSZ - found
-- Looking for FIONREAD
-- Looking for FIONREAD - found
-- Looking for FIONREAD
-- Looking for FIONREAD - not found
-- Looking for SIGEV_THREAD_ID
-- Looking for SIGEV_THREAD_ID - found
-- Looking for SIGEV_PORT
-- Looking for SIGEV_PORT - not found
-- Looking for log2
-- Looking for log2 - found
-- Looking for isinf
-- Looking for isinf - found
-- Performing Test HAVE_CXX_ISINF
-- Performing Test HAVE_CXX_ISINF - Success
-- Looking for timer_create
-- Looking for timer_create - found
-- Looking for timer_settime
-- Looking for timer_settime - found
-- Looking for kqueue
-- Looking for kqueue - not found
-- Looking for EVFILT_TIMER
-- Looking for EVFILT_TIMER - not found
-- Check if the system is big endian
-- Searching 16 bit integer
-- Check size of unsigned short
-- Check size of unsigned short - done
-- Using unsigned short
-- Check if the system is big endian - little endian
-- Check size of char *
-- Check size of char * - done
-- Check size of long
-- Check size of long - done
-- Check size of short
-- Check size of short - done
-- Check size of int
-- Check size of int - done
-- Check size of long long
-- Check size of long long - done
-- Check size of off_t
-- Check size of off_t - done
-- Check size of time_t
-- Check size of time_t - done
-- Check size of struct timespec
-- Check size of struct timespec - done
-- Check size of uint
-- Check size of uint - done
-- Check size of ulong
-- Check size of ulong - done
-- Check size of u_int32_t
-- Check size of u_int32_t - done
-- Performing Test HAVE_VISIBILITY_HIDDEN
-- Performing Test HAVE_VISIBILITY_HIDDEN - Success
-- Checking stack direction : -1
-- Looking for include files time.h, sys/time.h
-- Looking for include files time.h, sys/time.h - found
-- Looking for O_NONBLOCK
-- Looking for O_NONBLOCK - found
-- Performing Test HAVE_PAUSE_INSTRUCTION
-- Performing Test HAVE_PAUSE_INSTRUCTION - Success
-- Performing Test HAVE_BSS_START
-- Performing Test HAVE_BSS_START - Success
-- Performing Test HAVE_BUILTIN_UNREACHABLE
-- Performing Test HAVE_BUILTIN_UNREACHABLE - Success
-- Performing Test HAVE_BUILTIN_EXPECT
-- Performing Test HAVE_BUILTIN_EXPECT - Success
-- Performing Test HAVE_BUILTIN_STPCPY
-- Performing Test HAVE_BUILTIN_STPCPY - Success
-- Performing Test HAVE_GCC_ATOMIC_BUILTINS
-- Performing Test HAVE_GCC_ATOMIC_BUILTINS - Failed
-- Performing Test HAVE_GCC_SYNC_BUILTINS
-- Performing Test HAVE_GCC_SYNC_BUILTINS - Success
-- Looking for netinet/in6.h
-- Looking for netinet/in6.h - not found
-- Check size of struct sockaddr_in6
-- Check size of struct sockaddr_in6 - done
-- Check size of struct in6_addr
-- Check size of struct in6_addr - done
-- Performing Test HAVE_SOCKADDR_STORAGE_SS_FAMILY
-- Performing Test HAVE_SOCKADDR_STORAGE_SS_FAMILY - Success
-- Performing Test HAVE_SOCKADDR_IN_SIN_LEN
-- Performing Test HAVE_SOCKADDR_IN_SIN_LEN - Failed
-- Performing Test HAVE_SOCKADDR_IN6_SIN6_LEN
-- Performing Test HAVE_SOCKADDR_IN6_SIN6_LEN - Failed
-- Performing Test HAVE_IMPLICIT_DEPENDENT_NAME_TYPING
-- Performing Test HAVE_IMPLICIT_DEPENDENT_NAME_TYPING - Failed
-- Looking for chown
-- Looking for chown - found
-- Looking for include file numaif.h
-- Looking for include file numaif.h - not found
-- Check size of socklen_t
-- Performing Test HAVE_IB_GCC_SYNC_SYNCHRONISE
-- Performing Test HAVE_IB_GCC_SYNC_SYNCHRONISE - Success
-- Performing Test HAVE_IB_GCC_ATOMIC_THREAD_FENCE
-- Performing Test HAVE_IB_GCC_ATOMIC_THREAD_FENCE - Failed
-- Performing Test HAVE_IB_GCC_ATOMIC_COMPARE_EXCHANGE
-- Performing Test HAVE_IB_GCC_ATOMIC_COMPARE_EXCHANGE - Failed
-- Performing Test HAVE_IB_ATOMIC_PTHREAD_T_GCC
-- Performing Test HAVE_IB_ATOMIC_PTHREAD_T_GCC - Success
-- Performing Test HAVE_IB_LINUX_FUTEX
-- Performing Test HAVE_IB_LINUX_FUTEX - Success
-- Looking for asprintf
-- Looking for asprintf - found
-- Using cmake version 2.8.12.2
-- Performing Test HAVE_UNUSED_BUT_SET_VARIABLE
-- Performing Test HAVE_UNUSED_BUT_SET_VARIABLE - Success
-- Disabling -Wunused-but-set-variable warning for building NDB
-- Performing Test HAVE_STRICT_ALIASING
-- Performing Test HAVE_STRICT_ALIASING - Success
-- Disabling -Wstrict-aliasing warning for building NDB
-- Not building NDB
-- Performing Test HAVE_PEERCRED
-- Performing Test HAVE_PEERCRED - Success
-- Using Boost headers from /opt/mysql-5.7.15/boost/boost_1_59_0
-- Performing Test CXX_HAVE_SIGN_COMPARE
-- Performing Test CXX_HAVE_SIGN_COMPARE - Success
-- Performing Test CXX_HAVE_UNUSED_VARIABLE
-- Performing Test CXX_HAVE_UNUSED_VARIABLE - Success
-- MYSQLX - Text log of protobuf messages enabled
-- MYSQLX - Enabled debug traces
-- Performing Test HAVE_UNUSED_PARAMETER
-- Performing Test HAVE_UNUSED_PARAMETER - Success
-- Performing Test HAVE_NO_DEPREC_CONST
-- Performing Test HAVE_NO_DEPREC_CONST - Success
-- Library mysqlclient depends on OSLIBS -lpthread;m;rt;dl
-- Looking for include file endian.h
-- Looking for include file endian.h - found
-- Looking for le64toh
-- Looking for le64toh - found
-- Looking for le32toh
-- Looking for le32toh - found
-- Looking for le16toh
-- Looking for le16toh - found
-- Check size of long long
-- Check size of long long - done
-- Check size of long
-- Check size of long - done
-- Check size of int
-- Check size of int - done
-- Check if the system is big endian
-- Searching 16 bit integer
-- Using unsigned short
-- Check if the system is big endian - little endian
-- Found ZLIB: zlib (found version "1.2.3")
[ 98%] Built target mysql_client_test_embedded
Scanning dependencies of target mysql_embedded
[ 98%] Building CXX object libmysqld/examples/CMakeFiles/mysql_embedded.dir/__/__/client/completion_hash.cc.o
[100%] Building CXX object libmysqld/examples/CMakeFiles/mysql_embedded.dir/__/__/client/mysql.cc.o
[100%] Building CXX object libmysqld/examples/CMakeFiles/mysql_embedded.dir/__/__/client/readline.cc.o
Linking CXX executable mysql_embedded
[100%] Built target mysql_embedded
Scanning dependencies of target mysqltest_embedded
[100%] Building CXX object libmysqld/examples/CMakeFiles/mysqltest_embedded.dir/__/__/client/mysqltest.cc.o
Linking CXX executable mysqltest_embedded
[100%] Built target mysqltest_embedded
Scanning dependencies of target my_safe_process
[100%] Building CXX object mysql-test/lib/My/SafeProcess/CMakeFiles/my_safe_process.dir/safe_process.cc.o
Linking CXX executable my_safe_process
[100%] Built target my_safe_process
[root@ohs2 mysql-5.7.15]#
[root@ohs2 mysql-5.7.15]# make install
[  0%] Built target INFO_BIN
[  0%] Built target INFO_SRC
[  0%] Built target abi_check
[  0%] Built target zlib
[  1%] Built target yassl
[  2%] Built target taocrypt
[  4%] Built target edit
[  6%] Built target strings
[ 11%] Built target mysys
[ 11%] Built target dbug
[ 11%] Built target mysys_ssl
[ 11%] Built target comp_err
[ 11%] Built target GenError
[ 11%] Built target federated
[ 11%] Built target federated_embedded
[ 11%] Built target blackhole
[ 11%] Built target blackhole_embedded
[ 11%] Built target partition
[ 12%] Built target partition_embedded
[ 12%] Built target lz4_lib
[ 19%] Built target innobase
[ 20%] Built target heap
[ 21%] Built target heap_embedded
[ 22%] Built target hp_test1
[ 22%] Built target hp_test2
[ 24%] Built target myisammrg
[ 25%] Built target myisammrg_embedded
[ 25%] Built target archive
[ 25%] Built target archive_embedded
[ 28%] Built target myisam
[ 31%] Built target myisam_embedded
[ 31%] Built target myisam_ftdump
[ 31%] Built target myisamchk
[ 31%] Built target myisamlog
[ 31%] Built target myisampack
[ 32%] Built target mysqlservices
[ 32%] Built target example
[ 38%] Built target perfschema
[ 38%] Built target mytap
[ 38%] Built target pfs_server_stubs
[ 38%] Built target pfs-t
[ 38%] Built target pfs_account-oom-t
[ 38%] Built target gen_lex_hash
[ 39%] Built target GenServerSource
[ 39%] Built target csv
[ 39%] Built target ngram_parser
[ 39%] Built target regex
[ 39%] Built target vio
[ 40%] Built target binlogevents_static
[ 41%] Built target binlog
[ 41%] Built target rpl
[ 41%] Built target master
[ 42%] Built target slave
[ 42%] Built target comp_sql
[ 42%] Built target GenBootstrapPriv
[ 42%] Built target gen_lex_token
[ 42%] Built target GenDigestServerSource
[ 42%] Built target GenSysSchema
[ 54%] Built target sql
[ 54%] Built target pfs_connect_attr-t
[ 54%] Built target pfs_host-oom-t
[ 55%] Built target pfs_instr-oom-t
[ 55%] Built target pfs_instr-t
[ 55%] Built target pfs_instr_class-oom-t
[ 55%] Built target pfs_instr_class-t
[ 55%] Built target pfs_misc-t
[ 55%] Built target pfs_noop-t
[ 55%] Built target pfs_user-oom-t
[ 55%] Built target csv_embedded
[ 55%] Built target auth
[ 55%] Built target auth_socket
[ 55%] Built target auth_test_plugin
[ 55%] Built target mysql_no_login
[ 55%] Built target qa_auth_client
[ 55%] Built target qa_auth_interface
[ 55%] Built target qa_auth_server
[ 55%] Built target test_session_detach
[ 55%] Built target test_session_in_thd
[ 55%] Built target test_session_info
[ 55%] Built target test_sql_2_sessions
[ 55%] Built target test_sql_all_col_types
[ 55%] Built target test_sql_cmds_1
[ 55%] Built target test_sql_commit
[ 55%] Built target test_sql_complex
[ 55%] Built target test_sql_errors
[ 55%] Built target test_sql_lock
[ 55%] Built target test_sql_processlist
[ 55%] Built target test_sql_replication
[ 55%] Built target test_sql_shutdown
[ 55%] Built target test_sql_sqlmode
[ 55%] Built target test_sql_stored_procedures_functions
[ 55%] Built target test_sql_views_triggers
[ 55%] Built target test_x_sessions_deinit
[ 55%] Built target test_x_sessions_init
[ 56%] Built target ftexample
[ 56%] Built target audit_null
[ 56%] Built target test_security_context
[ 57%] Built target test_udf_services
[ 57%] Built target version_token
[ 57%] Built target keyring_file
[ 57%] Built target rewrite_example
[ 57%] Built target replication_observers_example
[ 57%] Built target test_framework
[ 58%] Built target test_services
[ 58%] Built target test_services_thread
[ 58%] Built target semisync_master
[ 59%] Built target semisync_slave
[ 59%] Built target validate_password
[ 59%] Built target daemon_example
[ 59%] Built target rewriter
[ 59%] Built target GenLiteProtos
[ 60%] Built target protobuf-lite
[ 61%] Built target event
[ 63%] Built target protobuf
[ 65%] Built target protoclib
[ 65%] Built target protoc
[ 70%] Built target xplugin
[ 70%] Built target mysqlx
[ 71%] Built target clientlib
[ 72%] Built target mysqlclient
[ 75%] Built target mysqlxtest
[ 76%] Built target keyring_udf
[ 76%] Built target re
[ 76%] Built target base64_test
[ 76%] Built target queues
[ 76%] Built target thr_lock
[ 76%] Built target libmysql
[ 76%] Built target libmysql_api_test
[ 76%] Built target binlogstandalone_shared
[ 77%] Built target binlogstandalone_static
[ 77%] Built target no_plan-t
[ 77%] Built target simple-t
[ 77%] Built target skip-t
[ 77%] Built target skip_all-t
[ 77%] Built target todo-t
[ 77%] Built target basic-t
[ 77%] Built target innochecksum
[ 77%] Built target lz4_decompress
[ 77%] Built target my_print_defaults
[ 77%] Built target perror
[ 78%] Built target replace
[ 78%] Built target resolve_stack_dump
[ 78%] Built target resolveip
[ 79%] Built target zlib_decompress
[ 79%] Built target mysql
[ 79%] Built target mysql_config_editor
[ 79%] Built target mysql_install_db
[ 79%] Built target mysql_plugin
[ 79%] Built target mysql_secure_installation
[ 79%] Built target mysql_ssl_rsa_setup
[ 79%] Built target GenFixPrivs
[ 79%] Built target mysqlcheck_core
[ 80%] Built target client_base
[ 80%] Built target mysql_upgrade
[ 80%] Built target mysqladmin
[ 80%] Built target mysqlbinlog
[ 80%] Built target mysqlcheck
[ 80%] Built target mysqldump
[ 80%] Built target mysqlimport
[ 80%] Built target mysqlshow
[ 80%] Built target mysqlslap
[ 80%] Built target mysqltest
[ 80%] Built target boost_lib
[ 84%] Built target mysqlpump_lib
[ 84%] Built target mysqlpump
[ 84%] Built target bug25714
[ 84%] Built target mysql_client_test
[ 84%] Built target locking_service
[ 84%] Built target mysql_tzinfo_to_sql
[ 84%] Built target mysqld
[ 85%] Built target sqlgunitlib
[ 85%] Built target udf_example
[ 85%] Built target GenYaccEmbeddedSource
[ 98%] Built target sql_embedded
[ 98%] Built target mysqlserver
[ 98%] Built target mysql_client_test_embedded
[100%] Built target mysql_embedded
[100%] Built target mysqltest_embedded
[100%] Built target my_safe_process
-- Installing: /usr/local/mysql/mysql-test/./t/subquery_sj_loosescan.test
-- Installing: /usr/local/mysql/mysql-test/./t/validate_password_plugin_check_user-master.opt
-- Installing: /usr/local/mysql/mysql-test/./t/partition_rename_longfilename.test
-- Installing: /usr/local/mysql/mysql-test/./t/optimizer_switch.test
-- Installing: /usr/local/mysql/mysql-test/./t/join_nested_bka.test
-- Installing: /usr/local/mysql/mysql-test/./t/sort_buffer_size_functionality.test
-- Installing: /usr/local/mysql/mysql-test/./t/user_limits.test
-- Installing: /usr/local/mysql/mysql-test/./t/connect.test
-- Installing: /usr/local/mysql/mysql-test/./t/innodb_disabled.test
-- Up-to-date: /usr/local/mysql/mysql-test/mtr
-- Up-to-date: /usr/local/mysql/mysql-test/mysql-test-run
-- Installing: /usr/local/mysql/mysql-test/lib/My/SafeProcess/my_safe_process
-- Up-to-date: /usr/local/mysql/mysql-test/lib/My/SafeProcess/my_safe_process
-- Installing: /usr/local/mysql/mysql-test/lib/My/SafeProcess/Base.pm
-- Installing: /usr/local/mysql/support-files/my-default.cnf
-- Installing: /usr/local/mysql/support-files/mysqld_multi.server
-- Installing: /usr/local/mysql/support-files/mysql-log-rotate
-- Installing: /usr/local/mysql/support-files/magic
-- Installing: /usr/local/mysql/share/aclocal/mysql.m4
-- Installing: /usr/local/mysql/support-files/mysql.server
[root@ohs2 mysql-5.7.15]# 
[root@ohs2 mysql-5.7.15]# 
[root@ohs2 mysql-5.7.15]# make package(打包,可选步骤)
[root@ohs2 mysql-5.7.15]# make package
[  0%] Built target INFO_BIN
[  0%] Built target INFO_SRC
[  0%] Built target abi_check
[  0%] Built target zlib
[  1%] Built target yassl
[  2%] Built target taocrypt
[  4%] Built target edit
[  6%] Built target strings
[ 11%] Built target mysys
[ 11%] Built target dbug
[ 11%] Built target mysys_ssl
[ 11%] Built target comp_err
[ 11%] Built target GenError
[ 11%] Built target federated
[ 11%] Built target federated_embedded
[ 11%] Built target blackhole
[ 11%] Built target blackhole_embedded
[ 11%] Built target partition
[ 12%] Built target partition_embedded
[ 12%] Built target lz4_lib
[ 19%] Built target innobase
[ 20%] Built target heap
[ 21%] Built target heap_embedded
[ 22%] Built target hp_test1
[ 22%] Built target hp_test2
[ 24%] Built target myisammrg
[ 25%] Built target myisammrg_embedded
[ 25%] Built target archive
[ 25%] Built target archive_embedded
[ 28%] Built target myisam
[ 31%] Built target myisam_embedded
[ 31%] Built target myisam_ftdump
[ 31%] Built target myisamchk
[ 31%] Built target myisamlog
[ 31%] Built target myisampack
[ 32%] Built target mysqlservices
[ 32%] Built target example
[ 38%] Built target perfschema
[ 38%] Built target mytap
[ 38%] Built target pfs_server_stubs
[ 38%] Built target pfs-t
[ 38%] Built target pfs_account-oom-t
[ 38%] Built target gen_lex_hash
[ 39%] Built target GenServerSource
[ 39%] Built target csv
[ 39%] Built target ngram_parser
[ 39%] Built target regex
[ 39%] Built target vio
[ 40%] Built target binlogevents_static
[ 41%] Built target binlog
[ 41%] Built target rpl
[ 41%] Built target master
[ 42%] Built target slave
[ 42%] Built target comp_sql
[ 42%] Built target GenBootstrapPriv
[ 42%] Built target gen_lex_token
[ 42%] Built target GenDigestServerSource
[ 42%] Built target GenSysSchema
[ 54%] Built target sql
[ 54%] Built target pfs_connect_attr-t
[ 54%] Built target pfs_host-oom-t
[ 55%] Built target pfs_instr-oom-t
[ 55%] Built target pfs_instr-t
[ 55%] Built target pfs_instr_class-oom-t
[ 55%] Built target pfs_instr_class-t
[ 55%] Built target pfs_misc-t
[ 55%] Built target pfs_noop-t
[ 55%] Built target pfs_user-oom-t
[ 55%] Built target csv_embedded
[ 55%] Built target auth
[ 55%] Built target auth_socket
[ 55%] Built target auth_test_plugin
[ 55%] Built target mysql_no_login
[ 55%] Built target qa_auth_client
[ 55%] Built target qa_auth_interface
[ 55%] Built target qa_auth_server
[ 55%] Built target test_session_detach
[ 55%] Built target test_session_in_thd
[ 55%] Built target test_session_info
[ 55%] Built target test_sql_2_sessions
[ 55%] Built target test_sql_all_col_types
[ 55%] Built target test_sql_cmds_1
[ 55%] Built target test_sql_commit
[ 55%] Built target test_sql_complex
[ 55%] Built target test_sql_errors
[ 55%] Built target test_sql_lock
[ 55%] Built target test_sql_processlist
[ 55%] Built target test_sql_replication
[ 55%] Built target test_sql_shutdown
[ 55%] Built target test_sql_sqlmode
[ 55%] Built target test_sql_stored_procedures_functions
[ 55%] Built target test_sql_views_triggers
[ 55%] Built target test_x_sessions_deinit
[ 55%] Built target test_x_sessions_init
[ 56%] Built target ftexample
[ 56%] Built target audit_null
[ 56%] Built target test_security_context
[ 57%] Built target test_udf_services
[ 57%] Built target version_token
[ 57%] Built target keyring_file
[ 57%] Built target rewrite_example
[ 57%] Built target replication_observers_example
[ 57%] Built target test_framework
[ 58%] Built target test_services
[ 58%] Built target test_services_thread
[ 58%] Built target semisync_master
[ 59%] Built target semisync_slave
[ 59%] Built target validate_password
[ 59%] Built target daemon_example
[ 59%] Built target rewriter
[ 59%] Built target GenLiteProtos
[ 60%] Built target protobuf-lite
[ 61%] Built target event
[ 63%] Built target protobuf
[ 65%] Built target protoclib
[ 65%] Built target protoc
[ 70%] Built target xplugin
[ 70%] Built target mysqlx
[ 71%] Built target clientlib
[ 72%] Built target mysqlclient
[ 75%] Built target mysqlxtest
[ 76%] Built target keyring_udf
[ 76%] Built target re
[ 76%] Built target base64_test
[ 76%] Built target queues
[ 76%] Built target thr_lock
[ 76%] Built target libmysql
[ 76%] Built target libmysql_api_test
[ 76%] Built target binlogstandalone_shared
[ 77%] Built target binlogstandalone_static
[ 77%] Built target no_plan-t
[ 77%] Built target simple-t
[ 77%] Built target skip-t
[ 77%] Built target skip_all-t
[ 77%] Built target todo-t
[ 77%] Built target basic-t
[ 77%] Built target innochecksum
[ 77%] Built target lz4_decompress
[ 77%] Built target my_print_defaults
[ 77%] Built target perror
[ 78%] Built target replace
[ 78%] Built target resolve_stack_dump
[ 78%] Built target resolveip
[ 79%] Built target zlib_decompress
[ 79%] Built target mysql
[ 79%] Built target mysql_config_editor
[ 79%] Built target mysql_install_db
[ 79%] Built target mysql_plugin
[ 79%] Built target mysql_secure_installation
[ 79%] Built target mysql_ssl_rsa_setup
[ 79%] Built target GenFixPrivs
[ 79%] Built target mysqlcheck_core
[ 80%] Built target client_base
[ 80%] Built target mysql_upgrade
[ 80%] Built target mysqladmin
[ 80%] Built target mysqlbinlog
[ 80%] Built target mysqlcheck
[ 80%] Built target mysqldump
[ 80%] Built target mysqlimport
[ 80%] Built target mysqlshow
[ 80%] Built target mysqlslap
[ 80%] Built target mysqltest
[ 80%] Built target boost_lib
[ 84%] Built target mysqlpump_lib
[ 84%] Built target mysqlpump
[ 84%] Built target bug25714
[ 84%] Built target mysql_client_test
[ 84%] Built target locking_service
[ 84%] Built target mysql_tzinfo_to_sql
[ 84%] Built target mysqld
[ 85%] Built target sqlgunitlib
[ 85%] Built target udf_example
[ 85%] Built target GenYaccEmbeddedSource
[ 98%] Built target sql_embedded
[ 98%] Built target mysqlserver
[ 98%] Built target mysql_client_test_embedded
[100%] Built target mysql_embedded
[100%] Built target mysqltest_embedded
[100%] Built target my_safe_process
Run CPack packaging tool...
CPack: Create package using TGZ
CPack: Install projects
CPack: - Run preinstall target for: MySQL
CPack: - Install project: MySQL
CPack: Create package
CPack: - package: /opt/mysql-5.7.15/mysql-5.7.15-linux-x86_64.tar.gz generated.
[root@ohs2 mysql-5.7.15]# 


Postinstallation setup

# Postinstallation setup
shell> cd /usr/local/mysql
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> bin/mysql_install_db --user=mysql    # Before MySQL 5.7.6
shell> bin/mysqld --initialize --user=mysql # MySQL 5.7.6 and up
shell> bin/mysql_ssl_rsa_setup              # MySQL 5.7.6 and up
shell> chown -R root .
shell> chown -R mysql data
shell> bin/mysqld_safe --user=mysql &
# Next command is optional
shell> cp support-files/mysql.server /etc/init.d/mysql.server

[root@ohs2 ~]# cd /usr/local/mysql

[root@ohs2 mysql]# chown -R mysql .
[root@ohs2 mysql]# chgrp -R mysql .
[root@ohs2 mysql]# bin/mysqld --initialize --user=mysql
2016-09-26T19:10:16.603810Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-09-26T19:10:16.987725Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-09-26T19:10:17.148680Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2016-09-26T19:10:17.223451Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: dc5a4946-841c-11e6-bfb6-080027ba9d73.
2016-09-26T19:10:17.225186Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-09-26T19:10:17.227975Z 1 [Note] A temporary password is generated for root@localhost: DNIzl#ynq0T-
[root@ohs2 mysql]#
[root@ohs2 mysql]# bin/mysql_ssl_rsa_setup
Generating a 2048 bit RSA private key
....+++
...................................................................................+++
writing new private key to 'ca-key.pem'
-----
Generating a 2048 bit RSA private key
................................................+++
..........................................................+++
writing new private key to 'server-key.pem'
-----
Generating a 2048 bit RSA private key
.........................................................................................+++
.............+++
writing new private key to 'client-key.pem'
-----
[root@ohs2 mysql]#
[root@ohs2 mysql]#
[root@ohs2 mysql]# chown -R root .
[root@ohs2 mysql]# chown -R mysql data
[root@ohs2 mysql]# bin/mysqld_safe --user=mysql &
[1] 32632
[root@ohs2 mysql]# 2016-09-26T19:11:07.190353Z mysqld_safe Logging to '/usr/local/mysql/data/ohs2.ohsdba.cn.err'.
2016-09-26T19:11:07.210266Z mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
[root@ohs2 mysql]# cp support-files/mysql.server /etc/init.d/mysql.server
[root@ohs2 mysql]# 


MySQL debug版本初体验

[root@ohs2 ~]# /usr/local/mysql/bin/mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.15-debug Source distribution
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

[root@ohs2 bin]# ./mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.15-debug

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'ohsdba';
Query OK, 0 rows affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+---------------------------+
| Tables_in_mysql           |
+---------------------------+
| columns_priv              |
| db                        |
| engine_cost               |
| event                     |
| func                      |
| general_log               |
| gtid_executed             |
| help_category             |
| help_keyword              |
| help_relation             |
| help_topic                |
| innodb_index_stats        |
| innodb_table_stats        |
| ndb_binlog_index          |
| plugin                    |
| proc                      |
| procs_priv                |
| proxies_priv              |
| server_cost               |
| servers                   |
| slave_master_info         |
| slave_relay_log_info      |
| slave_worker_info         |
| slow_log                  |
| tables_priv               |
| time_zone                 |
| time_zone_leap_second     |
| time_zone_name            |
| time_zone_transition      |
| time_zone_transition_type |
| user                      |
+---------------------------+
31 rows in set (0.00 sec)

mysql> 
mysql> status;
--------------
./mysql  Ver 14.14 Distrib 5.7.15, for Linux (x86_64) using  EditLine wrapper

Connection id:          4
Current database:       mysql
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.7.15-debug
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:            /tmp/mysql.sock
Uptime:                 19 min 53 sec

Threads: 1  Questions: 47  Slow queries: 0  Opens: 136  Flush tables: 1  Open tables: 129  Queries per second avg: 0.039
--------------
mysql> 


Reference

http://dev.mysql.com/doc/

http://dev.mysql.com/doc/refman/5.7/en/

http://www.cmake.org
http://www.gnu.org/software/make/

http://www.boost.org/

http://baike.baidu.com/item/mySQL/471251

http://dev.mysql.com/doc/refman/5.7/en/source-installation.html
http://dev.mysql.com/doc/refman/5.7/en/installing-source-distribution.html
http://dev.mysql.com/doc/refman/8.0/en/source-installation.html
http://dev.mysql.com/doc/refman/8.0/en/installing-source-distribution.html
http://bugs.mysql.com/bug.php?id=70647



关键词:mysql 

相关文章

MySQL and Oracle Enterprise Manager
MySQL Tools for performance, backup, monitor
MySQL Multi-Master Single-Slave Replication
MySQL and GPL
MySQL monthly report from alibaba
MySQL备份
MySQL配置文件my.cnf
MySQL数据类型
MySQL字符集
MySQL入门
MySQL的基本架构
关于MySQL,你需要了解的

联系我们

韩朝阳



    Phone:186-9589-1286

    E-mail:ohsdba@qq.com

    微  信: ohsdba


电话(186-9589-1286)

QQ(375349564)

微信(ohsdba)


常用链接

Oracle
eDelivery
My Oracle Support

Exadata 12.1 Document

Exadata 12.2 Document

Oracle 11gR2 Document

Oracle 12cR1 Document

Oracle 12cR2 Document

GoldenGate 12c

Oracle Fusion Middleware

Mysql Document

PostgreSQL

Python

github

sourceforge



Top
Cell186-9589-1286
QQ 375349564
E-mail ohsdba@qq.com