… in 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: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
… MiB/sec. I am still interesting in asynchronous IO, as MySQL 5.5 uses async IO for writes. Maybe 8 threads in the… good question how does it affect MySQL performance, and I am going to run some MySQL workloads on these cards to understand…=’6a6a6a’;l=’y';fs=’16′;fsb=’13′;bw=’100′;ff=’4‘;pc=’4889F0′;b=’s'; pid=’109242749016593233313′;
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is… = 800 innodb_read_io_threads = 8 innodb_write_io_threads = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache… was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… of MySQL 5.6 and MariaDB 5.5. Note that query cache is disabled during these benchmark runs and that the disks are 4 5.4K… time for 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 IO… workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd_bufer_size=4M MariaDB 5.5 MariaDB 5.5 w/ mrr_buffer_size=4M…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… the disks are 4 5.4K disks in Software RAID5. Also note that the following changes were made on MySQL 5.6 config: optimizer… for MySQL 5.6 becomes approximately equal to that of MySQL 5.5. MariaDB 5.5 is quite slow as compared to both MySQL 5.5 and MySQL 5.6. For MariaDB 5.5… counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read_rnd_buffer_size=6M MariaDB 5.5 MariaDB 5.5 w/ join_buffer…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking… Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look briefly at what…
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 6 Comments
… time to less than 50ms. Low values, such as 3,4 provided a bit better performance but I decided against using… in MySQL 5.5 which can produce very expensive plan selections ? Investigating this further I found the following explanation from Timour Katchaounov in MySQL… plan computation would be more important than backward compatibility. In MySQL 5.6 things are likely to get even better handling joins…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… a High Availability and Scalability solution for MySQL Users and is based on Percona Server 5.5.20. With this release we make clustering very easy and affordable for everyone. You can convert your existing MySQL replication…=’6a6a6a’;l=’y';fs=’16′;fsb=’13′;bw=’100′;ff=’4‘;pc=’4889F0′;b=’s'; pid=’109242749016593233313′;
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… is. As of MySQL 5.5 FLUSH TABLES WITH…4 | | 10305 | root | localhost | dumptest | Query | 0 | NULL | show processlist | 0 | 0 | 1 | +——-+——+———–+———-+————+——+——————————+——————————+———–+—————+———–+ 5…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… point to consider. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “asynchronous” IO…. This 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…
