[RSS Feed/News] Improve MySQL write log efficiency

[XenForo]

Any thoughts on improving write log efficiency? I noticed MySQL CPU is spiking up... when IO spikes up. Which makes sense but what I can't figure out is how to improve write log efficiency.

Code:

-------- Performance Metrics -----------------------------------------------------------------------
[--] Up for: 25d 14h 26m 3s (163M q [73.731 qps], 4M conn, TX: 2504G, RX: 72G)
[--] Reads / Writes: 95% / 5%
[--] Binary logging is disabled
[--] Physical Memory     : 62.6G
[--] Max MySQL memory...

Read more

ادامه مطلب...