PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-replication-group-members.html
The information in the table is updated whenever there is a view change, for example when the configuration of the group is dynamically changed when a new member joins. The performance_schema.replication_group_members table is used for monitoring ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-indexes-table.html
Any other number represents a table created with a separate .ibd file in file-per-table mode. If the amount of data in an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an update operation, ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-encrypted-file-plugin.html
Before updating the file, the plugin verifies that it contains the expected checksum. Note The keyring_encrypted_file plugin is an extension included in MySQL Enterprise Edition, a commercial product. The keyring_encrypted_file keyring plugin ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.0/en/load-xml.html
LOAD XML acts as the complement of running the mysql client in XML output mode (that is, starting the client with the --xml option). The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-optimization.html
To coalesce fragmented rows and eliminate wasted space that results from deleting or updating rows, run myisamchk in recovery mode: $> myisamchk -r tbl_name You can optimize a table in the same way by using the OPTIMIZE TABLE SQL statement.
https://dev.mysql.com/doc/refman/8.0/en/password-logging.html
In particular, INSERT or UPDATE statements for the mysql.user system table that refer to literal passwords are logged as is, so you should avoid such statements. Use a restricted access mode to protect database backups that include log tables or log ... Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT and SET ...
https://dev.mysql.com/doc/refman/8.0/en/programs-overview.html
It updates the grant tables with any changes that have been made in newer versions of MySQL, and checks tables for incompatibilities and repairs them if necessary. MySQL client programs that connect to the MySQL server: mysql The command-line tool ...Later sections provide a more detailed description of each one, with the exception of NDB Cluster ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover-replica.html
Note A server participating in a group in single-primary mode must be started with --skip-replica-start=ON. This is the case whether the sources are a managed group for which the membership is updated automatically, or whether they are added or ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-diffengines.html
(This requires that the NO_ENGINE_SUBSTITUTION SQL mode is not enabled.) If you want to disable additional engines in this way, you may want to consider building a special binary to be used on the replica that supports only the engines you want. If ... It does not matter for the replication process whether the original table on the source and the replicated table on the replica use different storage engine ...