High RAM Usage

Any and all non-support discussions

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

High RAM Usage

Postby TLS_Lama » Fri Jul 07, 2023 2:09 am

Type : Vicidial Single server call center
RAM capacity: 4GB
Number of Agents Login: No agents logged for 6 months.
Issue: Memory usage is over 90% even though there is no agents logged for months. When check htop, highest ram usage user is mysql.

What can be the reason for high RAM usage?

TIA!
TLS_Lama
 
Posts: 3
Joined: Wed Jun 16, 2021 6:59 am

Re: High RAM Usage

Postby martinch » Tue Jul 18, 2023 1:37 pm

What is the name of the process taking up all the CPU time?
Project Lead @ mDial -> https://github.com/TheBlode/mDial
martinch
 
Posts: 273
Joined: Thu Nov 15, 2018 9:14 am
Location: England, UK

Re: High RAM Usage

Postby TLS_Lama » Fri Jul 28, 2023 1:37 am

its mysql

/usr/sbin/mysqld --defaults-file=/etc/my.conf --user=mysql

more than 20 same processes are still active there.

Please support. Thanks for the reply as well.
TLS_Lama
 
Posts: 3
Joined: Wed Jun 16, 2021 6:59 am

Re: High RAM Usage

Postby martinch » Mon Jul 31, 2023 5:46 pm

TLS_Lama wrote:its mysql

/usr/sbin/mysqld --defaults-file=/etc/my.conf --user=mysql

more than 20 same processes are still active there.

Please support. Thanks for the reply as well.


Good evening, apologies for the late reply.

I would recommend a couple of checks on the system;

- Check slow.log see if there is a query that is clogging up the database. It may reveal the suspect script or the resource hog.
- If you don't intend to use the cluster for now, you can manually start turning off the cron jobs...it's likely the database activity is coming from one of those. Possibly some script is overlapping or simply looping.
- Are the campaigns still active on the cluster?
- You may want to add a few SQL triggers onto the database to capture some of the activity...potentially something is eating up the RAM usage.

I hope this helps...I'm on DM as well if you need me. :) You can also check out ##vicidial on Libera.Chat :)

Cheers,
Martin.
Project Lead @ mDial -> https://github.com/TheBlode/mDial
martinch
 
Posts: 273
Joined: Thu Nov 15, 2018 9:14 am
Location: England, UK


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 42 guests