Mysql tables gets crashed

[arunvoip]

Hi,

Here is my setup:
1. Asterisk Server
2. Mysql + VIcidial server

my setup is working fine but some time I've noticed that some of my mysql tables gets crashed and server load is only 0.10 - 0.20. any idea.

thanks

[mr_mehul_shah]

Yes it do happens when your agents are dialing from your server and sudden power failure happens at that moment sometime it crashes the mysql tables.

[arunvoip]

but in this case there is no power failure. Everything is working fine and suddenly I noticed two tables crashed.

[devafree]

Hi
I have the same trouble, with MySQL crashing repeatedly. I had posted to the forum earlier and did the install afresh after checking for hardware faults and bad sectors on the hard disk, but the trouble continues. I can't figure it out at all. Please do let me know when you resolve. But, the thing is I am running another server with the same ditto hardware settings and versions, which is running fine. I can recover the tables with >mysqladmin shutdown, followed by /usr/bin/myisamchk -r /pathto/asterisk-db/*.MYI --force. After a while , there goes the crashes again.

Version - Asterisk 1.2.12.1
astguiclient - 2.0.1 , mysql - 4.0.27, apache - 2.0.59, php - 4.4.4

All locally installed on a p4 machine, 80 gb sata hdd, 1 gb ram, slack 10.2.

Thanks and regards
Devafree