https://dev.mysql.com/sys-wait-classes-global-by-latency.html
total_latency The total wait time of timed occurrences of events in the class. min_latency The minimum single wait time of timed occurrences of events in the class. avg_latency The average wait time per timed occurrence of events in the class.
https://dev.mysql.com/tables-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. To update cached values at any time for a given table, use ANALYZE TABLE. For example, InnoDB stores multiple tables in its system ...If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table statistics ...
https://dev.mysql.com/upgrade-binary-package.html
For example: mysqladmin -u root -p shutdown mysqld_safe --user=mysql --datadir=/path/to/existing-datadir & The first time you start the MySQL 8.0 server (in an earlier step), you may notice messages in the error log regarding nonupgraded tables. If ... This section describes how to upgrade MySQL binary and package-based installations on ...
https://dev.mysql.com/alter-user.html
role [, role ] ...: Set the default to the named roles, which must exist and be granted to the account at the time ALTER USER ... Order of WITH options does not matter, except that if a given resource limit is specified multiple times, the last ...
https://dev.mysql.com/create-user.html
These roles need not exist at the time CREATE USER is executed. Order of WITH options does not matter, except that if a given resource limit is specified multiple times, the last instance takes precedence. Instead, they determine how the server ...
https://dev.mysql.com/data-directory-initialization.html
To arrange for MySQL to start without manual intervention at system boot time, see Section 2.10.5, “Starting and Stopping MySQL Automatically”. Data directory initialization creates time zone tables in the mysql schema but does not populate them. To do so, use the instructions in Section 5.1.13, “MySQL Server Time Zone ... After MySQL is installed, the data directory must be initialized, including the tables in the mysql system schema: For some MySQL installation methods, data directory initialization is ...
https://dev.mysql.com/derived-table-optimization.html
When this happens, query execution is quicker by the time needed to perform materialization. If a CTE is materialized by a query, it is materialized once for the query, even if the query references it several times. This is similar to automatic ...
https://dev.mysql.com/group-replication-responses-failure-expel.html
You can use the group_replication_member_expel_timeout system variable, which is available from MySQL 8.0.13, to allow additional time between the creation of a suspicion and the expulsion of the suspect member. A group member is expelled when ...
https://dev.mysql.com/group-replication-understanding-consistency-guarantees.html
With the first approach, the group takes the minimum time possible to secure a stable group membership after a primary failure by electing a new primary and then allowing data access immediately while it is still applying any possible backlog from ... In terms of distributed consistency guarantees, either in normal or failure repair operations, Group Replication has always been an eventual consistency ...
https://dev.mysql.com/innodb-buffer-pool-stats-table.html
PAGES_MADE_YOUNG_RATE The number of pages made young per second (pages made young since the last printout / time elapsed). PAGES_MADE_NOT_YOUNG_RATE The number of pages not made per second (pages not made young since the last printout / time ... The ...
