Search Results
https://dev.mysql.com/doc/refman/8.4/en/connection-control-plugin-installation.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). For example, put these lines in the server my.cnf file, adjusting the .so suffix for your ...
https://dev.mysql.com/doc/refman/8.4/en/help.html
HELP 'search_string' The HELP statement returns online information from the MySQL Reference Manual. Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 7.1.17, ...The HELP ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablestats-table.html
This data is used by the MySQL optimizer to calculate which index to use when querying an InnoDB table. Example mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLESTATS where TABLE_ID = 71\G *************************** 1. row ... The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-performance.html
Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in progress. Reduced locking and waiting for MySQL ...An exclusive metadata lock on the table may be taken briefly during the execution phase of the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-preload-buffer-pool.html
[mysqld] innodb_buffer_pool_dump_pct=40 The innodb_buffer_pool_dump_pct default value is 25 (dump 25% of most-recently-used pages). To restore the buffer pool state at server startup, specify the --innodb-buffer-pool-load-at-startup option when ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-tls.html
This section discusses the implementation and use of Transport Layer Security (TLS) to secure network communications in MySQL NDB Cluster. --ndb-tls-search-path is also supported for mysqld run as a cluster API node. Note TLS for NDB Cluster on ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog-backup.html
By default, mysqlbinlog reads binary log files and displays their contents in text format. This enables you to examine events within the files more easily and to re-execute them (for example, by using the output as input to mysql). mysqlbinlog can ...This capability enables you to easily back up a binary log in its original ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-connection-configuration-table.html
This table shows the configuration parameters used by the replica for connecting to the source. Parameters stored in the table can be changed at runtime with the CHANGE REPLICATION SOURCE TO statement. It contains values that define how the replica ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-rwlock-instances-table.html
The rwlock_instances table lists all the rwlock (read write lock) instances seen by the Performance Schema while the server executes. An rwlock is a synchronization mechanism used in the code to enforce that threads at a given time can have access ...
https://dev.mysql.com/doc/refman/8.4/en/replication-implementation.html
Replication is based on the source server keeping track of all changes to its databases (updates, deletes, and so on) in its binary log. The binary log serves as a written record of all events that modify database structure or content (data) from ...