…configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following …read_io_threads = 8 innodb_write_io_threads = 4 innodb_file_per_table = 1 ## Disabling …performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
…In this post I show the results of raw IO performance of this card. The benchmark methodology I described in …. I am still interesting in asynchronous IO, as MySQL 5.5 uses async IO for writes. Maybe 8 threads in …’;l=’y';fs=’16′;fsb=’13′;bw=’100′;ff=’4‘;pc=’4889F0′;b=’s'; pid=’109242749016593233313′;…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
… Toolkit version just released work for regular community MySQL 5.5.23 or does it only work (or work better) … lead author of High Performance MySQL. Is that the same title as the O’Reilly “High Performance MySQL” by Jeremy … down mySQL as measured by qps, in the last 4-6 months? Best regards, Eddie
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 9 Comments
… disabled during these benchmark runs and that the disks are 4 5.4K disks in Software RAID5. Also note that the following… were captured when performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read… MRR range scan is performed, but we can see its only incremented in MariaDB 5.5 and not in MySQL 5.6, is that…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… disabled during these benchmark runs and that the disks are 4 5.4K disks in Software RAID5. Also note that the following… MRR performance, and BKA uses the MRR interface, so these buffers indirectly impact BKA performance. I did not find much of a performance improvement from using Hash Join in MariaDB 5.5 or from Key…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking… Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look briefly at what…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… MiB/sec ext4 4 threads: 74 MiB/sec xfs 4 threads: 97 MiB/sec Dropping performance in case with 4 threads for ext4 is… and 5.5), InnoDB uses “asynchronous” IO in Linux. Let’s test “async” mode in sysbench, and now we can get: ext4 4… is to another question I was asked, namely: “If MySQL 5.5 uses async IO, is innodb_write_io_threads still important…
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
… provided me with an access to the server), and compare performance with SAS hard drives. System specification Dell PowerEdge R610 Memory… 32 (375GB). As a backend database I use Percona Server 5.5.19. I should mention that on these datasizes, sysbench workload… 1644 1.340946 64 140 571 4.078571 96 101 506 5.009901 128 89 486 5.460674 192 79 484 6.126582…
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 5 Comments
… could notice EXPLAIN itself was taking same 5 seconds, which points to problem with optimizer performance. Note though if you have subqueries… less than 50ms. Low values, such as 3,4 provided a bit better performance but I decided against using this as I… do we have value of 62 being default in MySQL 5.5 which can produce very expensive plan selections ? Investigating this further…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
…our latest stable release (which was 1.6.5 at the time of writing). This beta …Percona XtraBackup can now use multiple CPUs to perform a compressed backup, significantly reducing the amount … (‘–parallel’). For example, ‘–parallel=4 –compress –compress-threads=2′ will create 4 IO threads that will…
