New answers tagged innodb
Do you have indexes on your thumb, parent, or auto columns? As a rule of ahem thumb, you should have an index on each column or group of columns in where clauses.
According to the mysql documentation, the 'opening tables' state shouldn't be seen unless there are locks getting in the way, or when your table_open_cache is too small. Check mysql's errorlog to find out what happened, check the show engine innodb status output for innodb info.
Maybe a mutex / lock went wild ? Probably a restart will fix. Otherwise you can check if there are any locks and release them by hand. Try with SHOW FULL PROCESSLIST;
Looks like innodb_force_recovery is set to 6 in your my.cnf, so it will not try to recover based on binary logs, try setting it to 0 instead. http://dev.mysql.com/doc/mysql-backup-excerpt/5.0/en/forcing-innodb-recovery.html check also that you had binary logs activated at the time of crash: http://dev.mysql.com/doc/refman/5.5/en/binary-log.html
As an error message says, have you checked: http://dev.mysql.com/doc/refman/5.6/en/crashing.html And also: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
unless you are running an old version, you need to load the innodb engine, as the "mysql" database now uses it for its tables internal tables (ie. "mysql"), and so wont start without it older versions you can exclude loading the innodb engine, per your example, so as to make it not load on restart that said, innodb is better that myiasm for most use cases ...
Top 50 recent answers are included