… | Engine | Support | Comment | Transactions | XA | Savepoints | +————+———+———————————————————–+————–+—-+————+ | CSV | YES | CSV storage engine | NO… InnoDB is not compiled as storage engines. Perhaps it is related to new pluginable architecture and all engines are equal to be not… that InnoDB table can’t be created instead of calm converting to MyISAM
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… to inject MySQL 5.0 in between so it will convert binary log events, as described here yet it does not… while Innodb storage engine got dramatic performance improvements and is getting better in each new release. Also note the default storage engine changed to Innodb in MySQL 5.5, meaning you might need to set storage_engine=MYISAM if you’re…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
… Tables as MyISAM The beauty of MySQL storage engines is you do not have to convert all tables at once. In some cases… any significant changes to schema or queries. In general cross storage engine replication is not my favorite approach but sometimes it is… pretty well. Use Sphinx or other external full text search engine This is what we use a lot especially if performance…
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
… as well as which layer it corresponds to – SQL or storage engine. Honestly as it had name very similar to read_buffer… the case. read_rnd_buffer can be used for All storage engines not only by MyISAM. It is used for some sorts… case sort with row pointer storage is used and the fields which are being length can be converted to fixed size (basically…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
… thing however you’re allowed to change table to other storage engine and add extra indexes as you require. Doing so however…. Interesting enough however what would happen if one would use storage engine for log table which does not optimize TRUNCATE ? I guess… are blocked. More than that. I found even if I convert table to MyISAM, disable concurrent inserts and run long reporting…
Comment: Speeding up GROUP BY if you want aproximate results
March 7, 2008 By 24 Comments
… MEMORY storage engine. Second it can be converted to on disk table if it growths too large. In this case it was converted. Sorting…
Comment: Performance impact of complex queries
January 19, 2007 By 11 Comments
… it. You can create temporary table which can be any storage engine including HEAP or MySQL will automatically create temporary table for… execution which will often start as HEAP and will be converted to on disk if it grows too large. It is true ensuring your temporary table is not converted to the MyISAM is good way to improve performance. “use…
Comment: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown
March 17, 2013 By 2 Comments
… from the fact where the checks are made – by the storage engine itself or at SQL level. I think with well design… now by far most used engine – so row and index entries have to be copied to be converted from a way innodb…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
…is to drop old table and convert new table back to Innodb …+———–+———-+———-+———————————-+ | test.test | optimize | error | Got error -1 from storage engine | | test.test | optimize | status | Operation failed | …
Post: Performance gotcha of MySQL memory tables
February 1, 2008 By 5 Comments
… about comes from the fact it is the only MySQL storage engine which defaults to HASH index type by default, instead of…` tinyint(4) default NULL, PRIMARY KEY (`id`), KEY `c` (`c`) ) ENGINE=MEMORY and populated it with 1.000.000 rows ALL…=N) and get just about 80 deletes per second while converting table to MyISAM I get about 600 deletes per second…
