All installation and configuration problems and questions
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
by 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
by 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
by 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
by 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
by 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. visit https://stopmanualdial.com for vicidial services.
-
Op3r
-
- Posts: 1432
- Joined: Wed Jun 07, 2006 7:53 pm
- Location: Manila
-
Return to Support
Who is online
Users browsing this forum: No registered users and 73 guests