Monthly Archives - January 2016

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

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 of […]

Read more

Percona XtraDB Cluster 5.6.28-25.14 is now available

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 is open-source and free, […]

Read more

Vote Percona Server in LinuxQuestions.org Members Choice Awards

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 […]

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 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)

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 be […]

Read more

Percona CEO Peter Zaitsev discusses working remotely with Fortune Magazine

remote worker

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 that rewards creative thinking and rapid evolution.
Part of this culture is making sure that Percona is a place where […]

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 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

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 […]

Read more

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

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!

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