PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-table-lock-waits.html
These views display which sessions are blocked waiting on metadata locks, and what is blocking them. The schema_table_lock_waits and x$schema_table_lock_waits views have these columns: object_schema The schema containing the object to be locked.
https://dev.mysql.com/doc/refman/8.0/en/sys-session.html
These views are similar to processlist and x$processlist, but they filter out background processes to display only user sessions. For descriptions of the columns, see Section 30.4.3.22, “The processlist and x$processlist Views”.
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-option-variable-reference.html
This table provides an overview of the command options, system variables, and status variables provided by X Plugin.
https://dev.mysql.com/doc/refman/8.0/en/purge-binary-logs.html
PURGE { BINARY | MASTER } LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of files that contain information about data modifications made by the MySQL server. Examples: PURGE BINARY LOGS TO 'mysql-bin.010'; PURGE BINARY LOGS ...The PURGE BINARY LOGS statement deletes all the binary log files listed in the log index file prior to the specified log file name or ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-subpartitions.html
Consider the following CREATE TABLE statement: CREATE TABLE ts (id INT, purchased DATE) PARTITION BY RANGE( YEAR(purchased) ) SUBPARTITION BY HASH( TO_DAYS(purchased) ) SUBPARTITIONS 2 ( PARTITION p0 VALUES LESS THAN (1990), PARTITION p1 VALUES LESS ... Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned ...
https://dev.mysql.com/doc/refman/8.0/en/alter-resource-group.html
The name and type attributes are set at group creation time and cannot be modified thereafter with ALTER RESOURCE GROUP. The attributes for CPU affinity, priority, and whether the group is enabled can be modified with ALTER RESOURCE GROUP. ALTER ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf32.html
utf32 takes twice as much space as ucs2 and more space than utf16, but utf32 has the same advantage as ucs2 that it is predictable for storage: The required number of bytes for utf32 equals the number of characters times 4. The utf32 character set ...Also, unlike utf16, there are no tricks for encoding in utf32, so the stored value equals the code ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8.html
utf8mb3 remains supported for the lifetimes of the MySQL 8.0.x and following LTS release series, as well as in MySQL 8.0. Since changing character sets can be a complex and time-consuming task, you should begin to prepare for this change now by ...
https://dev.mysql.com/doc/refman/8.0/en/expired-password-handling.html
Pass the CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS flag to mysql_real_connect() at connect time: MYSQL mysql; mysql_init(&mysql); if (!mysql_real_connect(&mysql, host, user, password, db, port, unix_socket, CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS)) { ...
https://dev.mysql.com/doc/refman/8.0/en/full-disk.html
This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to quota-exceeded errors (such as “write failed” or “user block limit reached”). The thread is aborted the next time it checks the ...