EmergencyEMERGENCY? Get 24/7 Help Now!

Checkpoint strikes back

 | August 3, 2015 |  Posted In: MongoDB, MySQL

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 it to a checkpoint activity. The funny thing is that I thought we solved checkpointing issues in InnoDB once and […]

Read More

InnoDB vs TokuDB in LinkBench benchmark

 | July 24, 2015 |  Posted In: Benchmarks, MySQL, Percona Server, 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

Using Cgroups to Limit MySQL and MongoDB memory usage

 | July 1, 2015 |  Posted In: InnoDB, MongoDB, MySQL

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

Read More

MySQL 5.6 Transportable Tablespaces best practices

 | December 9, 2014 |  Posted In: Insight for DBAs, MySQL, Percona XtraBackup

In MySQL 5.6 Oracle introduced a Transportable Tablespace feature (copying tablespaces to another server) and Percona Server adopted it for partial backups which means you can now take individual database or table backups and your destination server can be a vanilla MySQL server. Moreover, since Percona Server 5.6, innodb_import_table_from_xtrabackup is obsolete as Percona Server also […]

Read More

“How to monitor MySQL performance” with Percona Cloud Tools: June 25 webinar

 | June 18, 2014 |  Posted In: Insight for DBAs, MySQL, MySQL Webinars, Percona Cloud Tools

We recently released a new version of Percona Cloud Tools with MySQL monitoring capabilities. Join me June 25 and learn the details about all of the great new features inside Percona Cloud Tools – which is now free in beta. The webinar is titled “Monitoring All (Yes, All!) MySQL Metrics with Percona Cloud Tools” and begins at […]

Read More

Why did we develop percona-agent in Go?

 | June 4, 2014 |  Posted In: Insight for Developers, MySQL, MySQL Webinars, Percona Cloud Tools, Percona Server, Percona Software, Percona Toolkit, Percona XtraBackup, Percona XtraDB Cluster

We recently open-sourced our percona-agent and if you check out the source code, you’ll find that it is written in the Go programming language (aka Golang). For those not up to speed, the percona-agent is a real-time client-side agent for Percona Cloud Tools. Our requirements are quite demanding for our agents. This one is software that works […]

Read More

From zero to full visibility of MySQL in 3 minutes with Percona Cloud Tools

 | May 28, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Cloud Tools, Percona Software

First, I would like to invite you to my webinar, “Monitoring All (Yes, All!) MySQL Metrics with Percona Cloud Tools,” on Wednesday, June 25 at 10 a.m. Pacific Daylight Time, where I will talk on the new features in Percona Cloud Tools, including monitoring capabilities. In this post I’d like to show the cool and […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.