You are here

MySQL Performance Blog

MySQL Performance Blog
Checked: 3 years 9 months ago
Updated: 3 years 9 months ago
Update every: 2 hours

Percona's Data performance and scalability blog
Subscribe to MySQL Performance Blog

EXPLAIN FORMAT=JSON: buffer_result is not hidden!

MySQL Performance Blog - Tue, 09/02/2016 - 8:41pm
EXPLAIN FORMAT=JSONTime for another entry in the EXPLAIN FORMAT=JSON is cool! series. Today we’re going to look at how you can view the buffer result using JSON (instead of the regular [crayon-56ba616badac0718620095-i/] command. Regular [crayon-56ba616badad3413045400-i/] does not identify ...

Percona Server 5.7.10-2 second RC available

MySQL Performance Blog - Mon, 08/02/2016 - 5:37pm
percona_serverPercona is glad to announce the second release candidate of Percona Server 5.7.10-2 on February 8, 2016.

Percona XtraBackup 2.4.0-rc1 is now available

MySQL Performance Blog - Mon, 08/02/2016 - 5:35pm
Percona_XtraBackupPercona is glad to announce the first release candidate of Percona XtraBackup 2.4.0-rc1 on February 8th 2016.

MySQL 5.7: Introduction for Operational DBAs

MySQL Performance Blog - Mon, 08/02/2016 - 3:18pm
mysql 5.7Join us Tuesday, February 16, 2016 9:00am PST (UTC-8) for a webinar on the op

Measuring Percona Server Docker CPU/network overhead

MySQL Performance Blog - Fri, 05/02/2016 - 6:55pm
DockerNow that we have our Percona Server Docker images, I wanted to measure the performance o

MySQL password expiration features to help you comply with PCI-DSS

MySQL Performance Blog - Thu, 04/02/2016 - 3:12pm
PCI Compliance (section 8.2.4) requires users to change password every 90 days. Until MySQL 5.6.6 there wasn’t a built-in way to comply with this requirement. Since MySQL version 5.6.6 there’s a password_expired feature which allows ...

New GIS Features in MySQL 5.7

MySQL Performance Blog - Wed, 03/02/2016 - 3:25pm
MySQL 5.7 has been released, and there are some exciting new features now available that I’m going to discuss in this blog — specifically around geographic information system (GIS). I’ve used GIS features in MySQL ...

Percona Live Crash Courses: for MySQL and MongoDB!

MySQL Performance Blog - Tue, 02/02/2016 - 7:45pm
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. ...

Experimental Percona Docker images for Percona Server

MySQL Performance Blog - Tue, 02/02/2016 - 5:02pm
DockerDocker is incredibly popular tool for deploying software, so we decided to provide a Per

InnoDB and TokuDB on AWS

MySQL Performance Blog - Mon, 01/02/2016 - 4:38pm
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, ...

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

MySQL Performance Blog - Fri, 29/01/2016 - 7:09pm

Percona XtraDB Cluster 5.6.28-25.14 is now available

MySQL Performance Blog - Fri, 29/01/2016 - 1:34pm
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 ...

Vote Percona Server in LinuxQuestions.org Members Choice Awards

MySQL Performance Blog - Thu, 28/01/2016 - 9:13pm

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

MySQL Performance Blog - Wed, 27/01/2016 - 8:13pm
MongoDBDifferentiating 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 ...

Finding MySQL Table Size on Disk

MySQL Performance Blog - Tue, 26/01/2016 - 10:16pm

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

MySQL Performance Blog - Mon, 25/01/2016 - 10:18pm
Over several previous blog posts, we’ve already discussed what information the [crayon-56a6c514b16e5256663610-i/] 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 ...

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

MySQL Performance Blog - Fri, 22/01/2016 - 5:08pm

Tired of MySQL Making You Wait? Webinar: Questions and Answers

MySQL Performance Blog - Thu, 21/01/2016 - 3:33pm
We’d like to thank everybody for joining us on January 7th for our “Tired of MySQL Making You Wait?” webinar with Pecona’s Alexander Rubin, Principal Consultant and SolarWinds’ Janis Griffin, Database Evangelist. Too often developers ...

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

MySQL Performance Blog - Wed, 20/01/2016 - 2:22pm
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 ...

Making Apache Spark Four Times Faster

MySQL Performance Blog - Fri, 15/01/2016 - 10:52pm
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 ...

OpenSSH CVE-2016-0777: Details and Mitigation

MySQL Performance Blog - Thu, 14/01/2016 - 8:04pm
OpenSSHEarlier today advisories were sent out regarding OpenSSH versions 5.4 through 7

Pages

Subscribe to MySQL Performance Blog