by David Quilty | Apr 18, 2024 | Insight for DBAs, MongoDB, MySQL, PostgreSQL
Welcome to the ultimate guide on how to boost your database performance! We’ve designed it to help you understand and improve the performance of your databases, regardless of your level of experience as a DBA or whether you manage databases for a small or large... by Jean da Silva | Apr 3, 2024 | Insight for DBAs, MongoDB
by Mike Grayson | Apr 1, 2024 | Insight for DBAs, Insight for Developers, MongoDB
by Pep Pla | Jul 5, 2023 | Insight for DBAs, Insight for Developers, MySQL
Fragmentation is a common concern in some database systems. Highly fragmented tables can affect performance and resource allocation. But reducing fragmentation often involves rebuilding the table completely. This blog post will discuss fragmentation and its impact on... by Pep Pla | Jan 19, 2021 | Benchmarks, Insight for DBAs, MySQL, Percona Software
Large replication topologies are quite common nowadays, and this kind of architecture often requires a quick method to rebuild a replica from another server.The Clone Plugin, available since MySQL 8.0.17, is a great feature that allows cloning databases out of the... by Emily Ikuta | Aug 5, 2019 | MySQL, Webinars
Please join Percona CEO Peter Zaitsev as he presents “Performance Analyses and Troubleshooting Technologies for Databases” on Wednesday, August 7th, 2019 at 11:00 AM PDT (UTC-7). View the Recording Have you heard about the USE Method (Utilization –... by Vadim Tkachenko | Feb 22, 2019 | Benchmarks, MySQL
Percona Server for MySQL 8.0 comes with enterprise grade total data encryption features. However, there is always the question of how much overhead – or performance penalty – comes with the data decryption. As we saw in my networking performance post, SSL... by Peter Zaitsev | Aug 7, 2018 | Benchmarks, Insight for DBAs, MongoDB, MySQL, Percona Software
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... by Vadim Tkachenko | Aug 1, 2018 | Benchmarks, Insight for DBAs, MySQL, Open Source, Storage Engine
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... by Peter Zaitsev | Jun 18, 2018 | Insight for DBAs, MySQL, Open Source, Webinars
Please join Percona’s CEO, Peter Zaitsev as he presents MySQL: Scaling and High Availability – Production Experience Over the Last Decade(s) on Tuesday, June 19th, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now Percona is known as... by Sveta Smirnova | Jun 4, 2018 | Benchmarks, MySQL
In this blog, I will provide answers to the Q & A for the Troubleshooting MySQL Concurrency Issues with Load Testing Tools webinar.First, I want to thank everybody for attending my May 23, 2018, webinar on troubleshooting tools for MySQL. The recording and slides... by Peter Zaitsev | May 7, 2018 | Insight for DBAs, Percona Software, Webinars
Please join Percona’s CEO, Peter Zaitsev as he presents MySQL Troubleshooting and Performance Optimization with PMM on Wednesday, May 9, 2018, at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4).Optimizing MySQL performance and troubleshooting MySQL problems are two... by Peter Zaitsev | Jan 30, 2018 | Insight for DBAs, MySQL
In this blog post, I’ll look at whether optimizing indexing is always the key to improving MySQL query performance (spoiler, it isn’t).As we look at MySQL query performance, our first concern is often whether a query is using the right indexes to... by Sveta Smirnova | Jan 24, 2018 | Insight for DBAs, Insight for Developers, MySQL, Open Source, Webinars
Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents Troubleshooting MySQL Crashes on January 25, 2018, at 10:00 am PST (UTC -8) / 1:00 pm EST (UTC -5). Register Now This webinar is for every MySQL user! In this talk, I... by Vadim Tkachenko | Jan 18, 2018 | Insight for DBAs, Insight for Developers, MySQL, Security
In this blog post, we’ll look at does the Meltdown fix affect performance for MySQL on bare metal servers. Since the news about the Meltdown bug, there were a lot of reports on the performance hit from proposed fixes. We have looked at how the fix affects... by Peter Zaitsev | Jan 8, 2018 | Insight for DBAs, MySQL
In this blog post, we’ll look at how ioping can be used with other tools to understand and troubleshoot storage performance, specifically as it relates to MySQL workloads.I recently ran into ioping, a nice little utility by Konstantin Khlebnikov that checks... by Peter Zaitsev | Jan 5, 2018 | MySQL, Webinars
Thank you for attending my webinar on Wednesday, December 20, 2017, InnoDB Performance Optimization. In this blog, I will provide answers to the Q & A for the webinar.Are the T2 CPUs similar to the M4 series? I would expect them to be similar. Amazon does not... by Peter Zaitsev | Oct 18, 2017 | Insight for DBAs, MySQL
In this blog post, I’ll provide some guidance on how to choose the MySQL innodb_log_file_size.Like many database management systems, MySQL uses logs to achieve data durability (when using the default InnoDB storage engine). This ensures that when a transaction... by Krunal Bauskar | Jul 21, 2017 | MySQL, Percona Software
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance. Introduction Starting in version 5.7.17-29.20 of Percona XtraDB Cluster significantly improved performance. Depending on the workload, the increase in throughput is... by Vadim Tkachenko | Jun 22, 2017 | Benchmarks, Insight for DBAs, MySQL
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.We have mentioned ClickHouse in some recent posts (ClickHouse: New Open Source Columnar Database, Column Store Database Benchmarks:...