One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though… script with multiple level of concurrency and find out doing work from 32 processes is faster than just having one process…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… been working for a customer benchmarking insert performance on Amazon EC2, …MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the configuration that I used: ## InnoDB options innodb_buffer…we can see the impact of growth in data-set on the insert rate. We can see that …
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… works on my site on a Debian Squeeze system where I have to edit: /etc/mysql/my.cnf Also make sure that innodb_buffer_pool_size is for performance reasons set to x4 of log… innodb_buffer_pool_size). According to my previous posts in this blog a dynamic innodb log file RECREATE did NOT seem to work if…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…is known as probe step. This join algorithm works best for highly selective queries, and obviously… in-memory workload, the InnoDB buffer pool size is set to 6G and the buffer pool was warmed …MySQL 5.5 While with join_buffer_size set to 6M and read_rnd_buffer_size set to 6M, the query time for MySQL…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…-memory workload, the InnoDB buffer pool size is set to 6G and the buffer pool was …Innodb_buffer_pool_read_ahead which shows that the access pattern was sequential and hence InnoDB decided to do read_ahead, while in MySQL… key lookups as well. But this works only with joins and specifically with …
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…MySQL to use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable amount of connections but yet MySQL…MySQL to identify potential causes. Is it working …) | +——————————-+ | 126984 | +——————————-+ 1 row in set (0.98 …
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Comment: High Rate insertion with MySQL and Innodb
March 29, 2012 By 16 Comments
Thanks Peter, it worked! 
I am using python and MySql 5.5, I have an XML file which I parse … table has parent child relationship and the engine type is InnoDB. The process is very slow, it first checks either parent… inserted, otherwise it first inserts parent and then child, after setting innodb_buffer_pool_instances to 8, I don’t see any difference…
Post: How InnoDB handles REDO logging
February 3, 2011 By 18 Comments
… the double write buffer to ensure consistent page writes. Why log? Since InnoDB tries to keep the working set in memory (InnoDB Buffer Pool), therefore the…. Both the MySQL configuration and hardware will affect the speed at which InnoDB can log. You can request that InnoDB force its REDO…
Post: Reality of Innodb Caching
April 21, 2011 By 8 Comments
… mentioned few times Innodb caches data in pages and even if you have working set consisting of relatively few rows your working set in terms… are repeatedly selected in random order, which would illustrate data set with some randomly distributed “hot” rows. I read every row… disk reads in benchmark run itself. I’m using 128M buffer pool for this test, which should fit roughly 500K of…
