MySQL connect ERROR:

[ruben23]

Version: 2.14b0.5
SVN Version: 3067
DB Schema Version: 1564
DB Schema Update Date: 2019-03-01 18:32:30
Password Encryption:DISABLED - S1 - C1
Auto User-add Value: 101
Recording Prompt Count: 0
Install Date: 2019-03-01
ASterisk 1.8
Scratch install Ubuntu Server


HI, i have a Database Server/Web Server and 2 VICIDIAL/asterisk Server load balance, running on production its 45 agents running on it Our database Server is hitting 1.58 load AVG no CPU core spike on it. same with the rest of the asterisk server

Database/WEB Server - Dell Server 4 cores Xeon, 16GB memory and 2 Terabytes SATAII HDD
Asterisk/Vicidial - Dell Server 4 cores Xeon, 4GB memory and 2 Terabytes SATAII HDD

now during full operation im getting random error like this few in a while : MySQL connect ERROR: Can't connect to MySQL server on '192.168.10.250' (99) --------> (192.168.10.250') DATABASE/WEB LOCAL IP ADDRESS
Agents are not logout it just appear a couple of time on the realtime screen and also on the AGENTS Interface then once it gone they proceed, but i see deadcalls on the realtime with agent not all few only

on my HTOP monitoring i get Average load @ 1.58 and tried monitoring also with MYTOP but no activity on mytop at all

and to add up just recently this was monitored that this happens during we load leads during the peak production(meaning everyone is dialing, but our biggest leads load is only 20K leads) Any idea guys.? Anyone.?

[mflorell]

What is your "max_connections" set to in /etc/my.cnf?

Do you have slow query logging enabled in MySQL? If so, have you looked for long running queries when this is happening?

[williamconley]

mysql -e "show status like '%Aborted%'";

http://eflo.net/VICIDIALforum/viewtopic ... 73#p133462

[ruben23]

@Matt Florell

Thanks for reverting back, my max_connections = 1000 in my.cnf

and i enable slow log query i will check on it also, im suing MariaDB, ill make feedback about this, Thanks a lot