by Hrvoje Matijakovic | Jun 27, 2013 | MySQL, Percona Software
Percona is glad to announce the second Release Candidate release of Percona Server 5.6.12-60.4 on June 27th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on the recently released MySQL 5.6.12, including all the bug fixes in it,...
by Hrvoje Matijakovic | Jun 3, 2013 | MySQL, Percona Software
Percona is glad to announce the first Release Candidate release of Percona Server 5.6.11-60.3 on June 3rd, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.6.11, including all the bug fixes in it, Percona Server...
by Hrvoje Matijakovic | May 24, 2013 | MySQL, Percona Software
Percona is glad to announce the release of Percona Server for MySQL 5.5.31-30.3 on May 24, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.31, including all the bug fixes in it, Percona Server 5.5.31-30.3 is now the...
by Alexey Stroganov | May 8, 2013 | Benchmarks, MySQL
Around month ago Facebook has announced the Linkbench benchmark that models the social graph OLTP workload. Sources, along with a very nice description of how to setup and run this benchmark, can be found here. We decided to run this benchmark for MySQL Server 5.5.30,...
by Vadim Tkachenko | May 7, 2013 | Benchmarks, MySQL
After compiling Percona Server with TokuDB, of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m interested in testing – it is an insert-intensive workload (which is TokuDB’s strong suit) with some roll-up...
by Alexey Kopytov | Apr 12, 2013 | Benchmarks, MySQL
One major problem in terms of MySQL performance that still stands in the way of InnoDB scalability is the trx_list scan on consistent read view creation. It was originally reported as a part of MySQL bug #49169 and can be described as follows. Whenever a connection...
by Vadim Tkachenko | Mar 21, 2013 | MySQL, Percona Events
I actually don’t remember exactly whether it was in 2006, 2007 or 2008 — but around that time the MySQL community had one of the greatest MySQL conferences put on by O’Reilly and MySQL. It was a good, stable, predictable time. Shortly thereafter, the MySQL...
by Vadim Tkachenko | Mar 16, 2013 | MySQL
For this post I’m going to shamelessly exploit the litany of technical problems SimCity players encountered earlier this month and a few examples of how Thread Pool for MySQL and Percona Server for MySQL can help to prevent such incidents. Users of SimCity, a...
by Hrvoje Matijakovic | Mar 14, 2013 | MySQL
Percona is glad to announce the release of Percona Server for MySQL 5.6.10-60.2 on March 14, 2013. (Downloads are available here and from the experimental Percona Software Repositories). Based on MySQL 5.6.10, including all the bug fixes in it, Percona...
by Hrvoje Matijakovic | Mar 8, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server for MySQL version 5.1.67-14.4 on March 8, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.67, including all the bug fixes in it, Percona Server 5.1.67-14.4 is...
by Vadim Tkachenko | Feb 28, 2013 | MySQL, Percona Software
Following Roel’s post, Percona Server on the Raspberry Pi: Your own MySQL Database Server , I thought what other crazy gadget can I run Percona Server on? And having an Asus Nexus 7 Android tablet I decided to give it a try. Anything below contains a risk that...
by Hrvoje Matijakovic | Feb 26, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server for MySQL version 5.5.29-30.0 on February 26th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.29, including all the bug fixes in it, Percona...
by Peter Zaitsev | Feb 16, 2013 | MySQL
One of the most useful tools if you’re working with multiple versions of MySQL Servers is MySQL Sandbox which allows you to maintain many different versions of MySQL, Percona Server, MariaDB. If you’re just working with single sandbox you can just use...
by Hrvoje Matijakovic | Jan 8, 2013 | MySQL
Percona is glad to announce the release of Percona Server 5.5.28-29.3 on January 8th, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.28, including all the bug fixes in it, Percona Server 5.5.28-29.3 is now the...
by Peter Zaitsev | Jan 3, 2013 | Percona Software
Are you a fan of Percona Server? You can show your support by casting a vote for Percona Server in the SQL Technologies Top Innovator 2013 category of the DeveloperWeek Awards. You can vote through January 7, and voting is easy. Just login, select Percona from the...
by Peter Zaitsev | Jan 3, 2013 | Insight for DBAs, MySQL
I prefer to run MySQL with innodb_flush_method=O_DIRECT in most cases – it makes sure there is no overhead of double buffering and I can save the limited amount of file system cache I would normally have on database server for those things which need to be...
by Aurimas Mikalauskas | Apr 7, 2011 | Insight for DBAs, MySQL
I don’t use many tools in my consulting practice but for the ones I do, I try to know them as best as I can. I’ve been using mk-query-digest for almost as long as it exists but it continues to surprise me in ways I couldn’t imagine it would. This...
by Aurimas Mikalauskas | Mar 28, 2011 | Insight for DBAs, MySQL
Have you ever seen BIG weird numbers in mk-query-digest report that just seem wrong? I have! Here’s one report I got today: ... # Attribute total min max avg 95% stddev median # ============ ======= ======= ======= ======= ======= ======= ======= # Exec time...
by Fred Linhoss | Feb 16, 2011 | MySQL, Percona Software
It’s finally here! Percona Server Percona Server 5.5.8-20.0 is now available for download. This is a beta release of Percona’s enhancements to the MySQL 5.5.8 server. Here are some highlights: Performance and scalability improvements throughout the server...
by Vadim Tkachenko | Jan 13, 2011 | Benchmarks, MySQL
In my recent benchmarks, such as this one about the Virident TachIon card, I used different values for innodb_buffer_pool_size, like 13GB, 52GB, and 144GB, for testing the tpcc-mysql database with size 100G. This was needed in order to test different memory/dataset...
