Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-throttling.html
The writer-quota is enforced by the throttling mechanism if the queue size of the certifier or the binary log applier exceeds a user-defined threshold. Based on the metrics gathered across all servers in the group, a throttling mechanism kicks in ...
https://dev.mysql.com/doc/refman/8.4/en/handler.html
The HANDLER interface is a more natural way to look at data when working with applications that provide an interactive user interface to the database. HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } ...
https://dev.mysql.com/doc/refman/8.4/en/hexadecimal-literals.html
For example, a hexadecimal literal assigned to a user-defined variable is a binary string by default. Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, A..F). Lettercase of the ...
https://dev.mysql.com/doc/refman/8.4/en/history.html
The name of the MySQL Dolphin (our logo) is “Sakila,” which was chosen from a huge list of names suggested by users in our “Name the Dolphin” contest. We started out with the intention of using the mSQL database system to connect to our ...
https://dev.mysql.com/doc/refman/8.4/en/index.html
For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users. Including MySQL NDB Cluster 8.4 Abstract This is the MySQL Reference Manual. It documents MySQL 8.4 through 8.4.6, as well as NDB ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-enabled-roles-table.html
The ENABLED_ROLES table has these columns: ROLE_NAME The user name part of the granted role. The ENABLED_ROLES table provides information about the roles that are enabled within the current session. IS_DEFAULT YES or NO, depending on whether the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimizer-trace-table.html
INSUFFICIENT_PRIVILEGES If a traced query uses views or stored routines that have SQL SECURITY with a value of DEFINER, it may be that a user other than the definer is denied from seeing the trace of the query. The OPTIMIZER_TRACE table provides ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-profiling-table.html
Its contents correspond to the information produced by the SHOW PROFILE and SHOW PROFILES statements (see Section 15.7.7.32, “SHOW PROFILE Statement”). The table is empty unless the profiling session variable is set to 1. Note This table is ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-schemata-table.html
Caution Because any static global privilege is considered a privilege for all databases, any static global privilege enables a user to see all database names with SHOW DATABASES or by examining the SCHEMATA table of INFORMATION_SCHEMA, except ... A ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-checkpoints.html
There is no need to flush the buffer pool in one single batch, which would disrupt processing of user SQL statements during the checkpointing process. Making your log files very large may reduce disk I/O during checkpointing. It often makes sense ...