ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ssss

ssss

原创 Linux操作系统 作者:dimen007 时间:2011-07-25 15:04:24 0 删除 编辑

数据库版本Mysql 5.1.40

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

硬件配置:28core Xeon(R) CPU E5620/48G/12300G(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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2010-06-17

  • 博文量
    11
  • 访问量
    20906