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

Generated (Virtual) Columns in MySQL 5.7 (labs)

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

About 2 weeks ago Oracle published the MySQL 5.7.7-labs-json version which includes a very interesting feature called “Generated columns” (also know as Virtual or Computed columns). MariaDB has a similar feature as well: Virtual (Computed) Columns. The idea is very simple: if we store a column [crayon-5540c7fad1658080245342/] in our table we may want to filter or group […]

Generated (Virtual) Columns in MySQL 5.7 (labs)

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

About 2 weeks ago Oracle published the MySQL 5.7.7-labs-json version which includes a very interesting feature called “Generated columns” (also know as Virtual or Computed columns). MariaDB has a similar feature as well: Virtual (Computed) Columns. The idea is very simple: if we store a column [crayon-55426e54a9366708779943/] in our table we may want to filter or group […]

Test your knowledge: Percona XtraDB Cluster (PXC) quiz

MySQL Performance Blog - Tue, 28/04/2015 - 10:00am

I often talk with people who are very interested in the features of Percona XtraDB Cluster (PXC) such as synchronous and parallel replication, multi-node writing and high availability. However some get confused when operating a real PXC cluster because they do not fully realize the implications of these features. So here is a fun way […]

Test your knowledge: Percona XtraDB Cluster (PXC) quiz

MySQL Performance Blog - Tue, 28/04/2015 - 10:00am

I often talk with people who are very interested in the features of Percona XtraDB Cluster (PXC) such as synchronous and parallel replication, multi-node writing and high availability. However some get confused when operating a real PXC cluster because they do not fully realize the implications of these features. So here is a fun way […]

Indexing 101: Optimizing MySQL queries on a single table

MySQL Performance Blog - Mon, 27/04/2015 - 10:00am

I have recently seen several cases when performance for MySQL queries on a single table was terrible. The reason was simple: the wrong indexes were added and so the execution plan was poor. Here are guidelines to help you optimize various kinds of single-table queries. Disclaimer: I will be presenting general guidelines and I do […]

Indexing 101: Optimizing MySQL queries on a single table

MySQL Performance Blog - Mon, 27/04/2015 - 10:00am

I have recently seen several cases when performance for MySQL queries on a single table was terrible. The reason was simple: the wrong indexes were added and so the execution plan was poor. Here are guidelines to help you optimize various kinds of single-table queries. Disclaimer: I will be presenting general guidelines and I do […]

Percona Live & OpenStack Live 2015 wrap-up

MySQL Performance Blog - Fri, 24/04/2015 - 10:00am

With highlights that included news of Percona’s acquisition of Tokutek, a lively keynote discussion with Apple legend Steve “Woz” Wozniak, scores of technical sessions, tutorials and a festive MySQL community dinner and game night, last week’s Percona Live MySQL Conference and Expo had something for everyone. More than 1,200 attendees from around the world converged […]

Percona Live & OpenStack Live 2015 wrap-up

MySQL Performance Blog - Fri, 24/04/2015 - 10:00am

With highlights that included news of Percona’s acquisition of Tokutek, a lively keynote discussion with Apple legend Steve “Woz” Wozniak, scores of technical sessions, tutorials and a festive MySQL community dinner and game night, last week’s Percona Live MySQL Conference and Expo had something for everyone. More than 1,200 attendees from around the world converged […]

Considering Sharding with MySQL? Join my April 22 webinar. Questions welcome!

MySQL Performance Blog - Tue, 21/04/2015 - 4:08pm

MySQL sharding is one of the most used and surely the most abused MySQL scaling technology. My April 2 Dzone article, “To Shard, or Not to Shard,” proved there is indeed quite an interest in this topic. As such, I’m hosting a live webinar tomorrow (April 22) that shed light on questions about sharding with MySQL. […]

Considering Sharding with MySQL? Join my April 22 webinar. Questions welcome!

MySQL Performance Blog - Tue, 21/04/2015 - 4:08pm

MySQL sharding is one of the most used and surely the most abused MySQL scaling technology. My April 2 Dzone article, “To Shard, or Not to Shard,” proved there is indeed quite an interest in this topic. As such, I’m hosting a live webinar tomorrow (April 22) that will shed light on questions about sharding with […]

Profiling MySQL queries from Performance Schema

MySQL Performance Blog - Thu, 16/04/2015 - 5:49pm

When optimizing queries and investigating performance issues, MySQL comes with built in support for profiling queries aka [crayon-55426e54abbd7404146213-i/] . This is already awesome and simple to use, but why the PERFORMANCE_SCHEMA alternative? Because profiling will be removed soon (already deprecated on MySQL 5.6 ad 5.7); the built-in profiling capability can only be enabled per session. This […]

Profiling MySQL queries from Performance Schema

MySQL Performance Blog - Thu, 16/04/2015 - 5:49pm

When optimizing queries and investigating performance issues, MySQL comes with built in support for profiling queries aka [crayon-552ff8d1191ca913537292-i/] . This is already awesome and simple to use, but why the PERFORMANCE_SCHEMA alternative? Because profiling will be removed soon (already deprecated on MySQL 5.6 ad 5.7); the built-in profiling capability can only be enabled per session. This […]

Checking table definition consistency with mysqldiff

MySQL Performance Blog - Wed, 15/04/2015 - 8:45pm

