… PCIe cards. It really makes sense to test it under MySQL workload, but before getting to that, let me review the…-io driver version: 2.3.10 build 110; Firmware v5.0.7, rev 107053 Following the format of previous benchmarks, first… for Intel 520. For 8 threads it is 0.6 ms ( for Intel 520 – 0.69 ms). To better understand patterns in the…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-…= 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer pool …can be classified as large, because it varies between ~6.5k to ~12.5k INSERTs per second, with …
Post: Announcing Percona XtraBackup 1.6.6
April 4, 2012 By 3 Comments
… announce the latest minor release in the Percona XtraBackup 1.6 series. We recognise that not everybody will want or be… new major release, Percona XtraBackup 2.0 and so we’re also releasing Percona XtraBackup 1.6.6. This is a minor release… repositories are now carrying Percona XtraBackup 2.0.0, so you won’t see 1.6.6 there. We’re also keeping the documentation…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
….0.0 release contains no changes from the last beta (1.9.2), only the version number has changed. New since 1.6… be part of the topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically, there are the following… – 16:20 @ Ballroom F You can download Percona XtraBackup 2.0.0 from our downloads site or install it using our YUM…
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 6 Comments
… for this problem was to use set optimizer_search_depth=0, rarely used option which as per manual will chose best… as if we assume MySQL users do not join lots of tables (less than 7) when using 0 as default value would… computation would be more important than backward compatibility. In MySQL 5.6 things are likely to get even better handling joins of…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… the graph above the labels mean as follows: MySQL 5.6 (2) is for MySQL 5.6 w/ buffer size 6M MariaDB 5.5… 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… on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd_bufer_size=4M MariaDB 5… not in MySQL 5.6, is that because of a bug in MySQL 5.6 code? As MRR was used in both MySQL 5.6 and…
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: Percona XtraBackup 1.9.2 released (Beta)
March 29, 2012 By 2 Comments
… release in the process of going towards Percona XtraBackup 2.0.0. This is a BETA quality release and is not inteded… should use the current Stable version – currently 1.6.5 in the 1.6 series at the time of writing. The 1… used to distinguish between pre-release versions of PerconaXtraBackup 2.0 and the Generally Available final release. If you wish to…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… to announce the second beta release towards Percona XtraBackup 2.0! We call this version 1.9.1 as we are… the 1.9.x version numbers for betas of 2.0 to clearly differentiate beta releases from the final 2… use, check out our latest stable release (which was 1.6.5 at the time of writing). This beta adds some…
