紧急,mysqld错误

jinguanding

原帖由 yxyup 于 2008-8-15 10:26 发表



是cp过来的

那你mysql库之前是什么版本的。。。。。要是跟现有版本相差太大（即有升级的），就不要直接CP，
要是有SP,FUN,TRI就考虑dump了，，否则就不要用老版本的mysql，自己再创建下权限就可以

shengang34

http://dev.mysql.com/doc/refman/ ... ivilege-tables.html

执行mysql_fix_privilege_tables.sql脚本
mysql> SOURCE share/mysql_fix_privilege_tables.sql

其实忽略这个错误也没啥大问题。

yxyup

现在是已经升级到了 5.0.27

但是问题依然存在

Number of processes running now: 0
080815 11:51:34  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 11:51:47 [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: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)

shengang34

Out of memory

key_buffer_size + tmp_table_size + (read_buffer_size + sort_buffer_size + read_rnd_buffer_size +join_buffer_size )*max_connections = ？

如果大于你的物理内存，就会出现这个问题。好好看看你的参数把

yxyup

原帖由 shengang34 于 2008-8-15 13:04 发表
Out of memory

key_buffer_size + tmp_table_size + (read_buffer_size + sort_buffer_size + read_rnd_buffer_size +join_buffer_size )*max_connections = ？

如果大于你的物理内存，就会出现这个问题。好好看看你的参数把

这个算出来,确实大于了物理内存, 但有得时候是,只是不停的重启.如下

Number of processes running now: 0
080815 13:07:43  mysqld restarted
080815 13:07:53 [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)



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