EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Data Performance Blog

Latest articles from our experts:
EXPLAIN FORMAT=JSON has details for subqueries in ...

Over several previous blog posts, we’ve already discussed what information the  EXPLAIN FORMAT=JSON output provides for some subqueries. You can review those discussions here, here and here. EXPLAIN FORMAT=JSON shows many details that you can’t get with other commands. Let’s …

Read More
 
Peter Zaitsev webinar January 27th: Compression In...

Percona invites you to attend a webinar Wednesday, January 27th, with CEO Peter Zaitsev: Compression In Open Source Databases. Register now! Data growth has been tremendous in the last decade and shows no signs of stopping. …

Read More
 
Percona Live Data Performance Conference 2016: new...

The Percona Live Data Performance Conference 2016 is rapidly approaching, and we’re looking forward to providing an outstanding experience April 18-21 for all whom attend. Percona Live is the premier event for the rich and …

Read More
 
Tired of MySQL Making You Wait? Webinar: Questions...

We’d like to thank everybody for joining us on January 7th for our “Tired of MySQL Making You Wait?” webinar with Percona’s Alexander Rubin, Principal Consultant and SolarWinds’ Janis Griffin, Database Evangelist. Too often developers …

Read More
 
MongoDB revs you up: What storage engine is right ...

Differentiating Between MongoDB Storage Engines: RocksDB In this series of posts, we discussed what a storage engine is, and how you can determine the characteristics of one versus the other: “A database storage engine is the …

Read More
 
Dealing with corrupted InnoDB data

Data corruption! It can happen. Maybe because of a bug or storage problem that you didn’t expect, or MySQL crashes when a page checksum’s result is different from what it expected. Either way, corrupted data …

Read More
 
Making Apache Spark Four Times Faster

This is a followup to my previous post Apache Spark with Air ontime performance data. To recap an interesting point in that post: when using 48 cores with the server, the result was worse than with 12 …

Read More
 
OpenSSH CVE-2016-0777: Details and Mitigation

Earlier today advisories were sent out regarding OpenSSH versions 5.4 through 7.1., informing users about a security bug in the software. In essence, the advisory instructed people to add the   UseRoaming no option to their ssh_config file, …

Read More
 
Prometheus as an Engine for MySQL Monitoring

When I first discovered Graphite years ago, I was very impressed with its monitoring capabilities.  Compared to many RRD-based tools that were popular at the time (like Cacti), Graphite separated the captured data and graphs, …

Read More
 
Play the Percona Powerball Pool!!

The Only Sure Thing is Percona Powerball Pool Everyone is talking about the upcoming Powerball lottery draw. 1.4 BILLION dollars!! And growing! Millions of people are imagining what they would do IF they win. It’s the stuff of …

Read More
 


InnoDB Posts
InnoDB and TokuDB on AWS

In a recent post, Vadim compared the performance of Amazon Aurora and Percona Server on AWS. This time, I am comparing write throughput for InnoDB and TokuDB, using the same workload (sysbench oltp/update/update_non_index) and a similar set-up (r3.xlarge instance, …

Read More
 
Using dbsake to recover table structure from .frm ...

We work on data recoveries quite often. In many cases, we recover table structures from the .frm files because there was no backup available. There is already a great blog post by my colleague Miguel Ángel …

Read More
 


Insight for DBAs Posts
Better high availability: MySQL and Percona XtraDB...

High Availability Have you ever wondered if your application should be able to work in read-only mode? How important is that question? MySQL seems to be the most popular database solution for web-based products. Most …

Read More
 
Using dbsake to recover table structure from .frm ...

We work on data recoveries quite often. In many cases, we recover table structures from the .frm files because there was no backup available. There is already a great blog post by my colleague Miguel Ángel …

Read More
 


Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.

Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below.

No, thank you. Please do not ask me again.