PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/myisamlog.html
If a recovery is done (-r), all writes and possibly updates and deletes are done and errors are only counted. If tables are named on the command line, only those tables are updated. This option can be given multiple times to produce more and more ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-config-send-buffers.html
This parameter can be set for all types of NDB Cluster nodes—that is, it can be set in the [ndbd], [mgm], and [api] (or [mysql]) sections of the config.ini file. This parameter is used in the config.ini file [tcp] section, and denotes the amount ... The NDB kernel employs a unified send buffer whose memory is allocated dynamically from a pool shared by all ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-other.html
The listings in this section provide information about parameters used in the [computer], [tcp], and [shm] sections of a config.ini file for configuring NDB Cluster. For detailed descriptions and additional information about individual parameters, ...The following parameters apply to the config.ini file's [computer] section: HostName: Host name or IP address of this ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-enterprise-backup.html
For these reasons, hot backups are desirable when your database “grows up” -- when the data is large enough that the backup takes significant time, and when your data is important enough to your business that you must capture every last change, ...The product is architected for efficient and reliable backups of tables created by the InnoDB storage ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-logging.html
Consider this input: mysql> SELECT -> 'Today is' -> , -> CURDATE() -> ; In this case, mysql logs the “SELECT”, “'Today is'”, “,”, “CURDATE()”, and “;” lines as it reads them. The following discussion describes characteristics ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-logging.html
Before MySQL 8.0.30, the size and number of redo log files are configured using the innodb_log_file_size and innodb_log_files_in_group variables. Thus, if you have transactions that update, insert, or delete many rows, making the log buffer larger ... Consider the following guidelines for optimizing redo logging: Increase the size of your redo log ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math.html
For example, MySQL treats a number such as .0001 as an exact value rather than as an approximation, and summing it 10,000 times produces a result of exactly 1, not a value that is merely “close” to 1. MySQL provides support for precision math: ...Precision math is based on these two features: SQL modes that control how strict the server is about accepting or rejecting invalid ...
https://dev.mysql.com/doc/refman/8.0/en/replica-io-thread-states.html
In MySQL 8.0.26, incompatible changes were made to instrumentation names, including the names of thread stages, containing the terms “master”, which is changed to “source”, “slave”, which is changed to “replica”, and “mts” (for ... The following list shows the most common states you see in the State column for a replication I/O (receiver) thread on a replica ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-dict-obj-tree.html
This means that you must know the name of any tablespace or log file group associated with a given table, or obtain this information from SHOW CREATE TABLE and then querying INFORMATION_SCHEMA.FILES, or similar means as shown here: mysql> SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/data-change-optimization.html
For inserting and updating large volumes of data (known in the industry as ETL, for “extract-transform-load”), sometimes you use other SQL statements or external commands, that mimic the effects of INSERT, UPDATE, and DELETE statements. This ...