mysql安装和优化[原创]
在日常生活中,我们使用mysql的地方很多,尤其是使用开源软件.下面介绍一下mysql的安装和优化,以安装源码为例!
1 安装
cd mysql-5.1.33
./BUILD/autorun.sh #安装第三方引擎或修改源码时候运行
./configure –prefix=/usr/local/mysql –enable-shared –disable-thread-safe-client –enable-assembler –enable-local-infile –with-charset=utf8 –with-extra-charsets=all –with-big-tables –with-ssl –with-embedded-server
make && make install
cp support-files/my-huge.cnf /etc/my.cnf
mysql_install_db –user=mysql
mysqladmin -u root password “xxxx”
2 优化
优化从这几个方面入手(mysql各个版本通用,注意名字不一定一样,可通过show variables查看)
* Slow Query Log
* Max Connections
* Worker Threads
* Key Buffer
* Query Cache
* Sort Buffer
* Joins
* Temp Tables
* Table (Open & Definition) Cache
* Table Locking
* Table Scans (read_buffer)
修改/etc/my.cnf的相应的参数如下:
skip-locking
key_buffer_size = 16M
max_allowed_packet = 10M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 1M
read_rnd_buffer_size = 2M
open_files_limit = 1000
max_connections = 300
max_connect_errors = 200
join_buffer_size = 128K
thread_cache_size = 10
thread_concurrency = 8
query_cache_size = 0M
query_cache_limit = 2M
query_cache_min_res_unit = 2k
thread_stack = 192K
tmp_table_size = 512K
long_query_time = 1
bulk_insert_buffer_size = 2M
myisam_sort_buffer_size = 8M
myisam_max_sort_file_size = 8G
myisam_max_extra_sort_file_size = 10G
myisam_repair_threads = 1
这篇文章目前没有评论