1)        下载

 

wget http://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-5.5/MySQL-client-5.5.14-1.rhel5.x86_64.rpm

wget http://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-5.5/MySQL-devel-5.5.14-1.rhel5.x86_64.rpm

wget http://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-5.5/MySQL-server-5.5.14-1.rhel5.x86_64.rpm

wget http://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-5.5/MySQL-shared-5.5.14-1.rhel5.x86_64.rpm

 

2)        安装，注意是否要保留原始数据，不保留的话把下面的#去掉

#rm –rf /var/lib/mysql

rpm -ivh MySQL-server-5.5.14-1.rhel5.x86_64.rpm

rpm -ivh MySQL-shared-5.5.14-1.rhel5.x86_64.rpm

rpm -ivh MySQL-devel-5.5.14-1.rhel5.x86_64.rpm

rpm -ivh MySQL-client-5.5.14-1.rhel5.x86_64.rpm

 

1)        优化mysql

mkdir /var/lib/mysql/

Vi /etc/my.cnf

把前面的部分修改为:

[client]

#password       = your_password

port            = 3306

socket          = /var/lib/mysql/mysql.sock

default-character-set=utf8

# Here follows entries for some specific programs

 

# The MySQL server

[mysqld]

character-set-server=utf8

language=/usr/share/mysql/english/

port            = 3306

socket          = /var/lib/mysql/mysql.sock

skip-name-resolve

#skip-locking

 

key_buffer = 100M

max_allowed_packet = 1M

table_cache = 1200

sort_buffer_size = 16M

net_buffer_length = 64K

read_buffer_size = 200M

read_rnd_buffer_size = 100M

myisam_sort_buffer_size = 100M

query_cache_size=200M

query_cache_limit=64M

thread_cache_size=60

 

key_buffer_size=200M

table_open_cache=1000

table_cache=1200

thread_cache_size=60

query_cache_size=200M

query_cache_limit=200M

table_definition_cache=1200

myisam_data_pointer_size=7

delayed_queue_size=2000

preload_buffer_size=65536

delayed_queue_size=20

preload_buffer_size=1024

 

#innodb_read_ahead_threshold=2

 

innodb_buffer_pool_size=200M;

innodb_additional_mem_pool=16M;

thread_concurrency = 2

 

2)        启动mysql

Service mysql start