EmergencyEMERGENCY? Get 24/7 Help Now!

Booking.com’s Jean-François Gagné on Percona Live Amsterdam

 | September 1, 2015 |  Posted In: MySQL, Percona Live

Booking.com, one of the world’s leading e-commerce companies, helps travels book nearly 1 million rooms per night. Established in 1996, Booking.com B.V. guarantees the best prices for any type of property, from small, family-run bed and breakfasts to executive apartments and five-star luxury suites. The travel website is also a dedicated contributor to the MySQL […]

Read More

The MySQL query cache: Worst enemy or best friend?

 | August 7, 2015 |  Posted In: Benchmarks, MySQL

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 thing in common: the MySQL query cache was very useful. That was counter-intuitive for me as I’ve always expected the […]

Read More

PXC – Incremental State transfers in detail

 | August 5, 2015 |  Posted In: MySQL, Percona XtraDB Cluster

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 Galera GTID to the cluster The Donor node selected contains all the transactions the Joiner needs to catch up to […]

Read More

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

 | July 30, 2015 |  Posted In: MySQL, MySQL 101

Lately I saw many cases when users specified option --base64-output=DECODE-ROWS  to print out a statement representation of row events in MySQL binary logs just to get nothing. Reason for this is obvious: option --base64-output=DECODE-ROWS  does not convert row events into its string representation, this is job of option --verbose . But why users mix these […]

Read More

InnoDB vs TokuDB in LinkBench benchmark

 | July 24, 2015 |  Posted In: Benchmarks, MySQL, Percona Server for MySQL, TokuDB

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

Read More

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

 | July 23, 2015 |  Posted In: Hardware and Storage, Insight for DBAs, MySQL, Technical Webinars

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

Read More