… query syntax, client-server protocol, or data storage on disk. Anything that runs on MySQL will run identically on Zend DBi with…’s MySQL on another platform, it will work seamlessly. Why is Percona involved? Because providing quality server builds is a substantial engineering… own Percona Server variant of the MySQL server. We have a history of improving the MySQL server and finding and solving bugs…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…Compute Units each) 1690 GB of instance storage 64-bit platform I/O Performance: High…Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5…. ENGINE = InnoDB, PARTITION p8 VALUES LESS THAN (900000000) ENGINE = InnoDB, PARTITION p9 VALUES LESS THAN (1000000000) ENGINE =…
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… 5.5 is quite slow as compared to both MySQL 5.5 and MySQL 5.6. For MariaDB 5.5 the query… a look at the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd_bufer_size=4M… 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: How to diagnose errors in the MySQL error log
March 26, 2012 By 4 Comments
… 16:56:45 [ERROR] Got an error from unknown thread, storage/myisam/mi_write.c:223 120326 16:56:45 [ERROR… all of that mess is this bit: (Errcode: 28). Now, MySQL includes a little perror utility to translate this into something… the key to understanding what really happened. MySQL created a temporary table, using the MyISAM storage engine, and when the disk filled up…
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…
Comment: Best kept MySQLDump Secret
March 26, 2012 By 11 Comments
… is just how things were designed with MySQL and how transactions were retrofitted to it. MySQL has funny history this way. It… recent versions. The question is whenever MySQL will ever be redesigned to focus on transactional storage engines or whenever this will remain Drizzle…
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… LIMIT implementation – these can optimized but not by use of MySQL Storage Engine interface, which means it is also has to be implemented…
Post: Full text search for all MySQL Storage Engines
June 26, 2006 By 37 Comments
… only to MyISAM search engine as well as has few other limits. Today Sphinx Search plugin for MySQL was released which now provides fast and easy to use full text search solution for all storage engines. This version… you do not feel like patching MySQL or use MySQL 5.1 beta to use sphinx as MySQL Storage Engine you can still use it…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… given storage engine. Synchronization The top level on MySQL side, such as .frm files and binary log files has to be synchronized with storage engine… 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…
