mariadb high cpu

brkysnol

Wordops is installed on both my servers. But on my 1st server mariadb is using too much cpu. In the other, the ram caches the mariadb processes and the cpu usage doesn't even exceed 40%. On the other server, it goes up to 300-400% with a small purge and when I flush the redis cache, I can't log in for a few minutes. Sites with the same features and more or less the same traffic are set up on two servers.

brkysnol

@VirtuBox I am waiting for your help, how can I analyze this situation?

corus9

maybe try slow logs mysql and observe the queries

brkysnol

corus9

brkysnol

anseme

99% its not because of wordops, so its not the right place to get help. Because it can be anything... but usually its because of diskspeed and to frequently I/O operations on it...

More details about the application, php (wordpress + woocommerce? some extra service?) javascript (react, vue etc)?

Consider to install and use the monitoring system like zabbix or other where you can see the problems if vps is a culpit.

check disk speed on your vps if its to low (for example you have ssd but the speed is like hdd etc) ask vps support to check this.
active slow logs and find the problematic queries (ask developer to fix this or rewrite code)

The best is to hire some one who can analyse whole situation if you cant figure out what is the problem.