Issue Reduce default Ram Usage and delete cached

[areawise]

Plesk is using 80-90% ram by default system and around 800-900 mb reserve for cached. Although not using any cache plugin now.

Sending screenshot. Please help, how to reduce default ram usage and delete cached resevere in plesk.

 

[Monty]

Help! Linux ate my RAM!

 

[areawise]

Hi @Monty
You are really Plesk Guru and assist in previous problem.
Reviewed above link and understand about that.

mysqld process is taking more cpu and ram. Is this necessary? If not how to disable permanently.

Next, how to optimize server for better performance? Means setting if any.

Thanks in advance.

 

[Monty]

There is no general rule about MySQL tuning. It highly depends on the usage and structure (how many databases, amount of data, database structure, query structure, amount of queries etc.). MySQL tuning is a big subject and requires good knowledge of MySQL, your databases and your customers.

Generally, it's a good idea to assign a decent amount of RAM to the MySQL server for buffers (most importantly InnoDB buffer pools). But to understand how big your buffers should be, you must first know the size and design of your databases and the amount of data therein.

Judging by the screenshot you posted, it's quite safe to assume that your server does not have any issues. Your CPU usage is low and you're not running low on memory.

If you think you may have a performance issue with MySQL then I suggest you read this as a starting point: Troubleshooting slow performance of the MySQL on Plesk server

 

[areawise]

CPU loaded is good but concern about RAM. Sometimes 100% and website not worked properly.

Is need mysqld (MySQL Process List (Beta)) ? If no, how can disable this. I can save around 8% memory use from this.

 

[Brujo]

Well I belive there is a little miss interpretation of the processlist and thats normal that the mysqld process use cpu & memory. maybe for you would be better to take a look at advanced Monitoring > Services to identify your problem. Also it would be more beneficial when you describe your real issue perhaps with error messages or findings in logfiles and what you mean by "website not worked properly". Then maybe someone here at Forum can help you more precise.

 

[areawise]

Really thanks for active reply in this forum.
Basically, Wordpress website become slow and goes down if 2-3 different process.
Error 524 Ray ID: 55fd97e04cf0d9f0 • 2020-02-04 15:14:16 UTC
A timeout occurred

It show 100% ram usage. Pls see screenshot and errorlog.txt and suggest.



Today Error Log:

[Tue Feb 04 18:57:47.548692 2020] [:error] [pid 10026:tid 140675278370560] [client 44.225.84.206:37562] [client 44.225.84.206] ModSecurity: Access denied with code 403 (phase 2). Pattern match "(?i?:^(?:microsoft url|user-Agent|www\\\\.weblogs\\\\.com|(?:jakart|vi)a|(google|i{0,1}explorer{0,1}\\\\.exe|(ms){0,1}ie( [0-9.]{1,}){0,1} {0,1}(compatible( browser){0,1}){0,1})$)|\\\\bdatacha0s\\\\b|; widows|\\\\\\\\r|a(?: href=|d(?:sarobot|vanced email extractor ..." at REQUEST_HEADERS:User-Agent. [file "/etc/apache2/modsecurity.d/rules/comodo_free/03_Global_Agents.conf"] [line "29"] [id "210831"] [rev "2"] [msg "COMODO WAF: Rogue web site crawler||example.com|F|4"] [data "Security Scan"] [severity "WARNING"] [tag "CWAF"] [tag "Agents"] [hostname "example.com"] [uri "/"] [unique_id "XjlxU6GAP5k@Y7doj6YkbQAAAJI"]
[Tue Feb 04 18:57:48.447797 2020] [:error] [pid 10026:tid 140675495474944] [client 44.225.84.206:37564] [client 44.225.84.206] ModSecurity: Access denied with code 403 (phase 2). Pattern match "(?i?:^(?:microsoft url|user-Agent|www\\\\.weblogs\\\\.com|(?:jakart|vi)a|(google|i{0,1}explorer{0,1}\\\\.exe|(ms){0,1}ie( [0-9.]{1,}){0,1} {0,1}(compatible( browser){0,1}){0,1})$)|\\\\bdatacha0s\\\\b|; widows|\\\\\\\\r|a(?: href=|d(?:sarobot|vanced email extractor ..." at REQUEST_HEADERS:User-Agent. [file "/etc/apache2/modsecurity.d/rules/comodo_free/03_Global_Agents.conf"] [line "29"] [id "210831"] [rev "2"] [msg "COMODO WAF: Rogue web site crawler||169.254.169.254|F|4"] [data "Security Scan"] [severity "WARNING"] [tag "CWAF"] [tag "Agents"] [hostname "169.254.169.254"] [uri "/"] [unique_id "XjlxVKGAP5k@Y7doj6YkbgAAAIE"]
[Tue Feb 04 18:57:49.335760 2020] [:error] [pid 10027:tid 140675495474944] [client 44.225.84.206:37566] [client 44.225.84.206] ModSecurity: Access denied with code 403 (phase 2). Pattern match "(?i?:^(?:microsoft url|user-Agent|www\\\\.weblogs\\\\.com|(?:jakart|vi)a|(google|i{0,1}explorer{0,1}\\\\.exe|(ms){0,1}ie( [0-9.]{1,}){0,1} {0,1}(compatible( browser){0,1}){0,1})$)|\\\\bdatacha0s\\\\b|; widows|\\\\\\\\r|a(?: href=|d(?:sarobot|vanced email extractor ..." at REQUEST_HEADERS:User-Agent. [file "/etc/apache2/modsecurity.d/rules/comodo_free/03_Global_Agents.conf"] [line "29"] [id "210831"] [rev "2"] [msg "COMODO WAF: Rogue web site crawler||[::ffff:a9fe:a9fe]|F|4"] [data "Security Scan"] [severity "WARNING"] [tag "CWAF"] [tag "Agents"] [hostname "::ffff:a9fe:a9fe"] [uri "/"] [unique_id "XjlxVaR8Muw2lpWUAq-pEgAAAME"]

 

[Brujo]

My opinion - so far the wrong approach from you where we simply took a wrong turn. Ok so the way I see it we have to start over here.

First of all the basic information about the operating system & Plesk versions. Do you use Nginx? and Cloudflare which I guess from the error message.

Then go straight to a Wordpress page where your problem occurs, which php versions & handlers have you set there fpm, fcgi...

and then we will see if we can help you here. Otherwise you can also request the professional service of Plesk.