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/innodb-temporary-tablespace.html
row *************************** FILE_NAME: ./ibtmp1 TABLESPACE_NAME: innodb_temporary ENGINE: InnoDB INITIAL_SIZE: 12582912 TotalSizeBytes: 12582912 DATA_FREE: 6291456 MAXIMUM_SIZE: NULL TotalSizeBytes shows the current size of the global temporary ...The size of the pool never shrinks and tablespaces are added to the pool automatically as ...
https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html
If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row occurs. If column b is also unique, the INSERT is equivalent to this UPDATE statement ...In general, you should try to avoid using an ON DUPLICATE KEY UPDATE clause on tables with multiple unique ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-selection.html
Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is supported. When the PARTITION option is used, only the partitions and subpartitions listed are checked for matching rows. This option can be used in a ...Partition selection is similar to partition pruning, in that only specific partitions are checked for matches, but differs in two key respects: The partitions to be checked are specified by the issuer of the statement, unlike partition pruning, which is ...
https://dev.mysql.com/doc/refman/8.0/en/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. Expression Syntax Expression Term Notes Temporal Intervals Expression Syntax The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-redo-log-buffer.html
Thus, if you have transactions that update, insert, or delete many rows, increasing the size of the log buffer saves disk I/O. A large log buffer enables large transactions to run without the need to write redo log data to disk before the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-syntax.html
MySQL can handle BIGINT in the following cases: When using integers to store large unsigned values in a BIGINT column. This means that if you multiply two big integers (or results from functions that return integers), you may get unexpected results ... For integer data types, M indicates the minimum display ...
https://dev.mysql.com/doc/refman/8.0/en/set-operations.html
INTERSECT: Combine only those rows which the results of two query blocks have in common, omitting any duplicates. In other words, all of the following statements are true: TABLE x UNION TABLE y and TABLE y UNION TABLE x produce the same result, ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
For a nontransactional table, abort the statement if the value occurs in a single-row statement or the first row of a multiple-row statement. A value is missing when a new row to be inserted does not contain a value for a non-NULL column that has no ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
Afterwards, you can restore indexes for all tables at once with multithreaded building of indexes using --rebuild-indexes, which should be faster than rebuilding indexes concurrently for very large tables. Because some applications may set values ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-redo-log.html
If innodb_redo_log_capacity is not defined, and if neither innodb_log_file_size or innodb_log_files_in_group are defined, then the default innodb_redo_log_capacity value is used. If innodb_redo_log_capacity is not defined, and if ... The redo log is ...