EmergencyEMERGENCY? Get 24/7 Help Now!

EXPLAIN FORMAT=JSON knows everything about UNIONs: union_result and query_specifications

 | January 29, 2016 |  Posted In: EXPLAIN, EXPLAIN FORMAT=JSON is cool!, JSON, MySQL

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 optimizing complicated queries with UNION, it is easy to get lost in the regular EXPLAIN  output trying to identify which part […]

Read More

Percona XtraDB Cluster 5.6.28-25.14 is now available

 | January 29, 2016 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona XtraDB Cluster

How to calculate the correct size of Percona XtraDB Cluster's gcache

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 current release, based on the following: Percona Server 5.6.28-76.1 Galera Replicator 3.14 Codership wsrep API 25.13 All of Percona software […]

Read More

Vote Percona Server in LinuxQuestions.org Members Choice Awards

 | January 28, 2016 |  Posted In: Percona Server for MySQL

Percona Server

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 Server is a free, fully compatible, enhanced, open source drop-in replacement for MySQL® that provides superior performance, scalability and instrumentation. […]

Read More

Setup a MongoDB replica/sharding set in seconds

 | January 28, 2016 |  Posted In: MongoDB, MySQL

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 tool that we couldn’t live without in Support. In this post I am going to walk through the different ways we […]

Read More

MongoDB revs you up: What storage engine is right for you? (Part 4)

and  | January 27, 2016 |  Posted In: MongoDB, Solutions Engineering

MongoDB

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 underlying software that a DBMS uses to create, read, update and delete data from a database. The storage engine should […]

Read More

Finding MySQL Table Size on Disk

 | January 26, 2016 |  Posted In: MySQL

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 quite complicated in MySQL. MySQL supports many storage engines (some of which don’t store data on disk at all) and […]

Read More

EXPLAIN FORMAT=JSON has details for subqueries in HAVING, nested selects and subqueries that update values

 | January 25, 2016 |  Posted In: EXPLAIN, EXPLAIN FORMAT=JSON is cool!, JSON, MySQL

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 now finish this topic and discuss the output for the rest of the subquery types. First, let’s look at the subquery […]

Read More

Peter Zaitsev webinar January 27th: Compression In Open Source Databases

 | January 22, 2016 |  Posted In: Events and Announcements, MySQL

Database Compression

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. To deal with this trend database technologies have implemented a number of approaches, and data compression is by far the […]

Read More

Percona Live Data Performance Conference 2016: news you need to know!

 | January 22, 2016 |  Posted In: Events and Announcements, MariaDB, MongoDB, MySQL

Percona Live

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 diverse open source community and businesses that thrive in the MySQL and NoSQL marketplaces. Attendees include DBAs, sysadmins, developers, architects, […]

Read More