免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 2233 | 回复: 2
打印 上一主题 下一主题

請各位高手幇幇忙, 起动Server時有error [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2006-06-18 15:42 |只看该作者 |倒序浏览
060618 15:36:48  mysqld started
InnoDB: Error: log file ./ib_logfile0 is of different size 0 16356864 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
060618 15:36:48 [Note] /opt/mysql-standard-5.0.18-solaris10-x86_64/bin/mysqld: r
eady for connections.

服務器起动後, 一打開某Database, 服務器重起...

mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=8388600
read_buffer_size=131072
max_used_connections=1
max_connections=100
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225791
K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

060618 15:52:08  mysqld restarted
InnoDB: Error: log file ./ib_logfile0 is of different size 0 16356864 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
060618 15:52:08 [Note] /opt/mysql-standard-5.0.18-solaris10-x86_64/bin/mysqld: r
eady for connections.
Version: '5.0.18-standard'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Communi
ty Edition - Standard (GPL)

是否Database 有問題呢? 怎樣fix 呢?
怎樣解決啊??? Thanks 先謝各位高手...

[ 本帖最后由 lrx 于 2006-6-18 16:14 编辑 ]

论坛徽章:
0
2 [报告]
发表于 2006-06-19 08:31 |只看该作者
贴上你的配置文件先

论坛徽章:
0
3 [报告]
发表于 2006-06-19 16:04 |只看该作者
错误已经写的很清楚了,你肯定是改变了ib_logfile0 的大小或者位置,或者my.cnf中的这行的大小,my.cnf是5M,而你的ib_logfile0不匹配这个值 ,那这是个日值文件,你要是感觉日值不是很重要的话,干掉重启mysql就ok

感觉来这问问题的很多,问了以后自己解决的很少!

[ 本帖最后由 talen-t 于 2006-6-19 16:06 编辑 ]
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP