You are here

MySQL Performance Blog

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

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

Percona Server 5.6.25-73.1 is now available

MySQL Performance Blog - Thu, 09/07/2015 - 11:48am

Percona is glad to announce the release of Percona Server 5.6.25-73.1 on July 9, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.25, including all the bug fixes in it, Percona Server 5.6.25-73.1 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source […]

How to obtain the MySQL version from an FRM file

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

I recently helped a customer figure out why a minor version MySQL upgrade was indicating that some tables needed to be rebuilt. The mysql_upgrade program should be run for every upgrade, no matter how big or small the version difference is, but when only the minor version changes, I would normally not expect it to […]

The post How to obtain the MySQL version from an FRM file appeared first on MySQL Performance Blog.

MySQL QA Episode 4: QA Framework Setup Time!

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

Welcome to MySQL QA Episode 4! In this episode we’ll look into setting up our QA Framework: percona-qa, pquery, reducer & more. 1. All about percona-qa 2. pquery [crayon-559cf4de960fc257936849/] 3. reducer.sh [crayon-559cf4de96113520388260/] 4. Short introduction to pquery framework tools The tools introduced in this episode will be covered further in next two episodes. Full-screen viewing @ […]

MySQL QA Episode 3: How to use the debugging tool GDB

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

Welcome to MySQL QA Episode 3: “Debugging: GDB, Backtraces, Frames and Library Dependencies” In this episode you’ll learn how to use debugging tool GDB. The following debugging topics are covered:   1. GDB Introduction 2. Backtrace, Stack trace 3. Frames 4. Commands & Logging 5. Variables 6. Library dependencies 7. c++filt 8. Handy references – GDB […]

TOI wsrep_RSU_method in PXC 5.6.24 and up

MySQL Performance Blog - Mon, 06/07/2015 - 3:28pm

I noticed that in the latest release of Percona XtraDB Cluster (PXC), the behavior of wsrep_RSU_method changed somewhat.  Prior to this release, the variable was GLOBAL only, meaning to use it you would: [crayon-559aa659cb497558858880/] This had the (possibly negative) side-effect that ALL DDL’s issued on this node would be affected by the setting while in […]

Percona Server 5.5.44-37.3 is now available

MySQL Performance Blog - Wed, 01/07/2015 - 1:43pm

Percona is glad to announce the release of Percona Server 5.5.44-37.3 on July 1, 2015. Based on MySQL 5.5.44, including all the bug fixes in it, Percona Server 5.5.44-37.3 is now the current stable release in the 5.5 series. Percona Server is open-source and free. Details of the release can be found in the 5.5.44-37.3 […]

Percona Server 5.6.25-73.0 is now available

MySQL Performance Blog - Wed, 01/07/2015 - 1:24pm

Percona is glad to announce the release of Percona Server 5.6.25-73.0 on July 1, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.25, including all the bug fixes in it, Percona Server 5.6.25-73.0 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source […]

Using Cgroups to Limit MySQL and MongoDB memory usage

MySQL Performance Blog - Wed, 01/07/2015 - 12:00pm

Quite often, especially for benchmarks, I am trying to limit available memory for a database server (usually for MySQL, but recently for MongoDB also). This is usually needed to test database performance in scenarios with different memory limits. I have physical servers with the usually high amount of memory (128GB or more), but I am […]

Playing with Percona XtraDB Cluster in Docker

MySQL Performance Blog - Tue, 30/06/2015 - 7:00am

Like any good, thus lazy, engineer I don’t like to start things manually. Creating directories, configuration files, specify paths, ports via command line is too boring. I wrote already how I survive in case when I need to start MySQL server (here). There is also the MySQL Sandbox which can be used for the same […]

Practical MySQL Performance Optimization (July 2 webinar)

MySQL Performance Blog - Mon, 29/06/2015 - 2:24pm

Applications often become impacted by MySQL performance. Optimization is the obvious solution but where to start? Join me on July 2 at 11 a.m. Pacific and I’ll show you how to optimize MySQL in a practical way – spending time on what gives you the best return. Many of you have heard me talk on […]

Tips for avoiding malware from a lesson learned

MySQL Performance Blog - Fri, 26/06/2015 - 4:28pm

In a recent article on the Percona blog, I recommended readers to a tool called CamStudio for making technical screen recordings. The blog post was very popular and got 300+ Facebook likes in a short time. Providentially though, a reader commented that the installer (as downloaded from the project website) installed “pretty annoying adware on […]

Oracle license revenue and the MySQL ecosystem

MySQL Performance Blog - Thu, 25/06/2015 - 9:30pm

Oracle was in the news recently with the story of its license revenue declining as much as 17% in the recent quarter. This is blamed on transitioning to the cloud in some publications, but others, such as Bloomberg and TechRepublic, look deeper, seeing open source software responsible for the bulk of it. Things are especially […]

Percona XtraDB Cluster (PXC): How many nodes do you need?

MySQL Performance Blog - Tue, 23/06/2015 - 3:12pm

A question I often hear when customers want to set up a production PXC cluster is: “How many nodes should we use?” Three nodes is the most common deployment, but when are more nodes needed? They also ask: “Do we always need to use an even number of nodes?” This is what we’ll clarify in […]

