… to be Innodb day in our Blog, but well this is the question which pops ups … a lot on systems with large number of hard drives. So how do you estimate how long it takes Innodb to… times to see how long it takes Innodb to recover. I’d recommend to crash by power cycling if possible because this makes…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… blog post in the series of blog posts leading up to the talk comparing the …make a lot of difference when the workload is IO bound, the query time is decreased from ~11min to under a minute. The query time…optimizer’s cost estimation algorithm. MariaDB 5.5 expands the concept of MRR to improve the…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
…to make…to generate the precise ALTER TABLE statements to drop these indexes, an exercise left to the reader. 
Estimating…a large table can take quite some time. All the normal tricks and tips about doing a…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… the most important to get right. I estimate that about …, the collect tool makes it easy to gather snapshots of …to ask a more senior person to help. I ask people such as Peter, Vadim, and Yasufumi for help all the time…blog site. Another interesting topic is how to examine a system that appears to…
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
…blog posts on replication on our blog, such as on replication being single-threaded, on semi-synchronous replication or on estimating… thread This process called IO thread connects to a master, reads binary log events from…Most of the time it will be the SQL thread, still it makes sense to double …
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
…a time-honored topic, and there’s no shortage of articles on the topic on this blog. I wanted to write a post trying to… grand hopes that it would allow Innodb to make better use of our IO in all operations… just a hair under the Max Checkpoint age). The two main methods here would be ‘estimate‘ (…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition Pushdown (ICP). Its… 5.6 and MariaDB 5.5 Now let’s take a look briefly at what this enhancement actually is, and what… be used for filtering records. For example, suppose you have a key defined as: KEY `i_l_partkey` (`l_partkey`,`l…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
…to next major MySQL version 6+ months after release. MySQL 5.5 is out almost a year ago and I would still estimate…make sense for our builds and MySQL Support offerings. Supporting many platforms and versions for long time… on this matter either as comments to this blog posts or as direct email to my …
