Overclock.net banner

MySQL constantly writes to $LogFile (NTFS Volume Log)

2K views 5 replies 3 participants last post by  Mrzev 
#1 ·
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.

Halp!
 
#2 ·
bump
 
#4 ·
Quote:
Originally Posted by alan242 View Post

Is indexing turned on for the drive?

Does the file and/or directory have NTFS compression turned on?
Yes on index, no on compression.

Will turning off the index solve it? I'll try when I can.
 
#5 ·
Quote:
Originally Posted by ronnin426850 View Post

Yes on index, no on compression.

Will turning off the index solve it? I'll try when I can.
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.
 
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.
Top