by Peter Zaitsev | Jul 15, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
When I speak about MySQL performance troubleshooting (or frankly any other database), I tend to speak about four primary resources which typically end up being a bottleneck and limiting system performance: CPU, Memory, Disk, and Network.It would be great if when... by Peter Zaitsev | Jun 17, 2020 | Monitoring, MySQL, Percona Software
The RED Method (Rate, Errors, Duration) is one of the more popular performance monitoring approaches. It is often applied to Monitoring Microservices though there is nothing that prevents it from being applied to databases like MySQL.In Percona Monitoring and... by Peter Zaitsev | Jun 16, 2020 | MongoDB, Open Source
If you read the MongoDB SSPL FAQ it doesn’t sound like too big of a deal, unless you’re a “big, nasty cloud vendor.”But, I’ve got news for you — the implications for you are much deeper and worse than you might think from reading... by Peter Zaitsev | Apr 16, 2020 | MySQL
Recently, I got access to the list of MySQL bug reports from bugs.mysql.com which someone crawled and stored in a MySQL database. I thought it would be interesting to see who the heroes are of MySQL bug reporting! Top MySQL Bug Reporters Ever Shell select rank()... by Peter Zaitsev | Apr 14, 2020 | Benchmarks, MySQL, ProxySQL
When I run a benchmark and want to measure the CPU efficiency of something, I find it’s often a good choice to run a benchmark program, as well as the database, on the same server. This is in order to eliminate network impact and to look at single-thread... by Peter Zaitsev | Apr 13, 2020 | Benchmarks, MySQL, Percona Software
When connecting to a local MySQL instance, you have two commonly used methods: use TCP/IP protocol to connect to local address – “localhost” or 127.0.0.1 – or use Unix Domain Socket.If you have a choice (if your application supports... by Peter Zaitsev | Apr 8, 2020 | MySQL, Percona Software, ProxySQL
This article describes how to install ProxySQL from the Percona Software Repositories.Percona Software Repositories contain a ProxySQL version that has passed rigorous Percona tests and is known to be compatible with other Percona Software. We recommend using those... by Peter Zaitsev | Apr 7, 2020 | Database Trends, Insight for DBAs, MySQL
This is a three-part blog series that focuses on dealing with an unexpected high traffic event as it is happening. Part one can be found here, and part two can be found here. 13. Configure MySQL Server Properly Complexity:Medium Potential Impact:... by Peter Zaitsev | Apr 6, 2020 | Database Trends, Insight for DBAs, MySQL
This is a three-part blog series that focuses on dealing with an unexpected high traffic event as it is happening. Part one can be found here and part three can be found here. 7. Get More Memory Complexity: Low Potential Impact: HighIf your data does not fit into... by Peter Zaitsev | Apr 3, 2020 | Database Trends, Insight for DBAs, MySQL
This is a three-part blog series. Part two is located here, and part three can be found here. There was no reason to plan for it, but the load on your system increased 100%, 300%, 500%, and your MySQL database has to support it. This is a reality many online systems... by Peter Zaitsev | Mar 30, 2020 | Monitoring, MySQL, Percona Software
In my Webinar on Using Percona Monitoring and Management (PMM) for MySQL Troubleshooting, I showed how to use direct queries to ClickHouse for advanced query analysis tasks. In the followup Webinar Q&A, I promised to describe it in more detail and share some... by Peter Zaitsev | Mar 25, 2020 | Monitoring, MySQL, Percona Software
Last week I did a webinar on MySQL Troubleshooting and Performance Optimization with Percona Monitoring And Management v2 (PMM2).There was a tremendous amount of interest and many more questions than I could answer, so I’m answering them in this blog post... by Peter Zaitsev | Mar 4, 2020 | Insight for DBAs, MySQL
If you’re a MySQL user trying ClickHouse, one thing which is likely to surprise – and annoy you – is the handling of Double Quotes. In MySQL, you can use both double quotes and single quotes to quote strings, and as an example, these two queries are... by Peter Zaitsev | Feb 28, 2020 | Monitoring, MySQL, Percona Software
There are a lot of things I love about Prometheus; its data model is fantastic for monitoring applications and PromQL language is often more expressive than SQL for data retrieval needs you have in the observability space. One thing, though, I hate about Prometheus... by Peter Zaitsev | Feb 25, 2020 | MySQL, Storage Engine
Sometimes, you may experience “ERROR 1034: Incorrect key file” while running the ALTER TABLE or CREATE INDEX command: Shell mysql> alter table ontime add key(FlightDate); ERROR 1034 (HY000): Incorrect key file for table 'ontime'; try to repair it 12... by Peter Zaitsev | Feb 5, 2020 | Insight for Developers, MariaDB, MySQL
MariaDB no longer meeting your needs? Migrate to Percona software for MySQL – an open source, production-ready, and enterprise-grade MySQL alternative. Learn More I did a MariaDB Observability talk at MariaDB Day in Brussels, which I roughly based on the... by Peter Zaitsev | Jan 20, 2020 | Monitoring, MySQL, Percona Software
If you’re using MySQL’s Performance Schema you may use “query digests” as IDs to identify specific query patterns in the events_statements_summary_by_digest Performance Schema Table.You might assume these hashes are stable between different... by Peter Zaitsev | Jan 15, 2020 | Monitoring, Percona Software
April 2021 Update: From Percona Monitoring and Management 2.27, the procedure is now simplified and it is possible by running: docker exec pmm-server change-admin-password <new_password> 1 docker exec pmm-server change-admin-password <new_password>... by Peter Zaitsev | Jan 13, 2020 | MySQL, Storage Engine
A few days ago I wrote about how grossly outdated statistics returned through MySQL’s Information_Schema can be. In that post, Øystein Grøvlen suggested taking a look at mysql.innodb_table_stats and mysql.innodb_index_stats as a better source of... by Peter Zaitsev | Jan 8, 2020 | MySQL
MySQL obviously got many things right, otherwise, it would not be the World’s Most Popular Open Source Database (according to DB-Engines). Sometimes, however, I run into some decisions or behaviors which are just plain bad designs. Many such designs have a lot...