lefred's blog


There Are 10 Types of People in the World....

pre-FOSDEM MySQL Days 2020: registration is now open !

Hello dear MySQL Community ! As you know FOSDEM 2020 will take place February 1st and 2nd. After having received many, many requests we decided to organize for the 4th year in a row the pre-FOSDEM MySQL Day… with a big change, for this edition the event will be called “pre-FOSDEM MySQL Days” ! We have decided to extend that … 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 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 new methods I added to the plugin are especially useful when you are considering to use MySQL InnoDB Cluster in … 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 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 own plugins for MySQL Shell. See the following posts: https://lefred.be/content/overview-on-mysql-shell-8-0-17-extensions-plugins-and-how-to-write-yours/ https://lefred.be/content/mysql-router-8-0-17s-rest-api-mysql-shell-extensions/ https://lefred.be/content/how-to-integrate-proxysql-in-mysql-innodb-cluster/ https://lefred.be/content/mysql-innodb-disk-space/ I’ve created several plugins that you can … Read More


recent
categories