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

What happens to MySQL if the partition that contains InnoDB's log files (innodb_log_group_home_dir) becomes full, read-only or otherwise unwritable?

If this did happen, what recovery process would be required? Could I use a slave to aid recovery of the master?

share|improve this question
What's the basis of your question? – Warner May 19 '10 at 1:53
Just curious. If something happens to the data_dir disk/array, the data is gone so recovery from slave or backup is necessary. What if something happens to innodb_log_group_home_dir? – Casey May 19 '10 at 3:05

Got a response on the MySQL InnoDB Forum. I that swear my question sounded less dumb when I posted it.

InnoDB cannot operate without the iblog files. They are pre-allocated, so "out of space" is not a failure mode, unwritable is.

The slave's iblog, binlog, relaylog, general log, etc, are all useless by themselves.

You should plan on stopping the slave, copying all the files over, etc, to rebuild the Master.

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.