mysql5.5.37安装_生产环境MySQL5.5.37编译安装

/data 文件夹放tar，rpm，zip包，解压和编译放在此文件夹下的source文件夹内

yum install patch make gcc gcc-c++ gcc-g77 flex bison file libtool libtool-libs autoconf kernel-devel glib2 glib2-devel bzip2 bzip2-devel libevent libevent-devel ncurses ncurses-devel openssl openssl-devel fonts-chinese gettext gettext-devel ncurses-devel gmp-devel pspell-devel unzip libcap -y

# uname -a

Linux localhost.localdomain 2.6.32-358.el6.x86_64 #1 SMP Fri Feb 22 00:31:26 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux

CentOS 6.4 64位，最小化安装

基本配置广州dns

vim /etc/resolv.conf

search localdomain

nameserver 202.96.128.86

nameserver 202.96.128.166

nameserver 202.96.134.33

nameserver 8.8.8.8

ulimit -HSn 65535

一、安装libmcrypt2.5.8加密算法扩展库

mkdir -p /data/source

tar -zxvf libmcrypt-2.5.8.tar.gz -C ./source/

cd source/libmcrypt-2.5.8/

./configure

make&& make install && /sbin/ldconfig

cd libltdl/

./configure --enable-ltdl-install

make&& make install

cd /data

二、安装cmake2.8.7跨平台的安装(编译)工具

tar -zxvf cmake-2.8.7.tar.gz -C ./source/

cd source/cmake-2.8.7

./configure

make && make install

cd /data

三、安装pcre8.30一个Perl库，包括perl兼容的正规表达式库

mkdir -p /usr/local/pcre

tar -zxvf pcre-8.30.tar.gz -C ./source/

cd source/pcre-8.30

./configure --prefix=/usr/local/pcre

make&&make install

cd /data

四、安装mysql5.5.37

#DATA_DIR=/var/mysql/data

#INSTALL_DIR=/usr/local/mysql

groupadd mysql

useradd -g mysql mysql -s /sbin/nologin

mkdir -p /var/mysql/data

mkdir -p /var/mysql/log

chown -R mysql.mysql /usr/local/mysql

chown -R mysql.mysql /var/mysql

cd /data

tar -xzf mysql-5.5.37.tar.gz -C ./source/

cd source/mysql-5.5.37

cmake \

-DCMAKE_BUILD_TYPE:STRING=Release \

-DMYSQL_USER=mysql \

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

-DMYSQL_DATADIR=/var/mysql/data \

-DSYSCONFDIR=/etc \

-DWITH_MYISAM_STORAGE_ENGINE=1 \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_MEMORY_STORAGE_ENGINE=1 \

-DWITH_ARCHIVE_STORAGE_ENGINE=1 \

-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \

-DWITH_FEDERATED_STORAGE_ENGINE=1 \

-DWITH_PARTITION_STORAGE_ENGINE=1 \

-DWITH_READLINE=1 \

-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \

-DMYSQL_TCP_PORT=3306 \

-DENABLED_LOCAL_INFILE=1 \

-DWITH_PARTITION_STORAGE_ENGINE=1 \

-DEXTRA_CHARSETS=all \

-DWITH_SSL=yes \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci

make

make install

复制配置文件：

mv /etc/my.cnf /etc/my.cnf.bak

cp ./support-files/my-huge.cnf /etc/my.cnf

vim /etc/my.cnf

在[client]下添加：

default-character-set=utf8

在[mysqld]添加：

datadir = /var/mysql/data

skip-name-resolve

lower_case_table_names = 1

character-set-server = utf8

log-error = /var/mysql/mysql-error.log

pid-file = /var/mysql/data/mysql.pid

query_cache_limit = 10M

max_connections = 5000

lower_case_table_names = 1

log-error = /var/mysql/log/mysql-error.log

pid-file = /var/mysql/log/mysql.pid

general_log = 1

log_output=TABLE

log-bin=/var/mysql/log/mysql-bin

slow_query_log = ON

slow_query_log_file = /var/mysql/log/mysql_slow.log

long_query_time = 2

max_heap_table_size = 64M

#注释下面的

#log-bin=mysql-bin

复制启动脚本：

cp ./support-files/mysql.server /etc/init.d/mysqld

chmod 755 /etc/init.d/mysqld

chkconfig --add mysqld

chkconfig mysqld on

初始化数据库

cd /usr/local/mysql

./scripts/mysql_install_db --user=mysql  --datadir=/var/mysql/data --log-output=file

启动数据库

service mysqld restart

Starting MySQL......                  [  OK  ]

查看操作历史

select * from mysql.general_log;   #查看历史

mysql进程

ps aux|grep mysql

root     22655  0.0  0.0  11300  1528 ?        S    Apr15   0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/var/mysql/data --pid-file=/var/mysql/log/mysql.pid

mysql    23112 14.6  1.8 3816048 299928 ?      Sl   Apr15 170:45 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/var/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/var/mysql/log/mysql-error.log --pid-file=/var/mysql/log/mysql.pid --socket=/var/lib/mysql/mysql.sock --port=3306

五、MySql目录

datadir=/var/mysql/data

bin-log=/var/mysql/log

log-error=/var/mysql/log/mysql-error.log

pid-file=/var/mysql/log/mysql.pid

慢日志=/var/mysql/log/mysql_slow.log