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/replication-rules-db-options.html
Proceed to checking the table-level replication options, if there are any. For a description of how these options are checked, see Section 19.2.5.2, “Evaluation of Table-Level Replication Options”. The statement is not executed until all ...
https://dev.mysql.com/doc/refman/8.0/en/reusing-ssl-sessions.html
To suppress the error message, and to establish the connection by silently creating a new session instead, specify --ssl-session-data-continue-on-failed-reuse on the command line, along with --ssl-session-data . By extracting a session ticket from ... As of MySQL 8.0.29, MySQL client programs may elect to resume a prior SSL session, provided that the server has the session in its runtime ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statement-analysis.html
tmp_tables The total number of internal in-memory temporary tables created by occurrences of the statement. tmp_disk_tables The total number of internal on-disk temporary tables created by occurrences of the statement. full_scan The total number of ...The statement_analysis and x$statement_analysis views have these columns: query The normalized statement ...
https://dev.mysql.com/doc/refman/8.0/en/file-permissions.html
For example, mysqld might issue the following error message when you create a table: ERROR: Can't find file: 'path/with/file_name' (Errcode: 13) The default UMASK and UMASK_DIR values are 0640 and 0750, respectively. If this is unsuitable, create ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html
This limit has been identified from testing and benchmarking as a safe boundary where the group performs reliably on a stable local area network. What is the group_replication_bootstrap_group option used for? The bootstrap flag instructs a member to ...What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-config-editor.html
The login path file must be readable and writable to the current user, and inaccessible to other users. Invoke mysql_config_editor like this: mysql_config_editor [program_options] command [command_options] If the login path file does not exist, ...
https://dev.mysql.com/doc/refman/8.0/en/account-management-statements.html
MySQL account information is stored in the tables of the mysql system schema. Important Some MySQL releases introduce changes to the grant tables to add new privileges or features. To make sure that you can take advantage of any new capabilities, ...This database and the access control system are discussed extensively in Chapter 7, MySQL Server Administration, which you should consult for additional ...
https://dev.mysql.com/doc/refman/8.0/en/charset-metadata.html
This is also true of the contents of tables in INFORMATION_SCHEMA because those tables by definition contain information about database objects. Otherwise, neither the SHOW statements nor SELECT statements for tables in INFORMATION_SCHEMA would work ... Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is ...
https://dev.mysql.com/doc/refman/8.0/en/charset-mysql.html
To display the available character sets, use the INFORMATION_SCHEMA CHARACTER_SETS table or the SHOW CHARACTER SET statement. To list the display collations for a character set, use the INFORMATION_SCHEMA COLLATIONS table or the SHOW COLLATION ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode.html
Beginning with MySQL 8.0.28, utf8mb3 is also displayed in place of utf8 in columns of Information Schema tables, and in the output of SQL SHOW statements. Table 12.2, “Unicode Character Set General Characteristics”, summarizes the general ...