EmergencyEMERGENCY? Get 24/7 Help Now!

Heartbleed: Separating FAQ From FUD

 | April 9, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Server for MySQL, Security

If you’ve been following this blog (my colleague, David Busby, posted about it yesterday) or any tech news outlet in the past few days, you’ve probably seen some mention of the “Heartbleed” vulnerability in certain versions of the OpenSSL library. So what is ‘Heartbleed’, really? In short, Heartbleed is an information-leak issue. An attacker can […]

Read More

Why TokuDB does not use the ‘uint3korr’ function

 | April 8, 2014 |  Posted In: Tokutek, TokuView

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 function for x86 and x86_64 processors. There is a big comment that says:

[…]

Read More

Optimizing MySQL Performance: Choosing the Right Tool for the Job

 | April 7, 2014 |  Posted In: Insight for DBAs, MySQL, Technical 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 the complex systems that define today’s web applications. Having a method and knowing how […]

Read More

Percona Live 2014 Recap

 | April 4, 2014 |  Posted In: Tokutek, TokuView

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 just wrapped up and I wanted to share my highlights […]

Read More

Facebook’s Yoshinori Matsunobu on MySQL, WebScaleSQL & Percona Live

 | April 4, 2014 |  Posted In: 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 Live MySQL Conference and Expo each year is very important to him. Facebook engineers are hosting several […]

Read More

Uninitialized data in the TokuDB recovery log

 | April 3, 2014 |  Posted In: Tokutek, TokuView

A TokuDB MySQL test run with valgrind reported an uninitialized data error when writing into the TokuDB recovery log.

TokuDB should not be storing uninitialized data into its files, so I need to find the the code that neglected to initialize the memory that eventually got written to the recovery log. An update SQL […]

Read More

On TokuMX Oplog, Tailable Cursors, and Concurrency

 | April 2, 2014 |  Posted In: Tokutek, TokuView

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 can write data to the oplog concurrently, whereas MongoDB cannot. As a result, […]

Read More

How to add an existing Percona XtraDB Cluster to Percona ClusterControl

 | April 1, 2014 |  Posted In: Insight for DBAs, MySQL, Percona XtraDB Cluster

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 add your existing cluster to Percona ClusterControl […]

Read More