centos5.4 64位下安装mysql5.5.14
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，如需轉載請自行聯系原作者
總結
以上是生活随笔為你收集整理的centos5.4 64位下安装mysql5.5.14的全部內容，希望文章能夠幫你解決所遇到的問題。
- 上一篇： Discuz x2.5目录结构注释
- 下一篇： UTF-8笔记170330