vicidial.org

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.

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.

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.