Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-schema.html
Generally, the difference between MySQL data dictionary tables and system tables is that data dictionary tables contain metadata required to execute SQL queries, whereas system tables contain auxiliary data such as time zone and help information.
https://dev.mysql.com/doc/refman/8.4/en/events-configuration.html
If super_read_only is subsequently disabled after being enabled, the server automatically restarts the Event Scheduler as needed. Starting the MySQL server with the --skip-grant-tables option causes event_scheduler to be set to DISABLED, overriding ...The global event_scheduler system variable determines whether the Event Scheduler is enabled and running on the ... Events are ...
https://dev.mysql.com/doc/refman/8.4/en/packet-too-large.html
With some clients, you may also get a Lost connection to MySQL server during query error if the communication packet is too large. A communication packet is a single SQL statement sent to the MySQL server, a single row that is sent to the client, ...Both the client and the server have their own max_allowed_packet variable, so if you want to handle big packets, you must increase this variable both in the client and in the ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-basic-function-reference.html
The following table summarizes the functions available in the C API basic interface. For greater detail, see the descriptions in Section 5.4, “C API Basic Function Descriptions”.
https://dev.mysql.com/doc/refman/8.4/en/alter-instance.html
ALTER INSTANCE instance_action instance_action: { | {ENABLE|DISABLE} INNODB REDO_LOG | ROTATE INNODB MASTER KEY | ROTATE BINLOG MASTER KEY | RELOAD TLS [FOR CHANNEL {mysql_main | mysql_admin}] [NO ROLLBACK ON ERROR] | RELOAD KEYRING } ALTER ...This ...The statement supports these actions: ALTER INSTANCE {ENABLE | DISABLE} INNODB REDO_LOG This action enables or disables InnoDB redo ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-connection-security.html
Using MySQL Server’s own connection security in place of Group Replication’s implementation. Using the MySQL protocol means that standard methods of user authentication can be used for granting (or revoking) access to the group in place of the ... MySQL 8.4 Group Replication can secure group communication connections between members by one of the following methods: Using its own implementation of the security protocols, including TLS/SSL and the use of an allowlist for incoming Group Communication System (GCS) ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-deploying-locally.html
The instructions in this section are not suitable for production deployments because all MySQL server instances are running on the same single host. This section explains how to create a replication group with three MySQL Server instances on one ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-preload-buffer-pool.html
After restarting a busy server, there is typically a warmup period with steadily increasing throughput, as disk pages that were in the buffer pool are brought back into memory (as the same data is queried, updated, and so on). To restore the buffer ... To reduce the warmup period after restarting the server, InnoDB saves a percentage of the most recently used pages for each buffer pool at server shutdown and restores these pages at server ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-remote-connections.html
Start the MySQL server with an appropriate bind_address setting to permit it to accept IPv6 connections. For example, put the following lines in the server option file and restart the server: [mysqld] bind_address = * Specifying * (or ::) as the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-quick.html
# file "config.ini" - showing minimal setup consisting of 1 data node, # 1 management server, and 3 MySQL servers. # Data nodes must provide a hostname but MySQL Servers are not required # to do so. [ndbd default] NoOfReplicas= 1 [mysqld default] ...