CPU usage mysql problem?

[Mimoza 0]

Hello devs, what can be the problem with mysql usage? at at least 500 players on?
https://prnt.sc/wmqoce

sometime mysql usage it s 100-150% and fucking more lag

some info: all databases it s on MyIsam

[Vanilla 1071]

You probably have too many heavy queries running. Execute this statement and see what queries are running. You may want to tune them down, cache results, etc... I guess you're running a webserver that accesses these databases? Mostly badly written admin tools could be the culprit for such heavy loads:

SHOW PROCESSLIST;

 

Also memory consumption isn't that high for such a big server. Check your buffer sizes, table cache and query cache because maybe you'd tune them to reduce cpu usage. It's a bit of a trade-off since you'll have more memory consumption but since the cpu bottlenecks your server for obvious reasons it's definitely a good deal. More info here: https://dev.mysql.com/doc/refman/8.0/en/memory-use.html and here: https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html