现有服务器配置
WEB
CPU : Intel Q8300
主板: 华硕
内存:金士顿2GB * 2
硬盘:SATA 500G *2
(MYSQL备份,与MYSQL主从热备)
MYSQL
CPU : Intel Xeon E5506 * 2
主板: 华硕Z8NA-D6
内存:金士顿4GB * 2
硬盘:SAS 146
(WEB备份,SERSYNC与WEB服务器同步)
系统软件(同)
CENTOS5.5+NGINX+MYSQL+PHP
以前一直用W2003, 刚刚转为LINUX,不太熟悉,现在是MYSQL服务器隔一个星期就在深更半夜宿机,具体问题我都找不出来.求高手帮助. 联系QQ 5114997
MYSQL服务器上的MYSQL配置文件
- [client]
- character-set-server = utf8
- port = 3306
- socket = /tmp/mysql.sock
- [mysqld]
- server-id = 1
- character-set-server = utf8
- replicate-ignore-db=mysql
- replicate-ignore-db = information_schema
- user = mysql
- port = 3306
- socket = /tmp/mysql.sock
- basedir = /usr/local/webserver/mysql
- datadir = /usr/local/mysqldata/data
- log-error = /usr/local/mysqldata/mysql_error.log
- pid-file = /usr/local/mysqldata/mysql.pid
- skip-innodb
- open_files_limit = 10240
- back_log = 500
- max_connections = 2048
- max_connect_errors = 509600
- table_cache = 1024
- external-locking = FALSE
- max_allowed_packet = 32M
- sort_buffer_size = 64M
- join_buffer_size = 32M
- thread_cache_size = 128
- #thread_concurrency = 8
- query_cache_size = 512M
- query_cache_limit = 2M
- query_cache_min_res_unit = 2k
- default-storage-engine = MyISAM
- thread_stack = 192K
- transaction_isolation = READ-COMMITTED
- tmp_table_size = 512M
- max_heap_table_size = 246M
- long_query_time = 3
- log-slave-updates
- log-bin = /usr/local/mysqldata/binlog/binlog
- binlog_cache_size = 4M
- binlog_format = MIXED
- max_binlog_cache_size = 8M
- max_binlog_size = 1G
- relay-log-index = /usr/local/mysqldata/relaylog/relaylog
- relay-log-info-file = /usr/local/mysqldata/relaylog/relaylog
- relay-log = /usr/local/mysqldata/relaylog/relaylog
- expire_logs_days = 15
- key_buffer_size = 2048M
- read_buffer_size = 64M
- read_rnd_buffer_size = 128M
- bulk_insert_buffer_size = 64M
- myisam_sort_buffer_size = 512M
- myisam_max_sort_file_size = 10G
- myisam_repair_threads = 1
- myisam_recover
- interactive_timeout = 120
- wait_timeout = 120
- skip-name-resolve
- #master-connect-retry = 10
- slave-skip-errors = 1032,1062,126,1114,1146,1048,1396
- #master-host = 192.168.1.2
- #master-user = username
- #master-password = password
- #master-port = 3306
- innodb_additional_mem_pool_size = 16M
- innodb_buffer_pool_size = 512M
- innodb_data_file_path = ibdata1:256M:autoextend
- innodb_file_io_threads = 4
- innodb_thread_concurrency = 8
- innodb_flush_log_at_trx_commit = 2
- innodb_log_buffer_size = 16M
- innodb_log_file_size = 128M
- innodb_log_files_in_group = 3
- innodb_max_dirty_pages_pct = 90
- innodb_lock_wait_timeout = 120
- innodb_file_per_table = 0
- slow_query_log=1
- slow_query_log_file = /usr/local/mysqldata/slow.log
- #log-slow-queries = /usr/local/mysqldata/slow.log
- long_query_time = 1
- [mysqldump]
- quick
- max_allowed_packet = 64M
复制代码
|