MySQL Shell Plugins: check (part 3)
What is great with MySQL Shell Plugins, it’s that it provides you an infinite amount of possibilities. While I was writing the part I and part II of the check plugin, I realized I could extend it event more. The…
MySQL Shell Plugins: check (part 2)
In the first part of this article related to the check plugin, we discovered information retrieved from the binary logs. This part, is about what Performance_Schema and SYS can provide us about the queries hitting the MySQL database. Currently, 3…
MySQL Shell Plugins: check
This blog was initially referring to the audit plugin, but I renamed it as check plugin to be more compatible with all the current and future methods included in it. As you may know, it’s now possible to create your…
MySQL: Check who’s trying to access data they should not
To illustrate how easy it’s to see who’s trying to access data they have not been granted for, we will first create a schema with two tables: mysql> create database mydata; mysql> use mydata mysql> create table table1 (id int…
Using MySQL Community Repository with OL 8/RHEL 8/CentOS 8
MySQL 8.0 is now part of RedHat Enterprise 8 and other distros based on it like CentOS and Oracle Linux.. This is a very good thing ! However if for any reason you want to use the latest version of…
MySQL & InnoDB Disk Space
Yesterday, Bhuvanesh published an article about how to verify the difference between allocated diskspace for a tablespace and the the data in it. I commented with an old post explaining how to get some similar info only using SQL in…
How to integrate ProxySQL in MySQL InnoDB Cluster
MySQL InnoDB Cluster is the most easy and integrated High Availability solution for MySQL. The solution is composed of: MySQL Server MySQL Group Replication Plugin MySQL Clone Plugin MySQL Router MySQL Shell All those components are developed and tested together…
Join the Code ONE MySQL Track at Oracle Open World in San Francisco
Mid September, MySQL Community, MySQL Customers and MySQL Engineers will be in San Francisco to share their experience and present the new features of your favorite database ! The event will be held in Moscone South (just Mirko Ortensi‘s Hands-on…
MySQL 8.0: if I should optimize only one query on my application, which one should it be ?
Answering this question is not easy. Like always, the best response is “it depends” ! But let’s try to give you all the necessary info the provide the most accurate answer. Also, may be fixing one single query is not…
MySQL 8.0 Memory Consumption on Small Devices
Recently, PeterZ pointed a huge difference in memory usage of MySQL 8.0 compare to MySQL 5.7. This can be an issue for small instances if the same configuration for buffers like the buffer pool are not changed. As explained in…
Migrate from a single MySQL Instance to MySQL InnoDB Cluster using CLONE plugin
When somebody wants to migrate from a single MySQL instance to a full HA solution using MySQL InnoDB Cluster, the best solution to reduce the downtime is to use asynchronous replication and switch database only once at a certain point…
MySQL 8.0 and wrong dates
In MySQL 8.0, when using invalid values for date data types, an error is returned. This was not the case in 5.x versions.
