Database flooded with thousands of requests while not in use

All installation and configuration problems and questions

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

Database flooded with thousands of requests while not in use

Postby drodecker » Wed Apr 14, 2021 4:54 am

For the second day now, our vicidial agent conversations have been crippled with poor audio and disconnects.
A concerning flag we can see is that the dedicated ViciDB is pegged at 100% CPU (according to the load indicator, curiously top shows a much more conservative value hovering around ~3.5%).

In running a mysql general_log trace, we observe literally thousands of hits despite it being off hours and there are no agents are logged in, no calls happening.

Seems we probably have some over-zealous tasks running or configured. Any advise where to look/tune?

Server is a recent Dell performance model, I don't have specific specs but it's an SSD, with plenty of multi-core CPUs and RAM.

Image

Image

Image
Last edited by drodecker on Wed Apr 14, 2021 5:39 am, edited 7 times in total.
drodecker
 
Posts: 25
Joined: Wed Oct 09, 2019 11:18 pm

Re: Database flooded with thousands of requests not in use

Postby drodecker » Wed Apr 14, 2021 5:18 am

drodecker
 
Posts: 25
Joined: Wed Oct 09, 2019 11:18 pm

Re: Database flooded with thousands of requests while not in

Postby carpenox » Wed Apr 14, 2021 1:01 pm

this type of thing is hard to debug via the forum, msg me personally on skype and ill see if i can help you through it
Alma Linux 9.3 | SVN Version: 3822 | DB Schema Version: 1711 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3 | Discord: https://discord.gg/DVktk6smbh
carpenox
 
Posts: 2247
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL


Return to Support

Who is online

Users browsing this forum: Majestic-12 [Bot] and 80 guests