You are here

MySQL Performance Blog

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

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

Percona Server 5.6.26-74.0 is now available

MySQL Performance Blog - Tue, 15/09/2015 - 3:25pm

Percona is glad to announce the release of Percona Server 5.6.26-74.0 on September 15, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.26, including all the bug ...

The post Percona Server 5.6.26-74.0 is now available appeared first on MySQL Performance Blog.

MongoDB and Percona TokuMX Security Guidelines

MySQL Performance Blog - Mon, 14/09/2015 - 7:31pm

Several reports we’re published in the news about how easy it is to access data stored in some NoSQL systems, including MongoDB. This is not surprising because security was rather relaxed in earlier versions of ...

The post MongoDB and Percona TokuMX Security Guidelines appeared first on MySQL Performance Blog.

Webinar: Writing Application Code for MySQL High Availability Followup Questions

MySQL Performance Blog - Mon, 14/09/2015 - 5:57pm

Thanks to all who attended my webinar last week on Writing Application Code for MySQL High Availability.  This blog is for me to address the extra questions I didn’t have time to answer on the stream. ...

The post Webinar: Writing Application Code for MySQL High Availability Followup Questions appeared first on MySQL Performance Blog.

Percona TokuMX 2.0.2 is now available

MySQL Performance Blog - Thu, 10/09/2015 - 8:29pm

Percona is glad to announce the release of Percona TokuMX 2.0.2 on September 10th 2015. Downloads are available here and from the Percona Software Repositories. Based on MongoDB 2.4.10 including all the bug fixes in ...

The post Percona TokuMX 2.0.2 is now available appeared first on MySQL Performance Blog.

Percona Live Keynote Speakers and Topics!

MySQL Performance Blog - Thu, 10/09/2015 - 6:57pm

The countdown for the annual Percona Live Data Performance Conference and Expo in Europe continues with today’s announcement of our keynote speakers! This three-day conference focuses on the latest trends, news and best practices in the MySQL, ...

The post Percona Live Keynote Speakers and Topics! appeared first on MySQL Performance Blog.

Percona Server audit log plugin best practices

MySQL Performance Blog - Thu, 10/09/2015 - 7:00am

Auditing your database means tracking access and changes to your data and db objects. The Audit Log Plugin has been shipped with Percona Server since 5.5.37/5.6.17, for a little over 12 months. Prior to the Audit Log ...

The post Percona Server audit log plugin best practices appeared first on MySQL Performance Blog.

Testing MySQL partitioning with pt-online-schema-change

MySQL Performance Blog - Wed, 09/09/2015 - 10:00am

There are cases where we need to implement MySQL partitioning, or at least test if it is an option to solve an issue. However, how are we able to test it when the table on our production ...

The post Testing MySQL partitioning with pt-online-schema-change appeared first on Percona Data Performance Blog.

super_read_only and GTID replication

MySQL Performance Blog - Tue, 08/09/2015 - 7:00am

Percona Server 5.6.21+ and MySQL 5.7.8+ offer the super_read_only option that was first implemented in WebscaleSQL. Unlike read_only, this option prevents all users from running writes (even those with the SUPER privilege). Sure enough, this ...

The post super_read_only and GTID replication appeared first on MySQL Performance Blog.

Facebook’s Simon Martin on semi-synchronous replication

MySQL Performance Blog - Fri, 04/09/2015 - 3:41pm

Facebook, with 1.49 billion monthly active users,  is one of the world’s top MySQL users. Simon Martin, a production engineer on Facebook’s MySQL Infrastructure team, has been working with MySQL for most of his career, ...

The post Facebook’s Simon Martin on semi-synchronous replication appeared first on MySQL Performance Blog.

Percona Toolkit and systemd

MySQL Performance Blog - Thu, 03/09/2015 - 3:18pm

After some recent work with systemd I’ve realized it’s power and I can come clean that I am a fan. I realize that there are multitudes of posts out there with arguments both for and against ...

The post Percona Toolkit and systemd appeared first on MySQL Performance Blog.

Percona Server 5.5.45-37.4 is now available

MySQL Performance Blog - Wed, 02/09/2015 - 2:36pm

Percona is glad to announce the release of Percona Server 5.5.45-37.4 on September 2, 2015. Based on MySQL 5.5.45, including all the bug fixes in it, Percona Server 5.5.45-37.4 is now the current stable release ...

The post Percona Server 5.5.45-37.4 is now available appeared first on MySQL Performance Blog.

Booking dot yeah! Booking.com’s Jean-François Gagné on Percona Live Amsterdam

MySQL Performance Blog - Tue, 01/09/2015 - 7:00am

Booking.com, one of the world’s leading e-commerce companies, helps travels book nearly 1 million rooms per night. Established in 1996, Booking.com B.V. guarantees the best prices for any type of property, from small, family-run bed ...

The post Booking dot yeah! Booking.com’s Jean-François Gagné on Percona Live Amsterdam appeared first on MySQL Performance Blog.

High-load clusters and desynchronized nodes on Percona XtraDB Cluster

MySQL Performance Blog - Mon, 31/08/2015 - 10:00am

There can be a lot of confusion and lack of planning in Percona XtraDB Clusters in regards to nodes becoming desynchronized for various reasons.  This can happen a few ways: An IST or SST joining ...

The post High-load clusters and desynchronized nodes on Percona XtraDB Cluster appeared first on MySQL Performance Blog.

