Buy Percona ServicesBuy Now!

Resource Usage Improvements in Percona Monitoring and Management 1.13

 | August 7, 2018 |  Posted In: Benchmarks, Insight for DBAs, MongoDB, MySQL, Percona Monitoring and Management, PMM

PMM 1-13 reduction CPU usage by 5x

In Percona Monitoring and Management (PMM) 1.13 we have adopted Prometheus 2, and with this comes a dramatic improvement in resource usage, along with performance improvements! What does it mean for you? This means you can have a significantly larger number of servers and database instances monitored by the same PMM installation. Or you can […]

Read More

Saving With MyRocks in The Cloud

 | August 1, 2018 |  Posted In: Benchmarks, InnoDB, Insight for DBAs, MyRocks, MySQL, open source databases

The main focus of a previous blog post was the performance of MyRocks when using fast SSD devices. However, I figured that MyRocks would be beneficial for use in cloud workloads, where storage is either slow or expensive. In that earlier post, we demonstrated the benefits of MyRocks, especially for heavy IO workloads. Meanwhile, Mark wrote in […]

Read More

Why Consumer SSD Reviews are Useless for Database Performance Use Case

 | July 18, 2018 |  Posted In: Benchmarks, Insight for DBAs, MySQL, open source databases, Percona Server for MySQL

Anandtech Table reviewing consumer SSD performance

If you’re reading consumer SSD reviews and using them to estimate SSD performance under database workloads, you’d better stop. Databases are not your typical consumer applications and they do not use IO in the same way. Let’s look, for example, at this excellent AnandTech review of Samsung 960 Pro –  a consumer NVMe device that […]

Read More

Why MySQL Stored Procedures, Functions and Triggers Are Bad For Performance

 | July 12, 2018 |  Posted In: Benchmarks, MySQL, MySQL 8.0

Execution map for func1()

MySQL stored procedures, functions and triggers are tempting constructs for application developers. However, as I discovered, there can be an impact on database performance when using MySQL stored routines. Not being entirely sure of what I was seeing during a customer visit, I set out to create some simple tests to measure the impact of […]

Read More

AMD EPYC Performance Testing… or Don’t get on the wrong side of SystemD

 | July 11, 2018 |  Posted In: Benchmarks, MySQL, Percona Server for MySQL

Ubuntu 16 AMD EPYC

Ever since AMD released their EPYC CPU for servers I wanted to test it, but I did not have the opportunity until recently, when started offering bare metal servers for a reasonable price. So I started a couple of instances to test Percona Server for MySQL under this CPU. In this benchmark, I discovered some […]

Read More

Scaling PostgreSQL with PgBouncer: You May Need a Connection Pooler Sooner Than You Expect

 | June 27, 2018 |  Posted In: Benchmarks, PostgreSQL

PostgreSQL connection pools

As PostgreSQL based applications scale, the need to implement connection pooling can become apparent sooner than you might expect. Since, PostgreSQL to date has no built-in connection pool handler, in this post I’ll explore some of the options for implementing connection pooling. In doing so, we’ll take a look at some of the implications for application […]

Read More