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…
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…
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…
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…
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…
As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.
You can find articles I wrote on Oracle’s blog.