Chinaunix

标题: mysqld,异常自动重启 [打印本页]

作者: yxyup    时间: 2008-08-15 12:56
标题: mysqld,异常自动重启
Number of processes running now: 0
080815 12:12:19  mysqld restarted
080815 12:12:38 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.0.27-standard-log'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Edition - Standard (GPL)

Number of processes running now: 0
080815 12:13:42  mysqld restarted
080815 12:13:46 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.0.27-standard-log'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Edition - Standard (GPL)

Number of processes running now: 0
080815 12:15:26  mysqld restarted
^G/usr/local/mysql/bin/mysqld: Out of memory (Needed 118763520 bytes)
^G/usr/local/mysql/bin/mysqld: Out of memory (Needed 89072640 bytes)
^G/usr/local/mysql/bin/mysqld: Out of memory (Needed 66803712 bytes)
^G/usr/local/mysql/bin/mysqld: Out of memory (Needed 50101248 bytes)
080815 12:15:37 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.0.27-standard-log'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Edition - Standard (GPL)
作者: 枫影谁用了    时间: 2008-08-15 12:58
Out of memory (Needed 118763520 bytes)

my.cnf里的配置呢
作者: yxyup    时间: 2008-08-15 13:01
原帖由 枫影谁用了 于 2008-8-15 12:58 发表
Out of memory (Needed 118763520 bytes)

my.cnf里的配置呢


max_connections         = 500
max_connect_errors      = 100000
key_buffer              = 128M
myisam_sort_buffer_size = 51200000
join_buffer_size        = 2097152
read_buffer_size        = 4194304
sort_buffer_size        = 4194304
table_cache             = 1000
thread_cache_size       = 80
max_join_size           = 512000000
max_binlog_cache_size   = 512000000
tmp_table_size          = 102400000
max_heap_table_size     = 102400000
read_rnd_buffer_size    = 5242880
bulk_insert_buffer_size = 32M
thread_concurrency      = 2
query_cache_limit       = 4000000
query_cache_size        = 0
query_cache_type        = 1
wait_timeout            = 7200
interactive_timeout     = 7200
skip-innodb
skip-bdb
log-slow-queries
long_query_time=10




欢迎光临 Chinaunix (http://bbs.chinaunix.net/) Powered by Discuz! X3.2