vicidial.org

Posted: **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

Posted: **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

Posted: **Fri Jan 11, 2008 9:01 pm**

Thanks Ram.

What is that script?

Posted: **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

Posted: **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=

vicidial.org

Too many mysql tables marked as crashed

Too many mysql tables marked as crashed