Buy Percona ServicesBuy Now!

Webinar Thurs 16/8: Developing an App on MongoDB: Tips and Tricks

 | August 15, 2018 |  Posted In: Events and Announcements, Insight for DBAs, Insight for Developers, MongoDB, Percona Server for MongoDB, Technical Webinars

Please join Percona’s Sr. Technical Operations Architect Tim Vaillancourt as he presents Developing an App on MongoDB: Tips and Tricks on Thursday, August 16th, 2018, at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). Register Now A lot of developers prefer using MongoDB to other open source databases when developing applications. But why? How do […]

Read More

Open Source Database Community Blog: The Story So Far

 | August 14, 2018 |  Posted In: Events and Announcements, Insight for DBAs, Insight for Developers, MariaDB, MongoDB, MySQL, open source databases

open source database community blog

Recently, we initiated a new project, the Open Source Database Community Blog. One way to think of this is as an online, year round version of the Percona Live conferences. If you have a story to tell, an experience to share, or a lesson to be learned send it along. As long as it’s related […]

Read More

Tuning Autovacuum in PostgreSQL and Autovacuum Internals

and  | August 10, 2018 |  Posted In: Insight for DBAs, Performance Tuning, PostgreSQL

Tuning Autovacuum in PostgreSQL

The performance of a PostgreSQL database can be compromised by dead tuples, since they continue to occupy space and can lead to bloat. We provided an introduction to VACUUM and bloat in an earlier blog post. Now, though, it’s time to look at autovacuum for postgres, and the internals you to know to maintain a […]

Read More

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

Basic Understanding of Bloat and VACUUM in PostgreSQL

 | August 6, 2018 |  Posted In: Insight for DBAs, PostgreSQL

VACUUM and Bloat PostgreSQL

Implementation of MVCC (Multi-Version Concurrency Control) in PostgreSQL is different and special when compared with other RDBMS. MVCC in PostgreSQL controls which tuples can be visible to transactions via versioning. What is versioning in PostgreSQL? Let’s consider the case of an Oracle or a MySQL Database. What happens when you perform a DELETE or an […]

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

Upcoming Webinar Tuesday, 7/31: Using MySQL for Distributed Database Architectures

 | July 30, 2018 |  Posted In: Insight for DBAs, MySQL, Performance Tuning, Technical Webinars

Distributed Database Architectures

Please join Percona’s CEO, Peter Zaitsev as he presents Using MySQL for Distributed Database Architectures on Tuesday, July 31st, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now   In modern data architectures, we’re increasingly moving from single-node design systems to distributed architectures using multiple nodes – often spread across multiple […]

Read More

Tuning InnoDB Primary Keys

 | July 26, 2018 |  Posted In: InnoDB, Insight for DBAs, MySQL

The choice of good InnoDB primary keys is a critical performance tuning decision. This post will guide you through the steps of choosing the best primary key depending on your workload. As a principal architect at Percona, one of my main duties is to tune customer databases. There are many aspects related to performance tuning […]

Read More