Data inconsistencies in replication environments are a pretty common. There are lots of posts that explain how to fix those using pt-table-checksum and pt-table-sync. Usually we only care about the data but from time to time we receive this question in support: How can I check the table definition consistency between servers? Replication also allow […]

Checking table definition consistency with mysqldiff

MySQL Performance Blog - Wed, 15/04/2015 - 8:45pm

Data inconsistencies in replication environments are a pretty common. There are lots of posts that explain how to fix those using pt-table-checksum and pt-table-sync. Usually we only care about the data but from time to time we receive this question in support: How can I check the table definition consistency between servers? Replication also allow […]

Team Tokutek is proud to join Team Percona!

MySQL Performance Blog - Tue, 14/04/2015 - 6:18pm

If you haven’t already heard, on the Tuesday morning of the 2015 Percona Live MySQL Conference and Expo it was announced that Tokutek is now part of the Percona family.  This means TokuDB® for MySQL, and TokuMX™ for MongoDB are Percona products now; and that the Tokutek  team is now part of the Percona team. […]

The post Team Tokutek is proud to join Team Percona! appeared first on MySQL Performance Blog.

Team Tokutek is proud to join Team Percona!

MySQL Performance Blog - Tue, 14/04/2015 - 6:18pm

If you haven’t already heard, on the Tuesday morning of the 2015 Percona Live MySQL Conference and Expo it was announced that Tokutek is now part of the Percona family.  This means TokuDB® for MySQL, and TokuMX™ for MongoDB are Percona products now; and that the Tokutek  team is now part of the Percona team. […]

The post Team Tokutek is proud to join Team Percona! appeared first on MySQL Performance Blog.

Tokutek now part of the Percona family

MySQL Performance Blog - Tue, 14/04/2015 - 6:13pm

It is my pleasure to announce that Percona has acquired Tokutek and will take over development and support for TokuDB® and TokuMX™ as well as the revolutionary Fractal Tree® indexing technology that enables those products to deliver improved performance, reliability and compression for modern Big Data applications. At Percona we have been working with the […]

Tokutek now part of the Percona family

MySQL Performance Blog - Tue, 14/04/2015 - 6:13pm

It is my pleasure to announce that Percona has acquired Tokutek and will take over development and support for TokuDB® and TokuMX™ as well as the revolutionary Fractal Tree® indexing technology that enables those products to deliver improved performance, reliability and compression for modern Big Data applications. At Percona we have been working with the […]

Percona Toolkit 2.2.14 is now available

MySQL Performance Blog - Tue, 14/04/2015 - 4:33pm

Percona is pleased to announce the availability of Percona Toolkit 2.2.14.  Released April 14, 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 complex for DBAs to perform manually. Percona Toolkit, like all Percona software, is free and open source. This release is […]

Staying ahead of MySQL operational problems at Percona Live

MySQL Performance Blog - Mon, 13/04/2015 - 2:35pm

I’ve started my long journey from Florianópolis, Brazil, to Santa Clara, California and I type this words while waiting for a connection flight. Next Wednesday, Daniel Guzmán Burgos and I will be presenting in the Percona Live MySQL Conference and Expo (PLMCE). I’m so excited with the new MySQL 101 program that has been added […]

Measuring the impact of tcpdump on Very Busy Hosts

MySQL Performance Blog - Fri, 10/04/2015 - 2:19pm

A few years back Deva wrote about how to use tcpdump on very busy hosts. That post sparked my interest about exploring how to measure the impact of tcpdump on very busy hosts. In this post, I wanted to highlight how much of an impact there really is and what options you have to make the […]

The post Measuring the impact of tcpdump on Very Busy Hosts appeared first on MySQL Performance Blog.

InnoDB locks and deadlocks with or without index for different isolation level

MySQL Performance Blog - Thu, 09/04/2015 - 6:27pm

Recently, I was working on one of the issue related to locks and deadlocks with InnoDB tables and I found very interesting details about how InnoDB locks and deadlocks works with or without index for different Isolation levels. Here, I would like to describe a small test case about how SELECT ..FOR UPDATE (with and without limit) behave […]

pquery binaries with statically included client libs now available!

MySQL Performance Blog - Thu, 09/04/2015 - 6:00pm

After we released pquery to the community, and as we started logging bug reports with pquery testcases, it quickly became clear that pquery binaries with statically compiled-in client libraries would be of great convenience, both for ourselves and for the community. (If you haven’t heard about pquery yet, read the pquery introduction blog post, come and […]

More on OpenStack Live and our talks at OpenStack Summit Vancouver

MySQL Performance Blog - Wed, 08/04/2015 - 1:34pm

In April and May, Percona will hold and participate in two OpenStack events: OpenStack Live and the OpenStack Summit. Join our talks at these events in Santa Clara and Vancouver for new insights into the MySQL operations of the core of OpenStack as well as the latest information on MySQL guest instances. Next week (April […]

The cost of not properly managing your databases

MySQL Performance Blog - Mon, 06/04/2015 - 10:00am

Every day hundreds of millions of dollars are wasted by allowing improperly tuned or misconfigured systems, misunderstood infrastructure, and inefficient IT operations to live and thrive in data centers around the globe. There are both direct and indirect costs associated with allowing these unhealthy systems to continue to exist. Let’s look at some. The setup: […]

Pages

Subscribe to MySQL Performance Blog