… really really matters. High-Memory Quadruple Extra Large Instance 68.4 GB of memory 26 EC2 Compute Units (8 virtual cores… to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the configuration that… = 800 innodb_read_io_threads = 8 innodb_write_io_threads = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 27 Comments
… MySQL 5.5 (vanilla version). “The big LOAD DATA INFILE clogs the binary log and slows replication down. If the load takes 4… on the master, it will cause the slave to fall 4 hours behind.” Yes, I agree the command will take a…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
… Percona Toolkit version just released work for regular community MySQL 5.5.23 or does it only work (or work better) with… on what is happening here? It seems as if MySQL 5.5 has been getting much slower (in terms of qps) with… slowed down mySQL as measured by qps, in the last 4-6 months? Best regards, Eddie
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
…/sec. I am still interesting in asynchronous IO, as MySQL 5.5 uses async IO for writes. Maybe 8 threads in the…=’6a6a6a’;l=’y';fs=’16′;fsb=’13′;bw=’100′;ff=’4‘;pc=’4889F0′;b=’s'; pid=’109242749016593233313′;
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… calculated inside MariaDB? Other Observations Sometimes both for MariaDB 5.5 and MySQL 5.6, the optimizer chooses the wrong query execution plan… is no difference in query times between MySQL 5.5 and MySQL 5.6/MariaDB 5.5 This is another area of improvement in the…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… solution for MySQL Users and is based on Percona Server 5.5.20. With this release we make clustering very easy and… setup into a cluster in just a couple minutes. Tomorrow, 4-April-2012, I will be giving a webinar where I… Cluster in 3 minutes Benchmarking Galera replication overhead Percona Server 5.5.15 + Galera 21.1-beta2 State of the art: Galera…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…. These optimizations are available in both MySQL 5.6 and MariaDB 5.5, and MariaDB 5.5 has introduced some additional optimizations which we will… disabled during these benchmark runs and that the disks are 4 5.4K disks in Software RAID5. Also note that the following…/ join_buffer_size=6M & read_rnd_buffer_size=6M MariaDB 5.5 MariaDB 5.5 w/ join_buffer_size=6M & mrr_buffer_size=6M…
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: Percona XtraDB Cluster 5.5.20 - Beta release
February 23, 2012 By 10 Comments
… Users and the beta release is based on Percona Server 5.5.20 and the recently released Galera 2.0 GA The… tar.gz and RPM binaries for RedHat (CentOS, Oracle Linux) 5 and 6, and Debian packages. Downloads: http://www.percona.com…=’6a6a6a’;l=’y';fs=’16′;fsb=’13′;bw=’100′;ff=’4‘;pc=’4889F0′;b=’s'; pid=’109242749016593233313′;
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… 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… echo 3 > /proc/sys/vm/drop_caches for numthreads in 4 do sysbench –test=fileio –file-total-size=${size}G –file…
