Re: innodb madness

2007-02-06 Thread Rolando Edwards
Chris White" <[EMAIL PROTECTED]> To: "Marten Lehmann" <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: 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

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 lo

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 an