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
I need help optimizing MySQL
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...
+ نوشته شده در ساعت 14:20 توسط generator
برچسب ها:
|