/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
1
2
3
4
5
6
7
8
|
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加密算法扩展库
1
2
3
4
5
6
7
8
9
|
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 跨平台的安装(编译)工具
1
2
3
4
5
|
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兼容的正规表达式库
1
2
3
4
5
6
|
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
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
#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
|
复制配置文件:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
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
|
复制启动脚本:
1
2
3
4
|
cp ./support-files/mysql.server /etc/init.d/mysqld
chmod
755
/etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on
|
初始化数据库
1
2
|
cd /usr/local/mysql
./scripts/mysql_install_db --user=mysql --datadir=/
var
/mysql/data --log-output=file
|
启动数据库
1
2
|
service mysqld restart
Starting MySQL...... [ OK ]
|
查看操作历史
1
|
select * from mysql.general_log; #查看历史
|
mysql进程
1
2
3
|
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