Category: Performance_Schema
MySQL Lock information in MySQL Shell
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 to write or at least to remember, I thought it might be a good idea to add them to MySQL … Read More
MySQL Shell Plugins: InnoDB
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 us to have an overview of the progress of some alter statements status like: stage/innodb/alter table (end) stage/innodb/alter table (flush) … Read More
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 methods are available: getSlowerQuery() getQueryTempDisk() getFullTableScanQuery() The method’s name should be self explaining. This is an overview of the parameters … Read More
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 auto_increment primary key, name varchar(20), something varchar(20)); mysql> create table table2 (id int auto_increment primary key, name varchar(20), something varchar(20)); … Read More
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 enough and looking for that specific statement will lead in finding multiple problematic statements. The most consuming one The first … Read More
comments