CentOS 5.4编译安装MySQL(VPS,小内存优化)
1、安装编译环境
1 |
yum install gcc gcc-c++ autoconf automake ncurses-devel |
2、下载,解压缩
1 |
wget http://mysql.mirror.tw/Downloads/MySQL-5.1/mysql-5.1.45. tar .gz |
2 |
tar -xzvf mysql-5.1.45. tar .gz |
3、编译
1 |
CFLAGS= "-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors \ |
2 |
-fno-exceptions -fno-rtti" ./configure \ |
3 |
--prefix=/usr/ local /mysql -- enable -assembler \ |
4 |
--with-unix-socket-path=/usr/ local /mysql/tmp/mysql.sock \ |
5 |
--with-mysqld-ldflags=-all-static \ |
6 |
--with-client-ldflags=-all-static \ |
7 |
--with-extra-charsets=all \ |
8 |
--without-debug --with-charset=utf8 \ |
9 |
--with-collation=utf8_general_ci \ |
10 |
--with-pthread -- enable -static \ |
11 |
-- enable -thread-safe-client |
完成后会提示"Thank you for choosing MySQL!"
最后会提示“make all win…”
4、添加用户,安装数据库
5 |
chown -R mysql:mysql ./ |
8 |
./bin/mysql_install_db --user=mysql |
9 |
cp share/mysql/my-medium.cnf /etc/my.cnf |
4、配置、开机自启动
2 |
./bin/mysqld_safe --user=mysql & |
5 |
kill 掉上述测试进程(一般是两个mysqld_safe是一个shell,它来启动mysqld的daemon) |
6 |
cp share/mysql/mysql.server /etc/init.d/mysqld |
8 |
chkconfig --level 2345 mysqld on |
5、my.cnf参数调优
6、安全配置
2 |
mysqladmin -u root password ‘new-password’ |
6 |
mysql> DROP DATABASE test ; [删除 test 数据库] |
7 |
mysql> DELETE FROM mysql.user WHERE user = '' ; [删除匿名帐户] |
8 |
mysql> FLUSH PRIVILEGES; [重载权限] |
7、小内存优化
只要不开InnoDB,my-medium.cnf 一般可以保证很小的内存占用和较高的性能了,具体的MySQL内存优化待续。
评论暂时关闭