cPanel Forums

Mysql cpu load to high 190%, Query very slow, 20% load RAM, browsing very slow Server: Intel(R) Xeon(R) CPU E5-2680 v4 @ 2.40GHz x 16 32 GB RAM./tuning-primer.s

I need help optimizing MySQL

Mysql cpu load to high 190%, Query very slow , 20% load RAM, browsing very slow
Server:
Intel(R) Xeon(R) CPU E5-2680 v4 @ 2.40GHz x 16
32 GB RAM



./tuning-primer.sh

Code:
-- MYSQL PERFORMANCE TUNING PRIMER --
      - By: Matthew Montgomery -

MySQL Version 10.3.34-MariaDB-cll-lve x86_64

Uptime = 0 days 1 hrs 16 min 25 sec
Avg. qps = 383
Total Questions = 1756315
Threads Coected = 6

Warning: Server has not been ruing for at least 48hrs.
It may not be safe to use these...
I need help optimizing MySQL
+ نوشته شده در  ساعت 14:20  توسط generator  برچسب ها: