Search Results
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-installation.html
To be usable by the server, the component library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). If necessary, configure the plugin directory location by setting the value of plugin_dir at ... Note The Audit Log component is intended to replace the Audit Log plugin, which is now ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-enabling-monitors.html
The innodb_status_output and innodb_status_output_locks system variables are used to enable the standard InnoDB Monitor and InnoDB Lock Monitor. Enabling the Standard InnoDB Monitor Enable the standard InnoDB Monitor by setting the ... When InnoDB ...InnoDB sends the monitor output to stderr rather than to stdout or fixed-size memory buffers to avoid potential buffer ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/configuring-parallel-applier.html
Important The server system variable slave_parallel_workers (deprecated in MySQL 8.0.30) is removed in 8.3.0 and can not be set or read by MySQL Shell's applierWorkerThreads option for MySQL Server 8.3.0 or higher. This means that on instances ...As ... Instances support and enable parallel replication applier threads, sometimes referred to as a multi-threaded ...
https://dev.mysql.com/doc/refman/9.7/en/charset-errors.html
If the server sends the error message to a client program, the server converts it from UTF-8 to the character set specified by the character_set_results system variable. This section describes how the MySQL server uses character sets for ...For ...
https://dev.mysql.com/doc/refman/9.7/en/clone-plugin-failure-handling.html
Concurrent DDL on the donor is blocked only if the clone_block_ddl variable is set to ON (the default setting is OFF). If the cloning operation is unable to obtain a DDL lock within the time limit specified by the clone_ddl_timeout variable, an ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-setup-instruments-table.html
For some instruments, modifications are effective only at server startup; changing them at runtime has no effect. This affects primarily mutexes, conditions, and rwlocks in the server, although there may be other instruments for which this is true.
https://dev.mysql.com/doc/refman/9.7/en/myisamchk-general-options.html
For more information, see the description of myisam_stats_method in Section 7.1.8, “Server System Variables”, and Section 10.3.8, “InnoDB and MyISAM Index Statistics Collection”. If you want a faster repair, set the key_buffer_size and ...
https://dev.mysql.com/doc/refman/9.7/en/sql-prepared-statements.html
To guard against too many prepared statements being created simultaneously, set the max_prepared_stmt_count system variable. For compliance with the SQL standard, which states that diagnostics statements are not preparable, MySQL does not support ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-host-cache-table.html
The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to avoid Domain Name System (DNS) lookups. The host_cache_size system variable controls the size of the host cache, as well as ...The host_cache table has these columns: IP The IP address of the client that connected to the server, expressed as a ...For ...
https://dev.mysql.com/doc/refman/9.7/en/reset-binary-logs-and-gtids.html
The value of the gtid_purged system variable is set to an empty string (''), the global value (but not the session value) of the gtid_executed system variable is set to an empty string, and the mysql.gtid_executed table is cleared (see ...For a ...