MySQL Parameters - Enabling Plugins and Components and Adding Variables

I've been hosting a page called MySQL Parameters, and someone mentioned this:

I realized that because I'm fetching the parameter list using mysqld --no-defaults --help --verbose, Group Replication—which is a plugin—isn't loaded yet, so its values couldn't be retrieved.

However, I was then taught that it can be done using the --plugin-load option.

Since I was at it, I decided to include as many plugins as possible, not just Group Replication, to output the parameter list.

https://mysql-params.tmtms.net/mysqld/?vers=8.0.21

Now the parameters for Group Replication are properly displayed.

But MySQL also has a mechanism called "components" instead of just plugins. I don't really understand the difference between plugins and components yet. Since components were introduced in 8.0, it's possible they will be used more than plugins from now on.

Also, it seems that these components cannot be specified at startup like with --plugin-load.

Since they appear in show variables after startup, I've made it possible to view a list of them.

https://mysql-params.tmtms.net/variable/?vers=8.0.21

At first, I thought about merging the results of mysqld --help -v and show variables, but upon comparison, I found that some items existed in only one and values differed slightly, so I created a separate page.

It's interesting to see both the validate_password plugin and the validate_password component displayed.

Thanks to these updates, it seems it was introduced at an official MySQL event 🎉

However, because I've kept expanding it, it has become quite messy, and I'm thinking about rebuilding it soon. Since I originally started this as a way to learn Vue, maybe I'll try building the next version using Vuetify.