High load average by MYSQL

bcx

Verified User
Joined
Dec 11, 2015
Messages
75
Hi,

I'm having an issue for the past 3 days now and I'm unable to solve it or to find the problem.

Attached you can see that I'm having a very high load caused by the MySQL.

I tried to update mariadb, replace the Wordpress and content files with a backup just in case there is some kind of malware on my website. As for some reason, someone was able to reinstall Wordpress :s

I've rebooted the server with my host. I updated all files, plugins, etc.. but nothing seems to solve the high load.


Or maybe it's by a bad database backup restore or migration? What should I do in this case?

I have backups of all databases.
 

Attachments

  • 2021-10-06_18-13-14.jpg
    2021-10-06_18-13-14.jpg
    242.4 KB · Views: 74
install and just run to script. I'm totally new with this script.

But the performance output is this:
Not sure if this is good or bad.

-------- Performance Metrics --------------------------------------------------- --------------------
[--] Up for: 1h 51m 3s (1M q [150.752 qps], 5K conn, TX: 15G, RX: 134M)
[--] Reads / Writes: 98% / 2%
[--] Binary logging is disabled
[--] Physical Memory : 15.4G
[--] Max MySQL memory : 11.3G
[--] Other process memory: 0B
[--] Total buffers: 1.4G global + 66.9M per thread (151 max threads)
[--] P_S Max memory usage: 0B
[--] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 3.3G (21.31% of installed RAM)
[OK] Maximum possible memory usage: 11.3G (72.99% of installed RAM)
[OK] Overall possible memory usage with other process is compatible with memory available
[OK] Slow queries: 0% (0/1M)
[OK] Highest usage of available connections: 19% (29/151)
[OK] Aborted connections: 0.05% (3/5565)
[!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
[OK] Query cache is disabled by default due to mutex contention on multiprocesso r machines.
[OK] Sorts requiring temporary tables: 0% (1 temp sorts / 113K sorts)
[OK] No joins without indexes
[!!] Temporary tables created on disk: 43% (31K on disk / 73K total)
[OK] Thread cache hit rate: 99% (29 created / 5K connections)
[OK] Table cache hit rate: 99% (1M hits / 1M requests)
[!!] table_definition_cache(1000) is lower than number of tables(1161)
[OK] Open file limit used: 1% (422/32K)
[OK] Table locks acquired immediately: 100% (4K immediate / 4K locks)

-------- Performance schema ---------------------------------------------------- --------------------
[--] Performance schema is disabled.
[--] Memory used by P_S: 0B
[--] Sys schema isn't installed.


ps thank you for this tip.
 
At the very end it would have gave some recommendations of changes for your /etc/my.cnf that would need to be added to the [mysqld] section. Adjusting the table_definition_cache, add skip-name-resolve=1 to disable dns lookups, and look though the end of the report for other adjustments. If you have a lot of databases/tables and they are large you will probably need more ram. It's a handy tool, also for best results it's best if the Mysql/Mariadb server has been running at least for a while under normal use.
 
Did you try to run SHOW PROCESSLIST with the da_admin user to see what processes are running?
 
Back
Top