… 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: 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…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… rows used from query syntax may be hard. Query Cache Storage Engines MySQL Query Cache now stores queries in local memory, which is… or for example local flash storage for storage. Compression You can see it as a property of Storage Engine but let me put it separately as well. I believe Query Storage…
Post: XtraDB storage engine release 1.0.4-8
October 12, 2009 By 12 Comments
… on startup on windows fix-import-extern-pages Number of mysql-tests are fixed The builds for RedHat4,5 and Debian are located on http://www.percona.com/mysql/xtradb/5.1.39-8/ The latest source code of… # apt-get install mysql-server-5.1 Please report any bugs found on Bugs in Percona XtraDB Storage Engine for MySQL. For general questions…
