不知道为什么,我的mysql 5.0.27老是会出现Got error 134 from storage engine,大约半个月就会出现一次.Repair table之后就回复正常.
先说说情况:
articles 文章表 大约有4万条记录,Data length是181MB,
member 会员表 大约有40万能条记录,Datalength是76mb,
网站访问约为5000个IP,6万个PV,平均每天1000篇文章左右,会员基本不变.
服务器是:
Intel(R) Xeon(R) CPU 5130 @ 2.00GHz x2
内存 4G
硬盘一个scsi+一个sata 数据库在scsi 上面.
查了一个,发现134错误的意思是
shell> perror 126 127 132 134 135 136 141 144 145
MySQL error code 126 = Index file is crashed
MySQL error code 127 = Record-file is crashed
MySQL error code 132 = Old database file
[b]MySQL error code 134 = Record was already deleted (or record file crashed)[/b]
MySQL error code 135 = No more room in record file
MySQL error code 136 = No more room in index file
MySQL error code 141 = Duplicate unique key or constraint on write or update
MySQL error code 144 = Table is crashed and last repair failed
MySQL error code 145 = Table was marked as crashed and should be repaired
访问量都很少,不知道是哪里出了问题,是mysql问题?
虽然repair一下就OK,但总不能等问题出来才去处理.google了很多.都没有找到答案.在mysql上也找不到我要的信息.
大家有遇到这样的问题吗?如何避免?谢谢.
先说说情况:
articles 文章表 大约有4万条记录,Data length是181MB,
member 会员表 大约有40万能条记录,Datalength是76mb,
网站访问约为5000个IP,6万个PV,平均每天1000篇文章左右,会员基本不变.
服务器是:
Intel(R) Xeon(R) CPU 5130 @ 2.00GHz x2
内存 4G
硬盘一个scsi+一个sata 数据库在scsi 上面.
查了一个,发现134错误的意思是
shell> perror 126 127 132 134 135 136 141 144 145
MySQL error code 126 = Index file is crashed
MySQL error code 127 = Record-file is crashed
MySQL error code 132 = Old database file
[b]MySQL error code 134 = Record was already deleted (or record file crashed)[/b]
MySQL error code 135 = No more room in record file
MySQL error code 136 = No more room in index file
MySQL error code 141 = Duplicate unique key or constraint on write or update
MySQL error code 144 = Table is crashed and last repair failed
MySQL error code 145 = Table was marked as crashed and should be repaired
访问量都很少,不知道是哪里出了问题,是mysql问题?
虽然repair一下就OK,但总不能等问题出来才去处理.google了很多.都没有找到答案.在mysql上也找不到我要的信息.
大家有遇到这样的问题吗?如何避免?谢谢.