Last Tuesday, it was the very first session of DB AMA, Morgan Tocker made a nice presentation of MySQL Performance_Schema and illustrated it with some nice queries to get Meta et Data Locks. As those queries were not that simple…
Today, we will cover a totally different MySQL Shell plugin: InnoDB. Currently only 3 methods have been created: Those related to the Table space fragmentation, have already been covered in this recent article. Let’s discover the getAlterProgress()method. This method allows…
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…
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…
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.