Get it from the download page
3rd party updates:
New stuff:
ProxySQL is a very useful tool for gaining high availability, load balancing, query routing, query caching, query rewriting, multiplexing, and data masking. It is a proven tool and is used largely in production. There can be an instance of ProxySQL using a lot of memory on the server. This post is related to one of the causes that can use memory on the ProxySQL server and how we handle it.
Explanation
How do we know where the memory is getting used?
Proxysql has a stats database which we can see with an admin login. This database contains metrics gathered by ProxySQL concerning its internal functioning.
This post mostly talks about stats in MySQL query digest in ProxySQL.
Memory used by query digest can grow unlimited, and you can query the memory usage with the below query with an admin login. The memory usage is shown in bytes.
MySQL [(none)]> select * from …[Read more]
The need to audit who is using a database and their activities is crucial in many environments. This functionality is available in the free, open source Audit Plugin that is included in Percona Server for MySQL.
The prerequisite for installing Percona’s Audit Log Plugin is to first install Percona Server for MySQL. Percona Server for MySQL is a drop-in replacement for MySQL.
The Audit Log Plugin itself is easy to install requiring only a shared object library to be loaded from a MySQL client program with INSTALL PLUGIN audit_log SONAME ‘audit_log.so’;.
stoker@testbox:~/Downloads$ mysql -u root -p mysql Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL …[Read more]
MySQL Advent Calendar 2022 day 5 - How to use Backup Policies and Tags with MySQL Database Service in OCI
Learn how we can use MySQL Shell to connect to a remote server over SSH.
Advent Calendar 2022 - This article describes how to define the backup policy when deploying MySQL Database Service in OCI with Terraform
Creating aliases for MySQL Shell in PowerShell.
Advent Calendar 2022 - How to always use MySQL Shell even if we are used to the old mysql command line client.
If, in Percona Server, you are observing tail latencies on queries that should be fast, this might be a side effect of Percona's improved InnoDB Empty Free List Algorithm. When using this algorithm (the default in 5.6 and 5.7 and optional configuration in 8.0), a query needing a free page while none are available waits until the LRU Manager Thread refills the free list. Because this
If you are using MyDumper as your Logical Backup solution and you store your backups on S3, you need to take a local backup and then upload it to S3. But what if there is not enough space to hold the backup on the server where we are taking the backup? Even if we have enough disk space, we will need to wait until the end to start to upload the files, making the whole process longer.
MyDumper implemented stream backup in v0.11.3 and we have been polishing the code since then. We also implemented two ways of executing external commands:
−−exec-per-thread: The worker that is getting the
data from the database will write and redirect to the STDIN of
the external command. It will be similar to execute cat
FILE | command per every written and closed file.
−−exec: In this case, the worker writes in the local
storage and when the file is closed, the filename is enqueued.
The exec …