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 |
本文转自yifangyou 51CTO博客，原文链接：http://blog.51cto.com/yifangyou/617660，如需转载请自行联系原作者
