Re: innodb madness

2007-02-06 Thread Chris White
Marten Lehmann wrote: How can I check which tables are using innodb with sql? How can walk through the tables with show databases and show tables. Thanks. This somewhat depends on how the tables were declared. If you used ENGINE=InnoDb; in the CREATE TABLE sequence, you'd be able to loop

Re: innodb madness

2007-02-06 Thread Rolando Edwards
: Tuesday, February 6, 2007 1:24:46 PM (GMT-0500) US/Eastern Subject: Re: innodb madness Marten Lehmann wrote: How can I check which tables are using innodb with sql? How can walk through the tables with show databases and show tables. Thanks. This somewhat depends on how the tables were declared

innodb madness

2007-02-05 Thread Marten Lehmann
Hello, mysql was such a reliable and unbreakable database until innodb showed up. All the time I had problems with mysql it was related to innodb. Today again: InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... 070206 09:29:19 mysqld ended Is there