[root@testbox-04 mysql]# cat /etc/issue
CentOS release 5.2 (Final)
Kernel \r on an \m
[root@testbox-04 mysql]# uname -r
2.6.18-92.1.22.el5
[root@testbox-04 mysql]# rpm -qa | grep mysql
mysql-5.0.45-7.el5
mysql-server-5.0.45-7.el5
mysql-5.0.45-7.el5
php-mysql-5.1.6-20.el5_2.1
mysql-devel-5.0.45-7.el5
mysql-devel-5.0.45-7.el5
mysql-test-5.0.45-7.el5
mysql-bench-5.0.45-7.el5
[root@testbox-04 mysql]# sestatus -bv | head -n1
SELinux status: enabled
[root@testbox-04 mysql]# sestatus -bv | grep mysql
allow_user_mysql_connect off
mysqld_disable_trans on
复制代码
my.cnf配置：
为了节省空间，打扰次序排序的
[root@testbox-04 mysql]# grep -v "#" /etc/my.cnf | sort | uniq
back_log = 50
bind-address = 192.168.12.81
binlog_cache_size = 1M
bulk_insert_buffer_size = 64M
[client]
default_table_type = INNODB
ft_min_word_len = 4
innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size = 2G
innodb_data_file_path = ibdata1:500M:autoextend
innodb_data_home_dir = /var/lib/mysql/ibdata
innodb_file_io_threads = 4
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 120
innodb_log_buffer_size = 32M
innodb_log_files_in_group = 3
innodb_log_file_size = 500M
innodb_log_group_home_dir=/var/lib/mysql/iblogs
innodb_max_dirty_pages_pct = 90
innodb_thread_concurrency = 16
interactive-timeout
[isamchk]
join_buffer_size = 8M
key_buffer = 512M
key_buffer_size = 32M
log_long_format
max_allowed_packet = 16M
max_connect_errors = 10
max_connections = 100
max_heap_table_size = 64M
[myisamchk]
myisam_max_extra_sort_file_size = 10G
