/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 2×××8 ? 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