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…
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.
SELECT UDF_NAME FROM performance_schema.user_defined_functions WHERE UDF_NAME LIKE ‘group_repl%’; +————————————————-+ | UDF_NAME | +————————————————-+ | group_replication_get_communication_protocol | | group_replication_get_write_concurrency | | group_replication_set_as_primary | | group_replication_set_communication_protocol | | group_replication_set_write_concurrency | | group_replication_switch_to_multi_primary_mode | | group_replication_switch_to_single_primary_mode | +————————————————-+ Some of these UDFs can…
If you registerd for our tutorial, please come with a laptop able to run 3 VirtualBox VMs that you can install from a USB stick. So please make free some disk space and install the latest Virtualbox on your system.…
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…
With MySQL Shell 8.0.16, a new very interesting feature was released: the Reporting Framework. Jesper already blogged about it and I recommend you to read his articles if you are interested in writing your own report: I this…
This post is just a reminder on how to find which settings have been set on MySQL Server. If you have modified some settings from a configuration file or during runtime (persisted or not), these two queries will show you…
As you may have noticed, MySQL 8.0.16 has been released today ! One of the major long expected feature is the support of CHECK contraints . My colleague, Dave Stokes, already posted an article explaining how this works. In this…
Disclaimer: it’s better to never change the value of group_replication_unreachable_majority_timeout This post provides you an overview of what could happen in the worse case but may lead in a very unstable setup We saw yesterday that when an issue (like…
Everywhere I go to present MySQL InnoDB Cluster, during the demo of creating a cluster, many people doesn’t understand why when I’ve 2 members, my cluster is not yet tolerant to any failure.
Today I started to check ripple the new MySQL binlog server. I don’t want to give yet any feedback neither I want to answer THE question: Is this the Binlog Server we were all waiting for ? But I had…
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.