Search Results
https://dev.mysql.com/doc/refman/8.4/en/atomic-ddl.html
DDL Statement Behavior This section describes some important aspects of DDL statement behavior when using a storage engine that support atomic DDL, such as InnoDB. An atomic DDL statement combines the data dictionary updates, storage engine ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filter-definitions.html
Important It is theoretically possible for a user with sufficient permissions to mistakenly create an abort item in the audit log filter that prevents themselves and other administrators from accessing the system. For information about using JSON ...
https://dev.mysql.com/doc/refman/8.4/en/backup-and-recovery.html
It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data by mistake. Backups are also essential as a safeguard ...
https://dev.mysql.com/doc/refman/8.4/en/binary-installation.html
The mysql-files directory provides a convenient location to use as the value for the secure_file_priv system variable, which limits import and export operations to a specific directory. These include generic binary distributions in the form of ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-transaction-compression.html
Important Compressed transaction payloads are sent as a single packet, rather than each event of the transaction being sent in an individual packet, as is the case when binary log transaction compression is not in use. MySQL supports binary log ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
The binary log has two important purposes: For replication, the binary log on a replication source server provides a record of the data changes to be sent to replicas. The binary log contains “events” that describe database changes such as ...
https://dev.mysql.com/doc/refman/8.4/en/binlog-replication-configuration-overview.html
Important You cannot configure the source to log only certain events. This section describes replication between MySQL servers based on the binary log file position method, where the MySQL instance operating as the source (where the database ...
https://dev.mysql.com/doc/refman/8.4/en/blackhole-storage-engine.html
The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store it. To examine the source for the BLACKHOLE engine, look in the sql directory of a MySQL source distribution. When you create a ...
https://dev.mysql.com/doc/refman/8.4/en/bug-reports.html
If a program produces an error message, it is very important to include the message in your report. Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the ...
https://dev.mysql.com/doc/refman/8.4/en/can-not-connect-to-server.html
There are two ways to address this problem: Reduce the number of TCP ports consumed quickly by investigating connection pooling or persistent connections where possible Tune some settings in the Windows registry (see below) Important The following ... A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect through a file in the file system (default /tmp/mysql.sock), or by using TCP/IP, which connects through a port ...