Apr 02, 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 all! We can even visualize most any kind of […]
Mar 19, 2018 |
Insight for DBAs, MySQL
From time to time I see pattern matching queries with conditions that look like this: “where fieldname like ‘%something%’ “. MySQL cannot use indexes for these kinds of queries, which means it has to do a table scan every single time. (That’s really only half true — there are the FullText indexes. In another blog […]
Mar 15, 2018 |
Monitoring, MySQL, Percona Software, ProxySQL
In this blog post, we’ll look at how you can verify query performance using ProxySQL. In the previous blog post, I showed you how many information can you get from the “stats.stats_mysql_query_digest” table in ProxySQL. I also mentioned you could even collect and graph these metrics. I will show you this is not just theory, it […]
Feb 28, 2018 |
Monitoring, MySQL, Percona Software
In this blog post, we’ll checkout Percona Monitoring and Management vs. gnuplot when it comes to creating great metrics graphs. gnuplot is great, but PMM might provide graphs that are easier to read. Percona Monitoring and Management (PMM) is our free and open-source platform for managing and monitoring MySQL®, MariaDB® and MongoDB® performance, and is […]
Feb 27, 2018 |
Insight for DBAs, MySQL, ProxySQL
In this blog post, I’ll look at how to catch slow and frequent queries with ProxySQL. More and more people are using ProxySQL because it is a great tool and it can help DBAs a lot. But many people do not realize that it is more powerful than it looks. It has many features and possibilities. […]
Jun 27, 2017 |
Insight for DBAs, MySQL, Security
This blog post looks at SSL connections and how they work in MySQL 5.7. Recently I was working on an SSL implementation with MySQL 5.7, and I made some interesting discoveries. I realized I could connect to the MySQL server without specifying the SSL keys on the client side, and the connection is still secured […]
Apr 12, 2017 |
Insight for DBAs, MySQL
In this post, I am going to show you how you can minimize the performance impact of ProxySQL rules by using some finesse. Apply Test In my previous post, we could see the effect of the rules on ProxySQL performance. As we could also see, the “apply” option does not help with 1000 tables. Are we […]
Apr 10, 2017 |
Benchmarks, MySQL, ProxySQL
In this blog post we are going to take a closer look at ProxySQL rules. How do they work, and how big is the performance impact of having many rules? I would like to say thank you to Renè, who was willing to answer all my questions during my tests. Overview ProxySQL is heavily based […]
Nov 11, 2016 |
MySQL
This blog post was motivated by an internal discussion about how to fully disable query cache in MySQL. According to the manual, we should be able to disable “Query Cache” on the fly by changing
query_cache_type to 0, but as we will show this is not fully true. This blog will show you how to properly disable “query […]
Nov 09, 2016 |
Insight for DBAs, MySQL, ProxySQL
In this blog post, I am going to show you how can you use Orchestrator and ProxySQL together. In my previous blog post, I showed how to use bash scripts and move virtual IPs with Orchestrator. As in that post, I assume you already have Orchestrator working. If not, you can find the installation steps here. In the case of […]
Nov 03, 2016 |
Insight for DBAs, MySQL
In this post, I’ll discuss how to moving VIPs during a failover using Orchestrator. In our previous post, we showed you how Orchestrator works. In this post, I am going to give you a proof-of-concept on how Orchestrator can move VIPs in case of failover. For this post, I’m assuming the Orchestrator is already installed and […]
Oct 27, 2016 |
MySQL
MySQL 8.0 has a new feature called “invisible indexes,” which allow you to quickly enable/disable indexes from being used by the MySQL Optimizer. I wanted to share some of my first experiences and thoughts about this new feature. Why is it good for us? There are a couple of use cases. One of them is if you want to […]
Apr 27, 2016 |
MySQL, Percona Software
In this post, we’ll discuss how MySQL 5.7 handles the old temporal types during an upgrade. MySQL changed the temporal types in MySQL 5.6.4, and it introduced a new feature: microseconds resolution in the TIME, TIMESTAMP and DATETIME types. Now these parameters can be set down to microsecond granularity. Obviously, this means format changes, but why […]
Apr 13, 2016 |
Insight for DBAs, MySQL
In our previous post, we showed how Orchestrator can handle complex replication topologies. Today we will discuss how the Orchestrator-agent complements Orchestrator by monitoring our servers, and provides us a snapshot and recovery abilities if there are problems. Please be aware that the following scripts and settings in this post are not production ready (missing error handling, etc.) […]
Mar 08, 2016 |
Insight for DBAs, MySQL
This blog post discusses Orchestrator: MySQL Replication Topology Manager. What is Orchestrator? Orchestrator is a replication topology manager for MySQL. It has many great features: The topology and status of the replication tree is automatically detected and monitored Either a GUI, CLI or API can be used to check the status and perform operations Supports automatic […]