Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-log-table.html
Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The Error Log”). Typically, the server writes diagnostics to a file on the server host or to a system log service.
https://dev.mysql.com/doc/refman/8.4/en/point-in-time-recovery-positions.html
The last section, Section 9.5.1, “Point-in-Time Recovery Using Binary Log”, explains the general idea of using the binary log to perform a point-in-time-recovery. As an example, suppose that around 20:06:00 on March 11, 2020, an SQL statement ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-functions.html
Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based ...
https://dev.mysql.com/doc/refman/8.4/en/storage-requirements.html
InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage ...
https://dev.mysql.com/doc/refman/8.4/en/using-date.html
You should use this format in UPDATE expressions and in the WHERE clause of SELECT statements. For example: SELECT * FROM t1 WHERE date >= '2003-05-05'; As a convenience, MySQL automatically converts a date to a number if the date is used in numeric ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-files-backed-up-summary.html
The following table shows the different types of files that are included in a single-file backup image or a directory backup. In the case of a single-file backup, unpack the file into a backup directory structure using the extract or the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.incremental.html
In order to that, after making first a full backup that contains all data, you can do one of the following: Performing a series of differential backups. Each differential backups includes all the changes made to the data since the last full backup ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/trouble.logging.html
Besides the message output of MySQL Enterprise Backup to the stderr stream and the log file, progress and history of each backup are also logged into the mysql.backup_progress and mysql.backup_history tables on the backed-up servers (to skip ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-mysqld.html
ndb-blob-read-batch-bytes: Specifies size in bytes that large BLOB reads should be batched into. ndb-blob-write-batch-bytes: Specifies size in bytes that large BLOB writes should be batched into. ndb-cluster-connection-pool-nodeids: Comma-separated ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-backup-cluster.html
backup cluster [--backupid=backup_id] [--snapshotstart | --snapshotend] [--waitstarted | --waitcompleted] [--password-file=filepath] cluster_name This command creates a backup of the MySQL NDB Cluster named cluster_name. backup cluster takes a ...