Too many mysql tables marked as crashed

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Too many mysql tables marked as crashed

Postby Juromer » Thu Jan 10, 2008 12:37 pm

Hello friends,

I get too many time "mysql tables crashed" with Vicidial/Asterisk server.
How could I do to improve my mysql or vicidial server?

Thanks a lots
Juromer
 
Posts: 6
Joined: Thu Jan 10, 2008 12:28 pm

Postby ramindia » Thu Jan 10, 2008 10:07 pm

Hi

the cron job already have some kind of tuning the database

may be you are running the script while agents are on.

still you want to do that, you need to do offtime

ram
Kindly post your feedback, if this solution works.
so its very usefull for others who join later as a NEWBIE.
ramindia
 
Posts: 688
Joined: Wed Oct 11, 2006 4:06 am
Location: India

Postby Juromer » Fri Jan 11, 2008 9:01 pm

Thanks Ram.

What is that script?
Juromer
 
Posts: 6
Joined: Thu Jan 10, 2008 12:28 pm

Postby ramindia » Fri Jan 11, 2008 10:00 pm

Hi

### optimize the database tables within the asterisk database
3 1 * * * /usr/share/astguiclient/AST_DB_optimize.pl



ram
Kindly post your feedback, if this solution works.
so its very usefull for others who join later as a NEWBIE.
ramindia
 
Posts: 688
Joined: Wed Oct 11, 2006 4:06 am
Location: India

Postby Op3r » Sat Jan 12, 2008 1:11 pm

Or you can use the one ytcracker posted. You can search for it here in the forum.

here is the link

http://www.eflo.net/VICIDIALforum/viewt ... highlight=
Get paid for US outbound Toll Free calls. PM me.
Op3r
 
Posts: 1432
Joined: Wed Jun 07, 2006 7:53 pm
Location: Manila


Return to Support

Who is online

Users browsing this forum: Bing [Bot] and 164 guests