InnoDB: space header page consists of zero bytes in tablespace

On a server, starting MySQL i get following error

This was because the server used InnoDB database engine and my.cnf was not configured properly.

First i removed the log files.

Now i edit /etc/my.cnf as follows

This MySQL config is based on /usr/share/doc/mysql-server-5.1.73/my-innodb-heavy-4G.cnf provided my MySQL.

You can also see this default MySQL InnoDB Heavy Config at

https://github.com/twitter/mysql/blob/master/support-files/my-innodb-heavy-4G.cnf.sh

Now i started MySQL, everything worked fine.

See mysql

Leave a Reply

Your email address will not be published. Required fields are marked *