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

MySQL QA Episode 12: My server is crashing… Now what? For customers or users experiencing a crash

MySQL Performance Blog - Tue, 11/08/2015 - 10:00am

My server is crashing… Now what? This special episode in the MySQL QA Series is for customers or users experiencing a crash. A crash? Cheat sheet: https://goo.gl/rrmB9i Sever install & crash. Note this is as a demonstration: do ...

The MySQL query cache: Worst enemy or best friend?

MySQL Performance Blog - Fri, 07/08/2015 - 10:00am

During the last couple of months I have been involved in an unusually high amount of performance audits for e-commerce applications running with Magento. And although the systems were quite different, they also had one ...

The post The MySQL query cache: Worst enemy or best friend? appeared first on MySQL Performance Blog.

PXC – Incremental State transfers in detail

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

IST Basics State transfers in Galera remain a mystery to most people.  Incremental State transfers (as opposed to full State Snapshot transfers) are used under the following conditions: The Joiner node reports Galera a valid ...

The post PXC – Incremental State transfers in detail appeared first on MySQL Performance Blog.

MySQL QA Episode 11: Valgrind Testing: Pro’s, Con’s, Why and How

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

Today’s episode is all about Valgrind – from the pro’s to the con’s, from the why to the how! This episode will be of interest to anyone who is or wants to work with Valgrind on ...

The post MySQL QA Episode 11: Valgrind Testing: Pro’s, Con’s, Why and How appeared first on MySQL Performance Blog.

Percona XtraBackup 2.2.12 is now available

MySQL Performance Blog - Mon, 03/08/2015 - 12:31pm

Percona is glad to announce the release of Percona XtraBackup 2.2.12 on August 3, 2015. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, ...

The post Percona XtraBackup 2.2.12 is now available appeared first on MySQL Performance Blog.

InnoDB checkpoint strikes back

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

In my recent benchmarks for MongoDB, we can see that the two engines WiredTiger and TokuMX struggle from periodical drops in throughput, which is clearly related to a checkpoint interval – and therefore I correspond ...

The post InnoDB checkpoint strikes back appeared first on MySQL Performance Blog.

MySQL QA Episode 10: Reproducing and Simplifying: How to get it Right

MySQL Performance Blog - Fri, 31/07/2015 - 10:00am

Welcome to the 10th episode in the MySQL QA series! Today we’ll talk about reproducing and simplifying: How to get it Right. Note that unless you are a QA engineer stuck on a remote, and additionally difficult-to-reproduce or difficult-to-reduce bug, this episode will largely be non-interesting for you. However, what you may like to see […]

Why base64-output=DECODE-ROWS does not print row events in MySQL binary logs

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

Lately I saw many cases when users specified option [crayon-55b9f5d1a40f1439677978-i/]  to print out a statement representation of row events in MySQL binary logs just to get nothing. Reason for this is obvious: option [crayon-55b9f5d1a4108596981142-i/]  does not convert row events into its string representation, this is job of option [crayon-55b9f5d1a4110690456505-i/] . But why users mix these […]

Multi-source replication in MySQL 5.7 vs Tungsten Replicator

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

MySQL 5.7 comes with a new set of features and multi-source replication is one of them. In few words this means that one slave can replicate from different masters simultaneously. During the last couple of months I’ve been playing a lot with this trying to analyze its potential in a real case that I’ve been […]

MySQL QA Episode 9: Reducing Testcases for Experts: multi-threaded reducer.sh

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

Welcome to MySQL QA Episode 9. This episode will go more in-depth into reducer.sh: Reducing Testcases for Experts: multi-threaded reducer.sh We will explore how to use reducer.sh to do true multi-threaded testcase reduction – a world’s first. Topics: Expert configurable variables & their default reducer.sh settings PQUERY_MULTI PQUERY_MULTI_THREADS PQUERY_MULTI_CLIENT_THREADS PQUERY_MULTI_QUERIES PQUERY_REVERSE_NOSHUFFLE_OPT Full-screen viewing @ 720p resolution […]

InnoDB vs TokuDB in LinkBench benchmark