Percona Monitoring Plugins 1.1.5 release

MySQL Performance Blog - Mon, 22/06/2015 - 7:00am

Percona is glad to announce the release of Percona Monitoring Plugins 1.1.5. Changelog: Added more DB instance classes to pmp-check-aws-rds.py (issue 1398911) Added configurable query period and average time to pmp-check-aws-rds.py (issue 1436943) Added region support to pmp-check-aws-rds.py (issue 1442980) Added an option to alert when server is not configured as replica to pmp-check-mysql-replication-delay (issue […]

Q&A: High availability when using MySQL in the cloud

MySQL Performance Blog - Fri, 19/06/2015 - 1:00pm

Last week I hosted a webinar on using MySQL in the cloud for High Availability (HA) alongside 451 Research analyst Jason Stamper. You can watch the recording and also download the slides (free) here. Just click the “Register” button at the end of that page. We had several excellent questions and we didn’t have time […]

Getting EXPLAIN information from already running queries in MySQL 5.7

MySQL Performance Blog - Thu, 18/06/2015 - 7:00am

When a new version of MySQL is about to be released we read a lot of blog posts about the performance and scalability improvements. That’s good but sometimes we miss some small features that can help us a lot in our day-to-day tasks. One good example is the blog post that Aurimas wrote about a […]

Update on the InnoDB double-write buffer and EXT4 transactions

MySQL Performance Blog - Wed, 17/06/2015 - 2:15pm

In a post, written a few months ago, I found that using EXT4 transactions with the “data=journal” mount option, improves the write performance significantly, by 55%, without putting data at risk. Many people commented on the post mentioning they were not able to reproduce the results and thus, I decided to further investigate in order […]

Speed up GROUP BY queries with subselects in MySQL

MySQL Performance Blog - Mon, 15/06/2015 - 6:32pm

We usually try to avoid subselects because sometimes they force the use of a temporary table and limits the use of indexes. But, when is good to use a subselect? This example was tested over table a (1310723 rows), b, c and d ( 5 rows each) and with MySQL version 5.5 and 5.6. Let’s […]

The post Speed up GROUP BY queries with subselects in MySQL appeared first on MySQL Performance Blog.

Percona XtraDB Cluster: Quorum and Availability of the cluster

MySQL Performance Blog - Fri, 12/06/2015 - 1:44pm

Percona XtraDB Cluster (PXC) has become a popular option to provide high availability for MySQL servers. However many people are still having a hard time understanding what will happen to the cluster when one or several nodes leave the cluster (gracefully or ungracefully). This is what we will clarify in this post. Nodes leaving gracefully […]

Percona Live Europe 2015! Call for speakers; registration now open

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

Percona Live is moving from London to Amsterdam this year and the event is also expanding to three full days. Percona Live Europe 2015, September 21-23, will be at the Mövenpick Hotel Amsterdam City Centre. The call for speakers and Super Saver registration are now open. Hurry though because the deadline for submitting a speaking proposal […]

Auditing MySQL with McAfee and MongoDB

MySQL Performance Blog - Tue, 09/06/2015 - 1:00pm

Greetings everyone! Let’s discuss a 3rd Party auditing solution to MySQL and how we can leverage MongoDB to make sense out of all of that data. The McAfee MySQL Audit plugin does a great job of capturing, at low level, activities within a MySQL server. It does this through some non-standard APIs which is why installing […]

MaxScale: A new tool to solve your MySQL scalability problems

MySQL Performance Blog - Mon, 08/06/2015 - 1:00pm

Ever since MySQL replication has existed, people have dreamed of a good solution to automatically split read from write operations, sending the writes to the MySQL master and load balancing the reads over a set of MySQL slaves. While if at first it seems easy to solve, the reality is far more complex. First, the […]

High availability using MySQL in the cloud

MySQL Performance Blog - Thu, 04/06/2015 - 7:00am

Next Wednesday (June 10) I’ll be co-presenting a webinar on using MySQL in the cloud for High Availability (HA). Joining me will be 451 Research analyst Jason Stamper and together we’ll talk about the realities of HA using MySQL in the cloud and how vendors are responding to changing application requirements with new developments that […]

Percona XtraDB Cluster 5.6.24-25.11 is now available

MySQL Performance Blog - Wed, 03/06/2015 - 8:19pm

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on June 3rd 2015. Binaries are available from downloads area or from our software repositories. Based on Percona Server 5.6.24-72.2 including all the bug fixes in it, Galera Replicator 3.11, and on Codership wsrep API 25.11, Percona XtraDB Cluster 5.6.24-25.11 is now […]

Optimizing Percona XtraDB Cluster for write hotspots

MySQL Performance Blog - Wed, 03/06/2015 - 1:50pm

Some applications have a heavy write workload on a few records – for instance when incrementing a global counter: this is called a write hotspot. Because you cannot update the same row simultaneously from multiple threads, this can lead to performance degradation. When using Percona XtraDB Cluster (PXC), some users try to solve this specific […]

Pages

Subscribe to MySQL Performance Blog