You are here

MySQL Performance Blog

MySQL Performance Blog
Checked: 2 hours 25 min ago
Updated: 2 hours 25 min ago
Update every: 2 hours


Subscribe to MySQL Performance Blog

Bypassing SST in Percona XtraDB Cluster with binary logs

MySQL Performance Blog - Thu, 16/07/2015 - 10:00am

In my previous post, I used incremental backups in Percona XtraBackup as a method for rebuilding a Percona XtraDB Cluster (PXC) node without triggering an actual SST. Practically this reproduces the SST steps, but it can be handy if you already had backups available to use. In this post, I want to present another methodology […]

Bypassing SST in Percona XtraDB Cluster with incremental backups

MySQL Performance Blog - Thu, 16/07/2015 - 9:00am

Beware the SST In Percona XtraDB Cluster (PXC) I often run across users who are fearful of SSTs on their clusters. I’ve always maintained that if you can’t cope with a SST, PXC may not be right for you, but that doesn’t change the fact that SSTs with multiple Terabytes of data can be quite […]

MySQL QA Episode 6: Analyzing and Filtering

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

Welcome to MySQL QA Episode #6! Today we will look into analyzing and filtering our QA run. We’ll use tools like pquery-prep-red.sh, pquery-clean-known.sh & pquery-results.sh 1. Quick re-cap and QA run setup 2. pquery-prep-red.sh 3. pquery-clean-known.sh 4. pquery-results.sh 5. Bonus: pquery reach – pquery-reach++.sh We’ll also introduce the text_string.sh tool which extracts a most-specific text string […]

MongoDB benchmark: sysbench-mongodb IO-bound workload comparison

MySQL Performance Blog - Tue, 14/07/2015 - 2:26pm

In this post I’ll share the results of a sysbench-mongodb benchmark I performed on my server. I compared MMAP, WiredTiger, RocksDB and TokuMXse (based on MongoDB 3.0) and TokuMX (based on MongoDB 2.4) in an IO-intensive workload. The full results are available here, and below I’ll just share the summary chart: I would like to […]

MySQL QA Episode 5: Preparing Your QA Run with pquery

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

Welcome to MySQL QA Episode #5! In this episode we’ll be setting up and running pquery for the first time… and I’ll also trigger some actual bugs (fun guaranteed)! I’ll also introduce you to mtr_to_sql.sh and pquery-run.sh. pquery-run.sh (the main wrapper around pquery) is capable of generating 80-120 MySQL Server crashes – per hour! See how […]

How to create a rock-solid MySQL database backup & recovery strategy

MySQL Performance Blog - Fri, 10/07/2015 - 3:05pm

Have you ever wondered what could happen if your MySQL database goes down? Although it’s evident such a crash will cause downtime – and surely some business impact in terms of revenue – can you do something to reduce this impact? The simple answer is “yes” by doing regular backups (of course) but are you […]

Percona Live Europe 2015 conference, tutorials schedule now available

MySQL Performance Blog - Thu, 09/07/2015 - 3:10pm

The conference and tutorial schedule for Percona Live Europe 2015, September 21-23 in Amsterdam, was published this morning and this year’s event will focus on MySQL, NoSQL and Data in the Cloud. Conference sessions, which will follow each morning’s keynote addresses, feature a variety of formal tracks and sessions. Topic areas include: high availability (HA), […]

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.

Pages

Subscribe to MySQL Performance Blog