…MyISAM (eventually packed). The only issue was that for one of the table, … should be faster, especially with the keys disabled. At that point, I remembered…mysql> alter table test_concat add data varchar(10); Query OK, 0 rows affected (0.01 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> alter table…
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
…ALTER TABLE Innodb, same as MyISAM will internally run analyze as soon as table is rebuilt and values will be more sensible: mysql> alter table…
