Today, yet another blog post about improvements in MySQL 8.0 related to Performance_Schema. Before MySQL 8.0 it was not always easy to get an example of the queries you could find in Performance_Schema when looking for statements summaries. You had to link several tables (even from sys) to achieve this goal as I explained it in this post. Now in … Read More
With MySQL 8.0, the error logging subsystem has been redesigned to use the new component architecture. Thanks to this new redesign, now the log events can be filtered, the output can be sent to multiple destinations (different formats like JSON). All that is controlled by system variables. This work gives the possibility for a log event to become the raw … Read More
In MySQL 8.0, the engineers have added useful meta-data to the table SETUP_INSTRUMENT. This table lists the classes of instrumented objects for which events can be collected. To the NAME, ENABLES and TIMED columns, were added PROPERTIES, VOLATILITY and DOCUMENTATION. Let’s have a quick look at these new columns: PROPERTIES can have the following values global_statistics: only global summaries are … Read More
Recently, I received a question related to GO as delimter to send a query. The user got some generated statements from a third party tool that looked like this:
MySQL 8.0’s new default authentication plugin means more secure connections for users connections but also for replication… but you need to be aware of it ! Yesterday Giuseppe – the datacharmer – Maxia, submitted a bug related to a strange behavior of MySQL’s replication. He observed that after creating a new user for replication (using the new authentication method, caching_sha2_password), … Read More
comments