… table without updating indexes took 18 seconds, and about the same time was spent on rebuilding the index using fast index creation. So we… secondary index pages to the buffer pool. A benchmark is worth a thousand words, so let’s repeat the last test with innodb… a FOREIGN KEY constraint; mysqldump –innodb-optimize-keys ignores foreign keys because InnoDB requires a full table rebuild on foreign key changes. So…
Post: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
December 9, 2010 By 13 Comments
… TABLE for Innodb tables does not get advantage of it for whatever reason. Lets take a look at little benchmark I done… table is exposed without indexes for some time. Note though nothing stops you from using LOCK TABLES on Innodb table to ensure… no indexes and bringing box down. You can also use this trick for ALTER TABLE which requires table rebuild. Dropping all indexes; doing…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… all of them are Innodb specific and it well can affect your workload. So benchmark to be sure. In Innodb besides scalability changes… run to show any table / index fragmentation, without having to run the OPTIMIZE? HT: Since OPTIMIZE rebuilds the whole table, it may… that adaptive hash indexes are not used for primary key lookups or not showed up in “show innodb statusâ€. select * from…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… the case, and do you have any recent benchmarks available? This is no longer necessarily the case. …The table data page size does not require a rebuild because a page of records in the table …keep the versions in indexes, and can PBXT use MVCC for index scans? If you are using InnoDB in REPEATABLE …
