/usr/sbin/mysqlid consumes more RAM , how to optimize

[raymondcardoza]

How to optimize MySQL its consuming more RAM after certain interval of time.....

 

[EthernetServers]

I'd suggest having a look at mysqltuner - https://github.com/major/MySQLTuner-perl

 

[Zhenyapan]

look at mem % it uses only 1.8%
virt memory not equal to physical memory

Extremely large "VIRT" memory usage reported by `top`

On Ubuntu 20.04.4 LTS, on a machine which is a few years old. The attached screenshot of the output of top strikes me as really odd: I have a regular PC (nothing fancy) with 16 gigs of ram and no ...

askubuntu.com

 

[raymondcardoza]

I'd suggest having a look at mysqltuner - https://github.com/major/MySQLTuner-perl

Ok let me try and get back to you....

 

[raymondcardoza]

look at mem % it uses only 1.8%
virt memory not equal to physical memory

Extremely large "VIRT" memory usage reported by `top`

On Ubuntu 20.04.4 LTS, on a machine which is a few years old. The attached screenshot of the output of top strikes me as really odd: I have a regular PC (nothing fancy) with 16 gigs of ram and no ...

askubuntu.com

yes but how come CPU gets spike...

 

[Zhenyapan]

as i see - you have 32 threads and mysql uses only 80% of single thread - is it really problem?

 

[raymondcardoza]

as i see - you have 32 threads and mysql uses only 80% of single thread - is it really problem?

in some case... server gets slow... thats the reason i am worried...

 

[floyd]

Also your load is only around 3 out of 32. No reason for your server to be slow.

 

[Zhenyapan]

did you monitor it somehow? what "WA" in TOP when it slows? maybe network issues? what type of disks?

 

[raymondcardoza]

yestarday one incident happend... where gone slow... upon checking RAM and CPU usage got spike / increased for no reason

i have attached video for reference in google drive... after this incident Video Link of Incident in server

WhatsApp Video 2024-03-11 at 12.24.00 PM.mp4

drive.google.com

 

[raymondcardoza]

WhatsApp Video 2024-03-11 at 12.24.00 PM.mp4

drive.google.com

did you monitor it somehow? what "WA" in TOP when it slows? maybe network issues? what type of disks?