… GB of instance storage 64-bit platform I… to the MySQL configuration. MySQL Configuration I used…query_cache_size = 0 query_cache_type = 0 You …ENGINE = InnoDB, PARTITION p8 VALUES LESS THAN (900000000) ENGINE = InnoDB, PARTITION p9 VALUES LESS THAN (1000000000) ENGINE… it varies between ~6.5k to ~12….
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… lookup on table2 are batched together and sent to the storage engine. The storage engine then uses the MRR interface (which I explained in… the lowest query time is for MySQL 5.6 which takes 0.16s less as compared to MySQL 5.5 While with join_buffer… a look at the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read_rnd_buffer…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… MySQL 5.6, increase of 0.02s. But the query times for MariaDB 5.5 are greater than both MySQL 5.5 and MySQL 5.6… these lookups are performed in a single call to the storage engine and the counters Handler_read_key and Innodb_rows_read… used then there are two separate calls made to the storage engine to perform the index record read and then to perform…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look… enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look…
Post: XtraDB storage engine release 1.0.6-9
January 13, 2010 By 9 Comments
… XtraDB storage engine is available. The release includes following new features: The release is base on 1.0.6 version of InnoDB plugin. MySQL 5…. Please report any bugs found on Bugs in Percona XtraDB Storage Engine for MySQL. For general questions use our Pecona-discussions group, and…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
… of our new storage engine is 1.0.2-1, which is forked from InnoDB-plugin-1.0.2. Percona … existing MySQL-5.1.30 installation http://www.percona.com/mysql/5.1.30/binary/percona-xtradb-1.0…. for development related questions. We are looking for 6-month release cycle of XtraDB. First several releases …
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… case, as TokuDB is a disk-based, read-write transactional storage engine that is based on special “fractal tree indexesâ€. Fractal… storage engine. The biggest problem is that MySQL does not yet provide an interface for that. This is going to be fixed in MySQL 6.0, but I can’t yet say how it will work with mix of storage engines. – The Tokutek engine I tested…
Post: XtraDB storage engine release 1.0.3-6
July 20, 2009 By 6 Comments
… to announce release 6 of XtraDB – the result of 2 months hard work. The release includes following new features: MySQL 5.1… Debian are located on http://www.percona.com/mysql/xtradb/5.1.36-6/ The latest source code of XtraDB, including development…. Please report any bugs found on Bugs in Percona XtraDB Storage Engine for MySQL. For general questions use our Pecona-discussions group, and…
Post: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
… be default transactional storage engine in MySQL 6.0 – I did not truly understand if it will be recommended transactional storage engine or just default storage engine will switch from MyISAM to Falcon. It was rather interesting to hear a lot about features of new storage engines such…
Post: MySQL Architecture meeting at Google
April 24, 2008 By 2 Comments
… on storage engine vendors and other extension areas. It was very interesting to see all these storage engine interface extensions which are planned for MySQL 6.0 and beyond – abilities to intercept query execution or offloading query fragments and operations (sorting limit etc) in the storage engines. This…