Percona Toolkit 2.2.15 is now available

MySQL Performance Blog - Fri, 28/08/2015 - 5:30pm

Percona is pleased to announce the availability of Percona Toolkit 2.2.15.  Released August 28, 2015. Percona Toolkit is a collection of advanced command-line tools to perform a variety of MySQL server and system tasks that are too difficult or ...

The post Percona Toolkit 2.2.15 is now available appeared first on MySQL Performance Blog.

ObjectRocket’s David Murphy talks about MongoDB, Percona Live Amsterdam

MySQL Performance Blog - Wed, 26/08/2015 - 8:07pm

Say hello to David Murphy, lead DBA and MongoDB Master at ObjectRocket (a Rackspace company). David works on sharding, tool building, very large-scale issues and high-performance MongoDB architecture. Prior to ObjectRocket he was a MySQL/NoSQL ...

The post ObjectRocket’s David Murphy talks about MongoDB, Percona Live Amsterdam appeared first on MySQL Performance Blog.

Advanced Query Tuning in MySQL 5.6 and MySQL 5.7 Webinar: Q&A

MySQL Performance Blog - Mon, 24/08/2015 - 2:16pm

Thank you for attending my July 22 webinar titled “Advanced Query Tuning in MySQL 5.6 and 5.7” (my slides and a replay available here). As promised here is the list of questions and my answers ...

The post Advanced Query Tuning in MySQL 5.6 and MySQL 5.7 Webinar: Q&A appeared first on MySQL Performance Blog.

Find unused indexes on MongoDB and TokuMX

MySQL Performance Blog - Fri, 21/08/2015 - 3:33pm

Finding and removing unused indexes is a pretty common technique to improve overall performance of relational databases. Less indexes means faster insert and updates but also less disk space used. The usual way to do ...

The post Find unused indexes on MongoDB and TokuMX appeared first on MySQL Performance Blog.

Optimizing PXC Xtrabackup State Snapshot Transfer

MySQL Performance Blog - Thu, 20/08/2015 - 3:38pm

State Snapshot Transfer (SST) at a glance PXC uses a protocol called State Snapshot Transfer to provision a node joining an existing cluster with all the data it needs to synchronize.  This is analogous to ...

The post Optimizing PXC Xtrabackup State Snapshot Transfer appeared first on MySQL Performance Blog.

How much could you benefit from MySQL 5.6 parallel replication?

MySQL Performance Blog - Wed, 19/08/2015 - 10:00am

I have heard this question quite often: “At busy times, our replicas start lagging quite frequently. We are using N schemas, so which performance boost could we expect from MySQL 5.6 parallel replication?” Here is ...

The post How much could you benefit from MySQL 5.6 parallel replication? appeared first on MySQL Performance Blog.

Featured Talk: The Future of Replication is Today: New Features in Practice

MySQL Performance Blog - Tue, 18/08/2015 - 11:17pm

In the past years, both MySQL 5.6, MySQL 5.7 and MariaDB 10 have been successful implementing new features. For many DBAs, the “old way” of replicating data is comfortable so taking the action to implement ...

The post Featured Talk: The Future of Replication is Today: New Features in Practice appeared first on MySQL Performance Blog.

MySQL is crashing: a support engineer’s point of view

MySQL Performance Blog - Mon, 17/08/2015 - 11:38am

In MySQL QA Episode #12, “MySQL is Crashing, now what?,” Roel demonstrated how to collect crash-related information that will help Percona discover what the issue is that you are experiencing, and fix it. As a Support ...

The post MySQL is crashing: a support engineer’s point of view appeared first on MySQL Performance Blog.

The language of compression

MySQL Performance Blog - Thu, 13/08/2015 - 7:19pm

Storage. Everyone needs it. Whether your data is in MySQL, a NoSQL, or somewhere in the cloud, with ever-growing data volumes – along with the need for SSDs to cut latency and replication to provide ...

The post The language of compression appeared first on MySQL Performance Blog.

MySQL Quality Assurance: A Vision for the Future by Roel Van de Paar (Final Episode 13)

MySQL Performance Blog - Thu, 13/08/2015 - 5:13pm

Welcome to the final – but most important – episode in the MySQL QA Series. In it, I present my vision for all MySQL Quality Assurance – for all distributions – worldwide. Episode 13: A Better ...

The post MySQL Quality Assurance: A Vision for the Future by Roel Van de Paar (Final Episode 13) appeared first on MySQL Performance Blog.

Percona Live Amsterdam Discounted Pricing and Community Dinner!

MySQL Performance Blog - Wed, 12/08/2015 - 9:37pm

The countdown is on for the annual Percona Live Data Performance Conference and Expo in Europe! This year the conference will be taking place in the great city of Amsterdam September 21-23rd. This three day conference will ...

The post Percona Live Amsterdam Discounted Pricing and Community Dinner! appeared first on MySQL Performance Blog.

MySQL replication primer with pt-table-checksum and pt-table-sync

MySQL Performance Blog - Wed, 12/08/2015 - 7:00am

MySQL replication is a process that allows you to easily maintain multiple copies of MySQL data by having them copied automatically from a master to a slave database. It’s essential to make sure the slave ...

The post MySQL replication primer with pt-table-checksum and pt-table-sync appeared first on MySQL Performance Blog.

Pages

Subscribe to MySQL Performance Blog