EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Data Performance Blog

Latest articles from our experts:
Percona Live Crash Courses: for MySQL and MongoDB!

Percona Live Crash Courses for MySQL and MongoDB The database community constantly tells us how hard it is to find someone with MySQL and MongoDB DBA skills who can help with the day-to-day management of their databases. …

Read More
 
Experimental Percona Docker images for Percona Ser...

Docker is incredibly popular tool for deploying software, so we decided to provide a Percona Docker image for both Percona Server MySQL and Percona Server for MongoDB. We want to create an easy way to try …

Read More
 
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
 
EXPLAIN FORMAT=JSON knows everything about UNIONs:...

Ready for another post in the EXPLAIN FORMAT=JSON is Cool series! Great! This post will discuss how to see all the information that is contained in optimized queries with UNION using the union_result and query_specifications commands.   When …

Read More
 
Percona XtraDB Cluster 5.6.28-25.14 is now availab...

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on January 29, 2016. Binaries are available from the downloads area or from our software repositories. Percona XtraDB Cluster 5.6.28-25.14 is now the …

Read More
 
Vote Percona Server in LinuxQuestions.org Members ...

Percona is calling on you! Vote Percona for Database of the Year in LinuxQuestions.org Members Choice Awards 2015. Help our Percona Server get recognized as one of the best database options for data performance. Percona …

Read More
 
Setup a MongoDB replica/sharding set in seconds

In the MySQL world, we’re used to playing in the MySQL Sandbox. It allows us to deploy a testing replication environment in seconds, without a great deal of effort or navigating multiple virtual machines. It is a …

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

Differentiating Between MongoDB Storage Engines: PerconaFT 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
 
Percona CEO Peter Zaitsev discusses working remote...

As a company that believes in and supports the open source community, embracing innovation and change is par for the course at Percona. We wouldn’t be the company we are today without fostering a culture …

Read More
 
Finding MySQL Table Size on Disk

So you want to know how much space a given MySQL table takes on disk. Looks trivial, right? Shouldn’t this information be readily available in the INFORMATION_SCHEMA.TABLES? Not so fast! This simple question actually is …

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.