… move to Innodb. The reason of the move could be just desire for better data consistency guaranty or being bitten repairing multiple… Search indexes which are not supported for Innodb tables. So what can you do ? Leave Tables as MyISAM The beauty of MySQL storage… Innodb but build a “shadow” MyISAM table which is used for full text search. In certain cases you can just use MySQL…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 5 Comments
…indexes that this version of the engine doesn’t support. See http://dev.mysql.com/doc/refman/5.1/en/innodb…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… of rows in tens of thousands tables) Innodb was better choice mainly because of thouse …repaired, each may allocate myisam_sort_buffer_size and MySQL could crash or go swapping. Second – table will be locked while repair… of row cache. MyISAM tables only have indexes cached in key_buffer while data …
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…1.0.09) supports the MySQL Backup API which was originally implemented in MySQL 6.0. This feature is…the index page size is changed, then the indices need to be rebuilt, which can be done by REPAIR … the versions in indexes, and can PBXT use MVCC for index scans? If you are using InnoDB in REPEATABLE …
Post: Small things are better
October 8, 2006 By 15 Comments
…repairing took many hours especially as automatic check on boot failed and had to be manually restarted. Same may happen with Innodb…still they can get corrupted because of MySQL bugs, OS Bugs or hardware bugs, misconfiguration …be much faster this way as whole indexes will well fit in memory for such…
Comment: Duplicate indexes and redundant indexes
September 22, 2006 By 38 Comments
… in index are used with = as this is only case when execution can be better with unique index – after row is read MySQL… it is good idea as UNIQUE indexes are more expensive to maintain – for MyISAM tables repair by sort typically would not be used on LOAD DATA INFILE/ALTER TABLE for Innodb tables insert buffer…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
… FROM table1 WHERE column1 = id; The index is on column1. So when I would “REPAIR TABLE table1 QUICK” at about 4pm, the… fine. MySQL, I have come to realize, is as good as a file system on steroids and nothing more. InnoDB doesn’t… not available, for instance) and eking performance out of an InnoDB table for raw SELECT speed will take a committee of…
