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: High If 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 Vadim Tkachenko | Apr 3, 2020 | MongoDB, MySQL, Percona Software
We recently released an experimental version of percona-dbaas command-line tool with the goal of significantly simplifying the deployment of database instances in Kubernetes. We have Kubernetes Operators for Percona XtraDB Cluster and Percona Server for MongoDB, which...
by Walter Garcia | Apr 2, 2020 | MySQL, ProxySQL, Security
In this blog, we will test a new security feature added in ProxySQL 2.0.9. Since a time ago, we have had the ability to block queries using mysql_query_rules table matching a group of queries using reg exp like a blacklist. Check out a previous blog for how to config...
by Tibor Korocz | Apr 1, 2020 | MySQL, Open Source
Recently I was looking for some simple way to analyze and create graphs from data stored in MySQL tables. I know Grafana can also plot graphs from MySQL tables, but somehow it felt like overkill and you are not using the traditional SQL syntax there. So I was...
by Brian Sumpter | Apr 1, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
While there is no magic bullet for MySQL 5.7 database tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. While much information has been published on this topic over the years, I...
by Vadim Tkachenko | Mar 31, 2020 | MySQL
Working on a weekend project, I became familiar with the SQL keyword “LATERAL”, which I had not used before because it was only introduced recently in MySQL 8.0.14, so I wanted to share how it can be used. Some references on this topic: Lateral Derived Tables...
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 Ananias Tsalouchidis | Mar 30, 2020 | Benchmarks, Cloud, Insight for DBAs, MySQL, Percona Software
More and more people are nowadays thinking of cloud migration. The question of “Which cloud provider performs better for my MySQL workload?” is really common but cannot always be easily answered. However, there are ways to come up with an answer. This question also...
by Carlos Tutte | Mar 26, 2020 | Insight for DBAs, MySQL, Percona Software
Disclaimer: The following blog post does not try to provide a solution for split-brain situations, and the example provided is for demonstrative purposes only. Inconsistencies resulting from a split-brain scenario might possibly be more complex than the one shown, so...
by Marco Tusa | Mar 26, 2020 | Benchmarks, MySQL, Open Source
What You May Not Know About Random Number Generation in Sysbench Sysbench is a well known and largely used tool to perform benchmarking. Originally written by Peter Zaitsev in early 2000, it has become a de facto standard when performing testing and benchmarking....
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 instead. Q:...
by Borys Belinsky | Mar 19, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
Percona is happy to announce the experimental release of Percona XtraDB Cluster 8.0. This is a major step for tuning Percona XtraDB Cluster to be more cloud- and user-friendly. This is the second experimental release that combines the updated and feature-rich Galera...
by Tyler Duzan | Mar 18, 2020 | Insight for DBAs, MongoDB, MySQL, Percona Software
Percona has been investing in building and releasing Operators for Kubernetes to run traditional databases in a cloud-native fashion. The first two Kubernetes operators were for Percona Server for MongoDB and Percona XtraDB Cluster, chosen because they both feature...
by David Quilty | Mar 9, 2020 | MySQL, Webinars
In this talk, we’ll walk through RocksDB technology and look into situations where MyRocks is a good fit versus other engines such as InnoDB. We will go over internals, benchmarks, and the tuning of MyRocks engine. We will also explore the benefits of using...
by Ceri Williams | Mar 6, 2020 | MySQL, Open Source, ProxySQL
In the MySQL ecosystem, orchestrator is the most popular and well-respected high availability and topology management tool, integrating well with other solutions such as ProxySQL. It facilitates automatic (or manual) discovery, refactoring and recovery of a replicated...
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 David Quilty | Mar 4, 2020 | Monitoring, MySQL, Percona Software, Webinars
As a MySQL DBA, the databases powering your applications need to handle changing traffic workloads while remaining responsive and stable so you can deliver an excellent user experience. Optimizing MySQL performance and troubleshooting MySQL problems cost-efficiently...
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 mysql> alter...
