ssss

数据库版本Mysql 5.1.40

操作系统：2.6.18-194.el5  x86-64

硬件配置：2颗8core Xeon(R) CPU E5620/48G/12块300G(RAID 10)  net:100M/S

参数配置：

big_tables

skip_external_locking

skip-locking

skip-name-resolve

back_log = 100

max_connections = 800

max_connect_errors = 100000

interactive_timeout = 172800

connect_timeout = 10

max_allowed_packet = 4M

max_heap_table_size = 128M

tmp_table_size = 128M

max_length_for_sort_data = 4096

net_buffer_length = 8K

sort_buffer_size = 8M

join_buffer_size = 1M

read_buffer_size = 1M

read_rnd_buffer_size = 2M

table_cache = 1024

thread_cache_size = 64

thread_concurrency = 8

binlog_cache_size = 8M

max_binlog_size = 512M

innodb_file_per_table

innodb_autoinc_lock_mode = 1

innodb_fast_shutdown = 2

innodb_additional_mem_pool_size = 16M

innodb_buffer_pool_size = 8G

innodb_data_file_path = ibdata1:256M:autoextend(注意当文件突然增大的时候，可能是产生了大量回滚日志)

innodb_file_io_threads = 4

innodb_thread_concurrency = 0

innodb_log_buffer_size = 8M

innodb_log_file_size = 256M

innodb_log_files_in_group = 10

innodb_max_dirty_pages_pct = 20 (确保不会频繁checkpoint)

innodb_lock_wait_timeout = 120

innodb_flush_method=O_DIRECT (此选项一般在数据库前面还有CACHE和中间件这样对于数据安全性高)

 

 

状态变量：

Innodb_buffer_pool_pages_data = 1G

Innodb_buffer_pool_pages_dirty =

Innodb_buffer_pool_reads =

        

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12309491/viewspace-703032/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12309491/viewspace-703032/