Chinaunix首页 | 论坛 | 博客
  • 博客访问: 4213089
  • 博文数量: 291
  • 博客积分: 8003
  • 博客等级: 大校
  • 技术积分: 4275
  • 用 户 组: 普通用户
  • 注册时间: 2010-10-30 18:28
文章分类

全部博文(291)

文章存档

2017年(1)

2013年(47)

2012年(115)

2011年(121)

2010年(7)

分类: Mysql/postgreSQL

2012-07-11 16:29:26

今天硬盘出现100%满了的问题,我进系统把mysql-bin删除了几个,结果发现无法启动mysql


点击(此处)折叠或打开

  1. 20711 16:12:03 [Note] Recovering after a crash using mysql-bin
  2. 120711 16:12:03 [Note] Starting crash recovery...
  3. 120711 16:12:03 [Note] Crash recovery finished.
  4. 120711 16:12:03 - mysqld got signal 11 ;
  5. This could be because you hit a bug. It is also possible that this binary
  6. or one of the libraries it was linked against is corrupt, improperly built,
  7. or misconfigured. This error can also be caused by malfunctioning hardware.
  8. We will try our best to scrape up some info that will hopefully help diagnose
  9. the problem, but since we have already crashed, something is definitely wrong
  10. and this may fail.
  11. key_buffer_size=0
  12. read_buffer_size=2097152
  13. max_used_connections=0
  14. max_connections=1500
  15. threads_connected=0
  16. It is possible that mysqld could use up to
  17. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 7680000 K
  18. bytes of memory
  19. Hope that's ok; if not, decrease some variables in the equation.
解决办法是把mysql-index文件中多余的内容删除即可

点击(此处)折叠或打开

  1. MICDBSTG01:root:/u02/mysql-5.0.67-aix5.3-powerpc-64bit/data>vi mysql-bin.index
  2. "mysql-bin.index" 27 lines, 513 characters
  3. ./mysql-bin.000096
  4. ./mysql-bin.000097
  5. ./mysql-bin.000098
  6. ./mysql-bin.000099
  7. ./mysql-bin.000100
  8. ./mysql-bin.000101
  9. ./mysql-bin.000102
  10. ./mysql-bin.000103
  11. ./mysql-bin.000104
  12. ./mysql-bin.000105
  13. ./mysql-bin.000106
  14. ./mysql-bin.000107

阅读(6077) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~