VICIDIAL v.2.2.0-svb
BUILD: 90315-1010 VICIDIAL
Asterisk Version: 1.4.21.2
dell intel xeon e5310 1.60ghz dual processors
6g memory
os linux open suse 11.2
mysql 5 installed
how to check MySQL for performance issues and how to ensure normal delivery of service between Vicidial and MySQL.
my sql
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
3 posts
• Page 1 of 1
my sql
by Principal21 » Mon May 17, 2010 4:14 pm
- Principal21
- Posts: 39
- Joined: Tue May 04, 2010 11:51 am
by williamconley » Sat May 22, 2010 10:55 am
What performance issues are you looking for?
Normal delivery would allow calls. anything "substandard" would cause vicidial to fail. Vicidial relies heavily on SQL and will act in a SERIOUSLY erratic manner if SQL does not perform up to par.
luckily, mysql is a very stable package and has never (in my experience) been the problem UNLESS THE DISK IS FULL or the server is overloaded.
Normal delivery would allow calls. anything "substandard" would cause vicidial to fail. Vicidial relies heavily on SQL and will act in a SERIOUSLY erratic manner if SQL does not perform up to par.
luckily, mysql is a very stable package and has never (in my experience) been the problem UNLESS THE DISK IS FULL or the server is overloaded.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
- williamconley
- Posts: 20258
- Joined: Wed Oct 31, 2007 4:17 pm
- Location: Davenport, FL (By Disney!)
by Kumba » Wed May 26, 2010 2:30 pm
There is actually a locking issue in MySQl v.5.1.36 and earlier that causes ViciDial to grind to a halt considerably. The fix is to run a later version of MySQL 5.1.
As far as MySQl v.5.0 goes, any one past v.5.0.67 is good in our opinion.
As far as MySQl v.5.0 goes, any one past v.5.0.67 is good in our opinion.
- Kumba
- Posts: 939
- Joined: Tue Oct 16, 2007 11:44 pm
- Location: Florida
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 122 guests