by Peter Zaitsev | Feb 26, 2013 | Insight for DBAs, MySQL
In many MySQL Benchmarks we can see performance compared with rather high level of concurrency. In some cases reaching 4,000 or more concurrent threads which hammer databases as quickly as possible resulting in hundreds or even thousands concurrently active queries....
by Ovais Tariq | Apr 4, 2012 | Benchmarks, Insight for DBAs, MySQL
This is the third blog post in the series of blog posts leading up to the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. This blog post is targeted at the join related optimizations introduced in the optimizer. These optimizations are...
by Ovais Tariq | Mar 12, 2012 | Benchmarks, Insight for DBAs, MySQL
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer...
by Vadim Tkachenko | May 12, 2006 | Insight for DBAs
In MySQL 5.0.19 the meaning of innodb_thread_concurrency variable was changed (yeah, again). Now innodb_thread_concurrency=0 means unlimitied count of concurrent threads inside InnoDB. It’s logical, but there was long way. In MySQL versions below 5.0.8 for...
by Peter Zaitsev | May 3, 2006 | Percona Events
Numerous talks at MySQL Users Conference and a lot of people asking me for my presentations motivated me to speed up launching of this site. I hope it will also motivate me to blog more frequently about performance as blog name implies. If you’re looking for...
