Web-Konseil, is a web and digital agency based in Lyon, France.  The agency supports companies in the development of websites and e-commerce applications. Its business keeps growing with constant innovation and introduction of new services. Thanks to a partnership with Oracle, Web-Konseil already offers a hosting service for its customers on Oracle Cloud Infrastructure (OCI). […]

Web-Konseil is a web and digital agency based in Lyon, France. It develops websites and e-commerce applications for its clients using MySQL HeatWave in local Oracle data centers located in Paris and Marseille. MySQL HeatWave on OCI gives Web-Konseil a clear competitive advantage by offering their customers real time data insight.

Get it from the download page

3rd party updates:

• Update plink binaries to latest v0.78. Closes issue #1430

New stuff:

• Make clicks on grid column headers configurable, so the user may disable it, preventing him from accidental sortings on large tables. See https://www.heidisql.com/forum.php?t=40026
• Issue #1705: Add new network type "MySQL on RDS", to support its different query for killing a process. New icon provided by …

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 …

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 …

Recently, for the 3rd day of the MySQL Community Advent Calendar 2022,  I wrote an article on how to define a backup policy for MySQL Database Service in OCI using Terraform. We saw that it was possible to define tags (defined_tags and freeform_tags) in the backup_policy section of a oci_mysql_mysql_db_system resource. However, it seems that […]

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

MySQL Shell is a powerful way to connect to and manage MySQL instances. Connections can even be made to servers that are behind an SSH connection. In this post, we will discuss how to extend and customize MySQL Shell so that it is easier to initiate those connections. The Problem If you are like me, you use aliases […]