今天硬碟出現100%滿了的問題,我進系統把mysql-bin刪除了幾個,結果發現無法啟動mysql




20711 16:12:03 [Note] Recovering after a crash using mysql-bin
120711 16:12:03 [Note] Starting crash recovery...
120711 16:12:03 [Note] Crash recovery finished.
120711 16:12:03 - 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=0
read_buffer_size=2097152
max_used_connections=0
max_connections=1500
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 7680000 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.





解決辦法是把mysql-index檔中多餘的內容刪除即可
MICDBSTG01:root:/u02/mysql-5.0.67-aix5.3-powerpc-64bit/data>vi mysql-bin.index
"mysql-bin.index" 27 lines, 513 characters
./mysql-bin.000096
./mysql-bin.000097
./mysql-bin.000098
./mysql-bin.000099
./mysql-bin.000100
./mysql-bin.000101
./mysql-bin.000102
./mysql-bin.000103
./mysql-bin.000104
./mysql-bin.000105
./mysql-bin.000106
./mysql-bin.000107

 

創作者介紹
創作者 shadow 的頭像
shadow

資訊園

shadow 發表在 痞客邦 留言(0) 人氣()