PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-functions-synchronization.html
The function returns NULL if the replication SQL thread is not started, the replica's source information is not initialized, the arguments are incorrect, or an error occurs. If the binary log file position has been marked as invalid, the function ...
https://dev.mysql.com/doc/refman/8.0/en/encrypted-connections.html
Encryption algorithms must include security elements to resist many kinds of known attacks such as changing the order of encrypted messages or replaying data twice. With an unencrypted connection between the MySQL client and the server, someone ...
https://dev.mysql.com/doc/refman/8.0/en/replace.html
To use REPLACE, you must have both the INSERT and DELETE privileges for the table. As with INSERT, if it is not possible to insert the new row into any of these partitions or subpartitions, the REPLACE statement fails with the error Found a row not ...REPLACE works exactly like INSERT, except that if an old row in the table has the same value as a new row for a PRIMARY KEY or a UNIQUE index, the old row is deleted before the new row is ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Reserved words are permitted as identifiers if you quote them as described in Section 11.2, “Schema Object Names”: mysql> CREATE TABLE interval (begin INT, end INT); ERROR 1064 (42000): You have an error in your SQL syntax ... ANALYSE ...This ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-mta.html
For this to be true, the binlog_transaction_dependency_tracking server system variable must be set to WRITESET on the source. MTA Configuration: Source Source mysqld configuration for the NDB MTA must include the following explicit settings: ...To ...Where dependencies cannot be efficiently determined, mysqld falls back to considering transactions dependent for reasons of ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-columns.html
As an illustration of when invisible columns may be useful, suppose that an application uses SELECT * queries to access a table, and must continue to work without modification even if the table is altered to add a new column that the application ...
https://dev.mysql.com/doc/refman/8.0/en/full-disk.html
Every 10 minutes it writes an entry to the log file, warning about the disk-full condition. Exceptions to the preceding behavior are when you use REPAIR TABLE or OPTIMIZE TABLE or when the indexes are created in a batch after LOAD DATA or after an ... This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to quota-exceeded errors (such as “write failed” or “user block limit ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-stage-tables.html
The Performance Schema tables provide a container to store progress data, but make no assumptions about the semantics of the metric itself: A “work unit” is an integer metric that increases over time during execution, such as the number of ...
https://dev.mysql.com/doc/refman/8.0/en/nonpersistible-system-variables.html
SET PERSIST and SET PERSIST_ONLY enable global system variables to be persisted to the mysqld-auto.cnf option file in the data directory (see Section 15.7.6.1, “SET Syntax for Variable Assignment”). A global system variable might involve ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-configuration.html
You can also set a location for the backup files using the BackupDataDir configuration parameter. Five configuration parameters are essential for backup: BackupDataBufferSize The amount of memory used to buffer data before it is written to disk.