by David Busby | Apr 8, 2014 | Insight for DBAs, MySQL
The heartbleed bug was introduced in OpenSSL 1.0.1 and is present in 1.0.1 1.0.1a 1.0.1b 1.0.1c 1.0.1d 1.0.1e 1.0.1f The bug is not present in 1.0.1g, nor is it present in the 1.0.0 branch nor the 0.9.8 branch of OpenSSL some sources report 1.0.2-beta is also affected...
by Rich.Prohaska | Apr 8, 2014 | MySQL
The ‘uint3korr’ function inside of the mysqld server extracts a 3 byte unsigned integer from a memory buffer. One use is for ‘mediumint’ columns which encode their value in 3 bytes. MySQL 5.6 and MariaDB 10.0 claims to have optimized this...
by Ryan Lowe | Apr 7, 2014 | Insight for DBAs, MySQL, Webinars
Next Wednesday, I will present a webinar about MySQL performance profiling tools that every MySQL DBA should know. Application performance is a key aspect of ensuring a good experience for your end users. But finding and fixing performance bottlenecks is difficult in...
by Tim.Callaghan | Apr 4, 2014 | MySQL
The MySQL community continues to amaze me, everyone is friendly and always willing to answer questions and help others. It’s always nice to meet people in-person that I’ve met virtually in the last 12 months. Percona Live 2014 MySQL Conference and Expo in Santa Clara...
by Tom Diederich | Apr 4, 2014 | Insight for DBAs, MySQL, Percona Live
I spoke with Facebook database engineer Yoshinori Matsunobu here at Percona Live 2014 today about a range of topics, including MySQL at Facebook, the company’s recent move to WebScaleSQL, new MySQL flash storage technologies – and why attending the Percona...
by Rich.Prohaska | Apr 3, 2014 | MySQL
A TokuDB MySQL test run with valgrind reported an uninitialized data error when writing into the TokuDB recovery log. ==1032== Syscall param write(buf) points to uninitialised byte(s) ==1032== at 0x3EFA60E4ED: ??? (in /lib64/libpthread-2.12.so) ==1032== by 0xB894038:...
by Zardosht.Kasheff | Apr 2, 2014 | MySQL
In a post last week, I described the difference in concurrency behavior between MongoDB’s oplog and TokuMX’s oplog. In short, here are the key differences: MongoDB protects access to the oplog with a database level reader/writer lock, whereas TokuMX does not. TokuMX...
by Miguel Angel Nieto | Apr 1, 2014 | Insight for DBAs, MySQL, Percona Software
In my last blog post I explained how to use Percona ClusterControl to create a new Percona XtraDB Cluster from scratch. That’s a good option when you want to create a testing environment in just some mouse clicks. In this case I’m going to show you how to...
by Peter Boros | Mar 31, 2014 | Benchmarks, Insight for DBAs, MySQL, Percona Live, Percona Services
ScaleArc recently hired Percona to perform various tests on its database traffic management product. This post is the outcome of the benchmarks carried out by Uday Sawant (ScaleArc) and myself. You can also download the report directly as a PDF here. The goal of these...
by Hrvoje Matijakovic | Mar 28, 2014 | MySQL
Percona is glad to announce the release of Percona XtraBackup 2.2.1-alpha1 on March 28th 2014. Downloads are available from our download site here. This ALPHA release, will be available in our Debian experimental and CentOS testing repositories. This is an ALPHA...
by Vlad Lesin | Mar 28, 2014 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Percona Server 5.6.11-60.3 introduces a new “log archiving” feature. Percona XtraBackup 2.1.5 supports “apply archived logs.” What does it mean and how it can be used? Percona products propose three kinds of incremental backups. The first is...
by Zardosht.Kasheff | Mar 28, 2014 | MySQL
In my last post, I describe the differences between a TokuMX oplog entry and a MongoDB oplog entry. One reason why the entries are so different is that TokuMX supports multi-statement and multi-document transactions. In this post, I want to elaborate on why...
by Hrvoje Matijakovic | Mar 27, 2014 | Percona Events, Percona Software
Percona is glad to announce the first BETA release of Percona Server 5.6.16-64.2 with TokuDB engine on March 27th, 2014. Downloads are available here and from the Percona Software Repositories. Based on Percona Server 5.6.16-64.2 including all the features and bug...
by Rich.Prohaska | Mar 27, 2014 | MySQL
We have seen TokuDB lock escalation stall the execution of SQL operations for tens of seconds. To address this problem, we changed the lock escalation algorithm used by TokuDB and TokuMX so that the cost of lock escalation only affects big transactions. We also...
by Tom Diederich | Mar 27, 2014 | MySQL, Percona Live
Facebook, the undisputed king of online social networks, has 1.23 billion monthly active users collectively contributing to an ocean of data-intensive tasks – making the company one of the world’s top MySQL users. A small army of Facebook MySQL experts will be...
by Zardosht.Kasheff | Mar 26, 2014 | MySQL
by Matt Griffin | Mar 26, 2014 | Insight for DBAs, MySQL, Percona Live
The Percona Live MySQL Conference and Expo 2014 runs April 1-4 at the Santa Clara Convention Center and Santa Clara Hyatt – but be sure to get there a day early for the inaugural Open Source Appreciation Day on March 31 – this event is free but because...
by David Busby | Mar 25, 2014 | MySQL, Percona Live, Security
Ah database security… the black sheep of topics and something you would really rather not have to deal with right? I mean surely all the fanfare and paranoia is reserved for the neck beards with tinfoil hats whom live in their own D.I.Y Faraday cage … that...
by Hrvoje Matijakovic | Mar 25, 2014 | Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.5.36-34.2 on March 25th, 2014 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.36, including all the bug fixes in it, Percona Server 5.5.36-34.2 is now the current...
by Hrvoje Matijakovic | Mar 25, 2014 | Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.6.16-64.2 on March 25th, 2014. Downloads are available here and from the Percona Software Repositories. Based on MySQL 5.6.16, including all the bug fixes in it, Percona Server 5.6.16-64.1 is the current GA...
