I have a MySQL db stored on an NTFS drive under Win10. There are constant INSERTs and DELETEs performed on the db. I see about 300 KB/s write traffic on the actual db file, and 1.5 MB/s write on $LogFile, which results in consistent 90-100% load on the HDD, preventing me from running anything else on it. Googling for 2 hours I couldn't find a solution, or even that exact issue mentioned anywhere. Why is MySQL going crazy on the NTFS log file? Is that normal? How can I turn it off? Turning off Volume Shadow Service or Defragmentation service as mentioned in some Google results did not solve it.
That didn't help, however doing a COMPLETE/Access defrag with O&O reduced the traffic from 1.5MB/s to 300KB/s. Still not ideal, but it's some improvement.
Perhaps antivirus? Also, have you tried uninstalling and reinstalling MySQL?
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.
Related Threads
?
?
?
?
?
Ask a question
Ask a question
Overclock.net
27.8M posts
541.2K members
Since 2004
A forum community dedicated to overclocking enthusiasts and testing the limits of computing. Come join the discussion about computing, builds, collections, displays, models, styles, scales, specifications, reviews, accessories, classifieds, and more!