…. There is no difference in query syntax, client-server protocol, or data storage on disk. Anything that runs on MySQL will run identically…? Because providing quality server builds is a substantial engineering effort that requires a lot of expertise to do right, and Percona has…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 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… equal to that of MySQL 5.5. MariaDB 5.5 is quite slow as compared to both MySQL 5.5 and MySQL 5.6… much 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
…execute, ~11 hours in case of MySQL 5.5 and ~5 hours in case of MySQL 5.6 and MariaDB 5.5….lookups are performed in a single call to the storage engine and the counters Handler_read_key and Innodb_rows…no difference in query times between MySQL 5.5 and MySQL 5.6/MariaDB 5.5 This is another area of …
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
…of 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… constantly changed and different optimizations may change internal code paths dramatically. I know number of projects being interested …
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… cross storage engine transactions we’re up for a lot of surprises. Backup Cross storage engine backup is a pain because they are so different. Some of… different storage engines, but really this is not enough as MySQL allows you using multiple storage engines in the query you need to test all kinds of…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…have 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…rows were inserted in different times a lot of scattered reads will be needed. Think about typical use of Innodb clustering – users …
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… which are stored in different locations which may require a lot of IO for large data sizes. But you of course should take… MySQL 5.1 in one of our projects) and if developed with same pace and dedication it will become one major storage engine for MySQL…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… is quite nice. Each shard contains only 128MB of data! Storage engine makes a big difference In general, a column store performs about 8x….cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
… least for now). The first version of our new storage engine is 1.0.2-1, …engine? Here is a list of new features and enhancements: INFORMATION_SCHEMA.XTRADB_ENHANCEMENTS. This table contains information about the differences… for existing MySQL-5.1.30 installation http://www.percona.com/mysql/5.1….
