High RAM Usage

[TLS_Lama]

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!

[martinch]

What is the name of the process taking up all the CPU time?

[TLS_Lama]

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.

[martinch]

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.