Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Our production MySql database lives on single data partition. There really isn't anything else on that partition other than the databases. Is it safe to run a windows defrag on that partition? Will MySql lock tables, could it slow down query times? We have Server 2008 and MySql 5.1.

share|improve this question

migrated from Jun 23 '11 at 20:10

This question came from our site for professional and enthusiast programmers.

up vote 0 down vote accepted

Yes, it is safe to run a Windows defrag on the partition. To reduce performance impact, you might consider a third-party defragger (e.g. PerfectDisk, which will have minimal performance overhead. This tool can also prevent most fragmentation and reduce the rate of fragmentation, further reducing the issues you are experiencnig.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.