Home / server / Questions / 143200
In Process
outcassed
Asked: 2010-05-19 16:44:36 +0800 CST

What will happen if MySQL cannot write to InnoDB log?

  • 772

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?

mysql innodb

1 Answers

  1. 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.

    • 0