Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-secure-user.html
Important When using the MySQL communication stack (group_replication_communication_stack=MYSQL) AND secure connections between members (group_replication_ssl_mode is not set to DISABLED), the recovery users must be properly set up, as they are also ... State transfer from the binary log requires a replication user with the correct permissions so that Group Replication can establish direct member-to-member replication ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-statistics-table.html
COMMENT Information about the index not described in its own column, such as disabled if the index is disabled. The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-change-buffer.html
If the working set almost fits in the buffer pool, or if your tables have relatively few secondary indexes, it may be useful to disable change buffering. You can enable or disable buffering for inserts, delete operations (when index records are ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-compression-oltp.html
innodb_log_compressed_pages lets you disable writing of images of re-compressed pages to the redo log. If you are certain that the zlib version is not subject to change, disable innodb_log_compressed_pages to reduce redo log generation for workloads ... Traditionally, the InnoDB compression feature was recommended primarily for read-only or read-mostly workloads, such as in a data warehouse ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
If innodb_stats_auto_recalc is disabled, you can ensure the accuracy of optimizer statistics by executing the ANALYZE TABLE statement after making substantial changes to indexed columns. A value of 1 enables persistent statistics for the table, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-statistics-estimation.html
SET GLOBAL innodb_stats_on_metadata=ON Note innodb_stats_on_metadata only applies when optimizer statistics are configured to be non-persistent (when innodb_stats_persistent is disabled). To improve the start up time of the mysql client and to ...
https://dev.mysql.com/doc/refman/8.4/en/large-page-support.html
It can be enabled or disabled by using the --super-large-pages or --skip-super-large-pages option. Large page support in the MySQL server is disabled by default. Some hardware and operating system architectures support memory pages greater than the ...
https://dev.mysql.com/doc/refman/8.4/en/lock-order-tool.html
The primary variable is lock_order, which indicates whether to enable the LOCK_ORDER tool at runtime: If lock_order is disabled (the default), no other LOCK_ORDER system variables have any effect. If lock_order is disabled (the default), no other ...
https://dev.mysql.com/doc/refman/8.4/en/log-file-maintenance.html
To rename the general query log or slow query log at runtime, first connect to the server and disable the log: SET GLOBAL general_log = 'OFF'; SET GLOBAL slow_query_log = 'OFF'; With the logs disabled, rename the log files externally (for example, ... 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 ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-launchd.html
macOS uses launch daemons to automatically start, stop, and manage processes and applications such as MySQL. The md5 checksum of a file containing the above snippet is d925f05f6d1b6ee5ce5451b596d6baed. To enable the launchd service, you can either: ...