CPU usage mysql problem?

[Mimoza 4]

Hello devs, what can be the problem with mysql usage? at at least 500 players on?
https://metin2.download/picture/QYQGHR4Bqu6GcZ5aQLAQtX76lqs9Vun4/.png

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

some info: all databases it s on MyIsam

Edited September 4, 2022 by Metin2 Dev
Core X - External 2 Internal

[Vanilla 1371]

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