… backport from MySQL 5.5) show_engines – Changes SHOW STORAGE ENGINES to report XtraDB when appropriate. (… (Yasufumi Kinoshita) innodb_fast_index_creation – Allows disabling of fast index creation. (Yasufumi Kinoshita… questions our Percona-dev group. For support, commercial, and sponsorship …
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… temporary tables, which can be created in memory, using MEMORY storage engine or can be created on disk as MYISAM tables. Which… put to temporary tables – BLOB/TEXT columns are not supported with MEMORY storage engine so must use on disk MyISAM temporary table. What… large enough to fit all key blocks from temporary table index, so we get a lot of key writes which kill…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… of indexed columns that will be used to perform a lookup on table2 are batched together and sent to the storage engine. The storage engine… this means that we have traded many point index lookups to one or more index range lookups. This means MySQL can employ…. Hash Join As I have told before MySQL has only supported one join algorithm and that is Nested Loop Join. MariaDB…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… using Percona Server with enabled expand_fast_index_creation feature, as I just wrote this …default storage engine changed to Innodb in MySQL 5.5, meaning you might need to set storage_engine=MYISAM … not needed as MySQL 5.5 continues to support various character sets same as previous MySQL versions…
Page: Consulting for MySQL
July 31, 2006 By
…versions to old ones. Storage engine development assistance If you’re developing MySQL Storage Engine, Appliance or …tuning MySQL build in Full Text Search indexing or help you with selecting and …match your application needs. Platform advice and support for MySQL Need choosing Hardware and OS …
Comment: Testing MySQL column stores
August 16, 2010 By 15 Comments
… probably be significantly smaller than that stored in other storage engines, even those that support compression. Keep in mind that Infobright is designed…/InnoDB would need indexes to run the queries. Neither ICE nor InfiniDB need to create indexes, in fact, neither database even supports them.
Comment: System size and Performance Optimization
March 1, 2007 By 2 Comments
… need to be supported in all storage engines, because you basically index something when you do not store the data. Well storage engines of course could have a flag to say they do not support indexes…
Post: Hijacking Innodb Foreign Keys
January 2, 2012 By 2 Comments
…foreign Keys. MySQL supported Foreign Keys for Innodb for many years, yet rudimentary support initially added in… and foreign keys are still handled on storage engine level making them not working for partitioned…even though Innodb is able to drop indexes without rebuilding table since MySQL 5.1 (…
Post: Dynamic row format for MEMORY tables
September 6, 2011 By 5 Comments
… to CHAR. The lack of these features in the MEMORY storage engine (also known as HEAP) in MySQL has been one of… by the fact that variable-length records were not supported by the engine. This is true for all MySQL versions, including the… wasting space (VARCHAR) or outright impossible (BLOB). Indexes on BLOB columns are not supported. While we do not consider these limitations to…
Comment: Countless storage engines
May 4, 2007 By 6 Comments
… the lack of clustering by primary key support and not being able to use covering indexes means there is no way to… problems. Comparing Transactional storage engines though one need to take into account a lot of variables – how stable is engine and integration (the… web site exactly yet) – NitroDB and Infobright are very special storage engines and not surprisingly commercial. Plus Infobright one is currently Windows…
