Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-bootstrap.html
The bootstrap should only be done by a single server, the one that starts the group and only once. If it is saved in the option file, upon restart the server automatically bootstraps a second group with the same name. For the purpose of ... The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool.html
Buffer pool server status variables and the INNODB_BUFFER_POOL_STATS table provide many of the same buffer pool metrics found in InnoDB Standard Monitor output. On dedicated servers, up to 80% of physical memory is often assigned to the buffer pool.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-drop-index.html
--connect-retry-delay Command-Line Format --connect-retry-delay=# Type Integer Default Value 5 Minimum Value 0 Maximum Value 5 Number of seconds to wait between attempts to contact management server. --ndb-mgm-tls Command-Line Format ...It is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-waiter.html
Usually, this means that the node has received a START or RESTART command from the management server, but has not yet acted on it. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type Integer Default Value 5 Minimum Value 0 Maximum ... ndb_waiter repeatedly (each 100 milliseconds) prints out the status of all cluster data nodes until either the cluster reaches a given status or the --timeout limit is exceeded, then ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-runtime-configuration.html
If there are Performance Schema configuration changes that must be made at runtime using SQL statements and you would like these changes to take effect each time the server starts, put the statements in a file and start the server with the init_file ...This strategy can also be useful if you have multiple monitoring configurations, each tailored to produce a different kind of monitoring, such as casual server health monitoring, incident investigation, application behavior troubleshooting, and so ...
https://dev.mysql.com/doc/refman/8.4/en/replication-security.html
To protect against unauthorized access to data that is stored on and transferred between replication source servers and replicas, set up all the servers involved using the security measures that you would choose for any MySQL instance in your ...
https://dev.mysql.com/doc/refman/8.4/en/show-binlog-events.html
Some events relating to the setting of user and system variables are not included in the output from SHOW BINLOG EVENTS. Note Issuing a SHOW BINLOG EVENTS with no LIMIT clause could start a very time- and resource-consuming process because the ...
https://dev.mysql.com/doc/refman/8.4/en/stop-replica.html
You can control how long STOP REPLICA waits before timing out by setting the system variable rpl_stop_replica_timeout. Recommended best practice is to execute STOP REPLICA on the replica before stopping the replica server (see Section 7.1.19, “The ...] thread_type: IO_THREAD | SQL_THREAD channel_option: FOR CHANNEL channel Stops the replication ...
https://dev.mysql.com/doc/refman/8.4/en/too-many-connections.html
The permitted number of connections is controlled by the max_connections system variable. If clients encounter Too many connections errors when attempting to connect to the mysqld server, all available connections are in use by other clients. By ...
https://dev.mysql.com/doc/workbench/en/wbcopytables.html
wbcopytables is a command-line utility included in MySQL Workbench that enables you to copy table data from a supported source database server to MySQL. It is used by the MySQL Workbench Migration Wizard to copy data after the schema is migrated ...