MySQL supports different types of Indexes. They depend on the storage engine and on the type of data. This is the list of supported indexes: B-trees (the most common) R-trees (for spatial data) Hashes (for Memory engine) Inverted (for InnoDB Full Text) Best Practices My recommendation are valid for InnoDB storage engine. I won’t talk about MyISAM. There are some … Read More
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.
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.
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
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