EmergencyEMERGENCY? Get 24/7 Help Now!

Upcoming Webinar September 14, 2017: Supercharge Your Analytics with ClickHouse

 | September 12, 2017 |  Posted In: Database Monitoring, Insight for DBAs, Insight for Developers, MySQL, Technical Webinars, Yandex ClickHouse

ClickHouse

Join Percona’s CTO Vadim Tkachenko @VadimTk and Altinity’s Co-Founder, Alexander Zaitsev as they present Supercharge Your Analytics with ClickHouse on Thursday, September 14, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7). Reserve Your Spot   ClickHouse is a real-time analytical database system. Even though they’re only celebrating one year as open source software, it has […]

Read More

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 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

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, Percona Cloud Tools, Technical Webinars

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, Percona Cloud Tools, Percona Server for MySQL, Percona Software, Percona Toolkit, Percona XtraBackup, Percona XtraDB Cluster, Technical Webinars

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