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-online-ddl-performance.html
Use this clause if the primary concern is finishing the DDL operation in the shortest amount of time possible, and concurrent query and DML access is not necessary. In the case of a long running or inactive transaction, an online DDL operation can ... Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in ...
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
An invalid value for a DATETIME, DATE, or TIME column is inserted as the implicit default value, regardless of the SQL mode NO_ZERO_DATE setting. For date and time types, the column is set to the appropriate “zero” value for the type. These are ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-table-info.html
Index Whether a key value can exist multiple times in the index. By default this is 1024, but the value may be changed at compile time when MySQL is built from source. To obtain a description of a MyISAM table or statistics about it, use the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-api-definition.html
(NDB 8.0.13) This parameter (along with RedoOverCommitLimit and RedoOverCommitCounter) controls the data node's handling of operations when too much time is taken flushing redo logs to disk. This occurs when a given redo log flush takes longer than ... The [mysqld] and [api] sections in the config.ini file define the behavior of the MySQL servers (SQL nodes) and other applications (API nodes) used to access cluster ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-commands.html
Sometimes a very wide result set is difficult to read on the screen. Have a tee file enabled and pager set to less, and you are able to browse the results using the less program and still have everything appended into a file the same time. The ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html
This option is disabled by default because histogram generation for large tables can take a long time. It is useful only with transactional tables such as InnoDB, because then it dumps the consistent state of the database at the time when START ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrument-filtering.html
The setup_instruments table lists the available instruments: mysql> SELECT NAME, ENABLED, TIMED FROM performance_schema.setup_instruments; +---------------------------------------------------+---------+-------+ | NAME | ENABLED | TIMED | ...| ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-memory-summary-tables.html
Allocating a single byte one million times is not the same as allocating one million bytes a single time; tracking both sizes and counts can expose the difference. Memory summary tables do not contain timing information because memory events are not ...Operation counts help to understand or tune the overall pressure the server is putting on the memory allocator, which has an impact on ...
https://dev.mysql.com/doc/refman/8.0/en/replication-delayed.html
MySQL supports delayed replication such that a replica server deliberately executes transactions later than the source by at least a specified amount of time. In MySQL 8.0, the method of delaying replication depends on two timestamps, ...This ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-gtids.html
A SET @@GLOBAL.gtid_purged statement was issued on MySQL 5.7.7 or earlier, and the binary log that was active at the time of the SET @@GLOBAL.gtid_purged statement has not yet been purged. If the server's most recent binary log files do not have ...