Search Results
https://dev.mysql.com/doc/refman/8.4/en/bit-value-literals.html
In numeric contexts, MySQL treats a bit literal like an integer. A leading 0b is case-sensitive and cannot be written as 0B. To ensure numeric treatment of a bit literal, use it in numeric context. For example, a bit literal assigned to a ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-monitoring.html
You can monitor the status and progress of a cloning operation on the recipient MySQL server instance using the clone_status and clone_progress Performance Schema tables. Note The clone_status and clone_progress Performance Schema tables can be used ...The clone_status table provides the state of the current or last executed cloning ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-replication.html
During the cloning operation, both the binary log position (filename, offset) and the gtid_executed GTID set are extracted and transferred from the donor MySQL server instance to the recipient. To clone for replication, perform the following steps: ...In addition to cloning data, a cloning operation extracts replication coordinates from the donor and transfers them to the recipient, which enables using the clone plugin for provisioning Group Replication members and ...
https://dev.mysql.com/doc/refman/8.4/en/environment-variables.html
This section lists environment variables that are used directly or indirectly by MySQL. In many cases, it is preferable to use an option file instead of environment variables to modify the behavior of MySQL. HOME The default path for the mysql ...
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
The mysql system database includes several grant tables that contain information about user accounts and the privileges held by them. For information about other tables in the system database, see Section 7.3, “The mysql System Schema”. To ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimization.html
By default, MySQL retrieves cached values for those columns from the mysql.index_stats and mysql.innodb_table_stats dictionary tables when the columns are queried, which is more efficient than retrieving statistics directly from the storage engine.
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-resize.html
$> mysqld --innodb-buffer-pool-size=8G --innodb-buffer-pool-instances=16 mysql> SELECT @@innodb_buffer_pool_size/1024/1024/1024; +------------------------------------------+ | @@innodb_buffer_pool_size/1024/1024/1024 | ... You can configure InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-syntax-warnings.html
mysql> SHOW WARNINGS; +---------+------+---------------------------------------------------------------+ | Level | Code | Message | +---------+------+---------------------------------------------------------------+ | Warning | 1478 | InnoDB: ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
When you create a UNIQUE or PRIMARY KEY index, MySQL must do some extra work. For UNIQUE indexes, MySQL checks that the table contains no duplicate values for the key. For a PRIMARY KEY index, MySQL also checks that none of the PRIMARY KEY columns ... Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this ...
https://dev.mysql.com/doc/refman/8.4/en/log-file-maintenance.html
As described in Section 7.4, “MySQL Server Logs”, MySQL Server can create several different log files to help you see what activity is taking place. When using MySQL with logging enabled, you may want to back up and remove old log files from ...