MySQL Performance Blog - Fri, 24/07/2015 - 2:12pm

Previously I tested Tokutek’s Fractal Trees (TokuMX & TokuMXse) as MongoDB storage engines – today let’s look into the MySQL area. I am going to use modified LinkBench in a heavy IO-load. I compared InnoDB without compression, InnoDB with 8k compression, TokuDB with quicklz compression. Uncompressed datasize is 115GiB, and cachesize is 12GiB for InnoDB […]

The Q&A: Creating best-in-class backup solutions for your MySQL environment

MySQL Performance Blog - Thu, 23/07/2015 - 1:55pm

Thank you for attending my July 15 webinar, “Creating Best in Class Backup solutions for your MySQL environment.” Due to the amount of content we discussed and some minor technical difficulties faced near the end of webinar we have decided to cover the final two slides of the presentation along with the questions asked by […]

MySQL QA Episode 8: Reducing Testcases for Engineers: tuning reducer.sh

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

Welcome to MySQL QA Episode 8: Reducing Testcases for Engineers: tuning reducer.sh Advanced configurable variables & their default/vanilla reducer.sh settings FORCE_SKIPV FORCE_SPORADIC TIMEOUT_COMMAND & TIMEOUT_CHECK MULTI_THREADS MULTI_THREADS_INCREASE QUERYTIMEOUT STAGE1_LINES SKIPSTAGE FORCE_KILL Some examples FORCE_SKIPV/FORCE_SPORADIC TIMEOUT_COMMAND/TIMEOUT_CHECK Full-screen viewing @ 720p resolution recommended.

SELinux and the MySQL init script

MySQL Performance Blog - Wed, 22/07/2015 - 5:09pm

I recently worked with a customer who had a weird issue: when their MySQL server was started (Percona Server 5.5), if they try to run service mysql start a second time, the init script was not able to detect that an instance was already running. As a result, it tried to start a second instance […]

The post SELinux and the MySQL init script appeared first on MySQL Performance Blog.

Percona now offering 24/7 support for MongoDB and TokuMX

MySQL Performance Blog - Tue, 21/07/2015 - 7:22pm

Today Percona announced the immediate availability of 24/7, enterprise-class support for MongoDB and TokuMX. The new support service helps organizations achieve maximum application performance without database bloat. Customers have round-the-clock access (365 days a year) to the most trusted team of database experts in the open source community. The news means that Percona now offers […]

MySQL QA Episode 7: Reducing Testcases for Beginners – single-threaded reducer.sh!

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

Welcome to MySQL QA Episode #7 – Reducing Testcases for Beginners: single-threaded reducer.sh! In this episode we’ll learn how to use reducer.sh. Topics discussed; reducer.sh introduction/concepts Basic configurable variables & their default reducer.sh settings INPUTFILE options MODE=x TEXT=”text” WORKDIR_LOCATION & WORKDIR_M3_DIRECTORY MYEXTRA MYBASE PQUERY_MOD & PQUERY_LOC MODE5_COUNTTEXT, MODE5_ADDITIONAL_TEXT & MODE5_ADDITIONAL_COUNTTEXT How to learn more about each […]

Percona Live Amsterdam discounted pricing ends July 26!

MySQL Performance Blog - Mon, 20/07/2015 - 9:32pm

The Percona Live Data Performance Conference in Amsterdam is just two months away and it’s going to be an incredible event. With a new expanded focus on MySQL, NoSQL, and Data in the Cloud, this conference will be jam-packed with talks from some of the industry’s leading experts from MongoDB, VMware, Oracle, MariaDB, Facebook, Booking.com, […]

Fractal Tree library as a Key-Value store

MySQL Performance Blog - Mon, 20/07/2015 - 1:50pm

As you may know, Tokutek is now part of Percona and I would like to explain some internals of TokuDB and TokuMX – what performance benefits they bring, along with further optimizations we are working on. However, before going into deep details, I feel it is needed to explain the fundamentals of Key-Value store, and […]

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), […]

Pages

Subscribe to MySQL Performance Blog