…. There is no difference in query syntax, client-server protocol, or data storage on disk. Anything that runs on MySQL will run identically…’s MySQL on another platform, it will work seamlessly. Why is Percona involved? Because providing quality server builds is a substantial engineering…
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… huge difference when the workload is IO bound and the query time drops from 2534.41s down to under a minute. MySQL… of a difference here. Now let’s take a look at the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… 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… is not used, there is no difference in query times between MySQL 5.5 and MySQL 5.6/MariaDB 5.5 This is…
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… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
… MySQL Storage Engines, and pluggable storage engines as MySQL 5.1 lays ? It is very much advertised this allows third parties to create their own storage engines… layer is much more complicated is constantly changed and different optimizations may change internal code paths dramatically. I know …
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… as on storage engine internally. We have to deal with different locking strategies storage engines may have and if we venture into using cross storage engine transactions… some tests being run for different storage engines, but really this is not enough as MySQL allows you using multiple storage engines in the query you…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… improve page cache efficiency in this respect, so in practice difference can be less. [-] Not fixed cache size, but size range… been implemented outside of MySQL Storage Engine level for MySQL – reading rows in their physical order can be applied to most storage engines, it certainly can…
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
…too bad MySQL Users Conference only allowed 45 minutes for Storage Engine presentations. This is complex topic and especially newsly presented storage engines deserved more…CPU bound workload – with disk IO situation can be rather different. Looking at PBXT architecture there is small row pointer …
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
… storage engine, “Percona XtraDB”, which is based on the InnoDB storage engine. It’…engine? Here is a list of new features and enhancements: INFORMATION_SCHEMA.XTRADB_ENHANCEMENTS. This table contains information about the differences…existing MySQL-5.1.30 installation http://www.percona.com/mysql/5…
Post: Trying Archive Storage Engine
November 12, 2006 By 6 Comments
… file: -rw-rw—- 1 mysql mysql 19 Nov 12 11:31 requests_061111.ARM -rw-rw—- 1 mysql mysql 984628803 Nov 12 11:29… to know which buffer size Archive storage engine using for reads – I could not find it as difference could be due to larger read_buffer_size used by MyISAM. Summary: Archive storage engine does compresses your…
