by Tibor Korocz | Aug 6, 2020 | Benchmarks, MySQL, Percona Software
Recently I had the opportunity to test a storage device from ScaleFlux called CSD 2000. In this blog post, I will share the results of using it to run MySQL in comparison with an Intel device that had a similar capacity. First of all, why do we need another storage... by Tibor Korocz | May 13, 2020 | MySQL, Percona Software
I was testing the latest Percona XtraDB Cluster 8.0 (PXC) release which has the Galera 4 plugin, and I would like to share my experiences and thoughts on the Streaming Replication feature so far. What Is Streaming Replication, in One Sentence? In Galera 4, the large... by Tibor Korocz | Apr 28, 2020 | MySQL, Percona Software, ProxySQL
In this blog post I would like to give an overview of the most common failover scenarios and operations when using MySQL Group Replication 8.0.19 (aka GR) and Percona XtraDB Cluster 8 (PXC) (which is based on Galera), and explain how each technology handles each... by Tibor Korocz | Apr 21, 2020 | Insight for DBAs, MySQL, Percona Software
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 Tibor Korocz | Nov 4, 2019 | Cloud, MySQL
Recently I was doing some small testing by using EC2 instances on AWS and I noticed the execution time and performance highly depend on which time of the day I am running my scripts. I was using t3.xlarge instance type as I didn’t need many CPUs and memory for... by Tibor Korocz | Oct 30, 2019 | MySQL, Percona Software
In MySQL 8.0.18 there is a new feature called how it works under the hood.The high-level basics are the following: if there is a join, it will create an in-memory hash table based on one of the tables and will read the other table row by row, calculate a hash, and do... by Tibor Korocz | Oct 28, 2019 | MySQL
In MySQL 8.0.18 there is a new feature called Explain Analyze when for many years we mostly had only the traditional Explain. I know there are different formats, but those based on the same information just show it in a different format with some extra... by Tibor Korocz | Jul 15, 2019 | MySQL
Recently I had a customer where every single query was running in a transaction, as well as even the simplest selects. Unfortunately, this is not unique and many connectors like Java love to do that.In their case, the Java connector changed autocommit=off for the... by Tibor Korocz | Jun 26, 2019 | Insight for Developers, MySQL
In this blog post, I am going to show why we have to be careful with stored functions in select list, as a single query can cause thousands of queries in the background if we aren’t cautious.For this example, I am only going to use the SLEEP function to... by Tibor Korocz | Jun 25, 2019 | Cloud, MySQL
Recently I had a case where queries against Aurora Reader were 2-3 times slower than on the Writer node. In this blog post, we are going to discuss why.I am not going to go into the details of how Aurora works, as there are other blog posts discussing that. Here I am... by Tibor Korocz | Jan 2, 2019 | MySQL, Percona Software
Recently, I encountered a situation where MySQL gave error messages that I had never seen before: MySQL 2018-12-12T14:36:45.571440Z 0 [ERROR] Error log throttle: 150 'Can't create thread to handle new connection' error(s) suppressed 2018-12-12T14:36:45.571456Z 0... by Tibor Korocz | Nov 2, 2018 | Cloud
Recently, I’ve been working with a customer to evaluate the different cloud solutions for MySQL. In this post I am going to focus on maintenance windows and requirements, and what the different cloud platforms offer. Why is this important at all?... by Tibor Korocz | Oct 17, 2018 | Insight for DBAs, MySQL
Parallel replication has been around for a few years now but is still not that commonly used. I had a customer where the master had a very large write workload. The slave could not keep up so I recommended to use parallel slave threads. But how can I measure if it... by Tibor Korocz | Aug 6, 2018 | MySQL, Percona Software, ProxySQL, Webinars
Please join Percona’s Architect, Tibi Köröcz as he presents Utilizing ProxySQL for Connection Pooling in PHP on Tuesday August 14, 2018, at 8:00 am PDT (UTC-7) / 11:00 am EDT (UTC-4). Register Now ProxySQL is a very powerful tool, with extended... by Tibor Korocz | Jun 19, 2018 | MySQL, Percona Software, ProxySQL, Webinars
Including setting up Percona XtraDB Cluster with ProxySQL and PMM Please join Percona’s Architect, Tibi Köröcz as he presents Percona XtraDB Cluster 5.7 Tutorial Part 2 on Wednesday, June 20th, 2018, at 7:00 am PDT (UTC-7) / 10:00 am EDT (UTC-4).... by Tibor Korocz | May 9, 2018 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Yes, it does! In this blog post, I am going to share my recent experiences with ProxySQL and how important the database software version number can be. Migration I was working on a migration to Percona XtraDB Cluster (PXC) with ProxySQL, fortunately on a... by Tibor Korocz | Apr 17, 2018 | Insight for DBAs, MySQL, Percona Software, ProxySQL, Webinars
Please join Percona’s Architect, Tibi Köröcz as he presents Percona XtraDB Cluster 5.7 Tutorial on Wednesday, April 18, 2018, at 7:00 am PDT (UTC-7) / 10:00 am EDT (UTC-4).Never used Percona XtraDB Cluster before? Come join this 45-minute... by Tibor Korocz | Apr 4, 2018 | Insight for DBAs, Insight for Developers, MySQL
In this blog post, we’ll compare the performance of pattern matching queries vs. full-text indexes.In my previous blog post, I looked for a solution on how we can search only a part of the email address and how can we make faster queries where the condition is... by Tibor Korocz | Apr 2, 2018 | Insight for DBAs, Insight for Developers, Monitoring, MySQL, Percona Software
In this blog post, we’ll show that you can plot MySQL data in real time using Percona Monitoring and Management (PMM).In my previous blog post, I showed how we could load into any metrics, benchmarks into MySQL and visualize it with PMM. But that’s not...