In version MySQL 5.7.7 Oracle presented a new promising feature: optimizer hints. However it did not publish any documentation about the hints. The only note which I found in the user manual about the hints is: It is now possible to provide hints to the optimizer by including /*+ ... */ comments following the SELECT, [&]

The post Optimizer hints in MySQL 5.7.7  The missed manual appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/04/30/optimizer-hints-mysql-5-7-7-missed-manual/

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-55453caee732e787852943/] in our table we may want to filter or group [&]

The post Generated (Virtual) Columns in MySQL 5.7 (labs) appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/04/29/generated-virtual-columns-in-mysql-5-7-labs/

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

The post Test your knowledge: Percona XtraDB Cluster (PXC) quiz appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/04/28/test-your-knowledge-percona-xtradb-cluster-pxc-quiz/

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

The post Indexing 101: Optimizing MySQL queries on a single table appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/04/27/indexing-101-optimizing-mysql-queries-on-a-single-table/

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

The post Indexing 101: Optimizing MySQL queries on a single table appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/04/27/indexing-101-optimizing-mysql-queries-on-a-single-table/

With highlights that included news of Perconas 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 [&]

The post Percona Live & OpenStack Live 2015 wrap-up appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/04/24/percona-live-openstack-live-2015-wrap/

With highlights that included news of Perconas 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 [&]

The post Percona Live & OpenStack Live 2015 wrap-up appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/04/24/percona-live-openstack-live-2015-wrap/

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, Im hosting a live webinar tomorrow (April 22) that will shed light on questions about sharding with [&]

The post Considering Sharding with MySQL? Join my April 22 webinar. Questions welcome! appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/04/21/considering-sharding-with-mysql-join-my-april-22-webinar-questions-welcome/

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, Im hosting a live webinar tomorrow (April 22) that will shed light on questions about sharding with [&]

The post Considering Sharding with MySQL? Join my April 22 webinar. Questions welcome! appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/04/21/considering-sharding-with-mysql-join-my-april-22-webinar-questions-welcome/

When optimizing queries and investigating performance issues, MySQL comes with built in support for profiling queries aka [crayon-553ff71491111181756811-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 [&]

The post Profiling MySQL queries from Performance Schema appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/04/16/profiling-mysql-queries-from-performance-schema/

When optimizing queries and investigating performance issues, MySQL comes with built in support for profiling queries aka [crayon-5533c2e77e4f1864498774-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 [&]

The post Profiling MySQL queries from Performance Schema appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/04/16/profiling-mysql-queries-from-performance-schema/

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

The post Checking table definition consistency with mysqldiff appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/04/15/checking-table-definition-consistency-mysqldiff/

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

The post Checking table definition consistency with mysqldiff appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/04/15/checking-table-definition-consistency-mysqldiff/

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.

https://www.percona.com/blog/2015/04/14/team-tokutek-is-proud-to-join-team-percona/

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.

http://www.percona.com/blog/2015/04/14/team-tokutek-is-proud-to-join-team-percona/

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

The post Tokutek now part of the Percona family appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/04/14/tokutek-now-part-of-the-percona-family/

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

The post Tokutek now part of the Percona family appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/04/14/tokutek-now-part-of-the-percona-family/

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

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

https://www.percona.com/blog/2015/04/14/percona-toolkit-2-2-14-is-now-available/

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

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

http://www.percona.com/blog/2015/04/14/percona-toolkit-2-2-14-is-now-available/

Ive started my long journey from Florian'opolis, Brazil, to Santa Clara, California and I type this words while waiting for a connection flight. Next Wednesday, Daniel Guzm'an Burgos and I will be presenting in the Percona Live MySQL Conference and Expo (PLMCE). Im so excited with the new MySQL 101 program that has been added [&]

The post Staying ahead of MySQL operational problems at Percona Live appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/04/13/staying-ahead-of-mysql-operational-problems-at-percona-live/