my sql

Any and all non-support discussions

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

my sql

Postby Principal21 » Mon May 17, 2010 4:14 pm

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.
Principal21
 
Posts: 39
Joined: Tue May 04, 2010 11:51 am

Postby 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.
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
williamconley
 
Posts: 20019
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby 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.
Kumba
 
Posts: 939
Joined: Tue Oct 16, 2007 11:44 pm
Location: Florida


Return to General Discussion

Who is online

Users browsing this forum: Google [Bot] and 241 guests