lefred's blog


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

MySQL: CPU information from SQL

Do you know that it’s possible to get information from the CPUs of your MySQL Server from SQL ? If you enable the status for the  INNODB_METRICS table in INFORMATION_SCHEMA, you will be able to query CPU information.


Perl & MySQL 8.0

If you just migrated to MySQL 8.0, you may have seen that the default authentication plugin has been changed to a more secure one: caching_sha2_password and I’ve already written some articles about it. Now let’s discover how Perl users can deal with MySQL 8.0.


MySQL Group Replication: what are those UDFs ?

To operate more easily a MySQL Group Replication (InnoDB Cluster), the Group Replication plugins provides some UDFs. If you have read the recent article from Tiago Vale about the Group Replication Communication Protocol, you may have heard about two new UDFs allowing to get or set  the communication protocol. So what are all the UDFs provided with the Group Replication … Read More


the MySQL Team in Austin, TX

At the end of the month, some engineers of the MySQL Team will be present in Austin, TX ! We will attend the first edition of Percona Live USA in Texas. During that show, you will have the chance to meet key engineers, product managers, as well as Dave and myself. Let me present you the Team that will be … Read More


MySQL InnoDB Cluster : Recovery Process Monitoring with the MySQL Shell Reporting Framework

As explained in this previous post, it’s now (since 8.0.16) possible to use the MySQL Shell Reporting Framework to monitor MySQL InnoDB Cluster. Additionally, when a member of the MySQL InnoDB Cluster’s Group leaves the group for any reason, or when a new node is added from a backup, this member needs to sync up with the other nodes of … Read More


recent

Last Tweets

Locations of visitors to this page
categories

 

the database server for this blog has been upgraded to MySQL 8.0.16
+