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/sys-host-summary-by-file-io.html
The host_summary_by_file_io and x$host_summary_by_file_io views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-file-io.html
The user_summary_by_file_io and x$user_summary_by_file_io views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are ...By ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablestats-table.html
MODIFIED_COUNTER The number of rows modified by DML operations, such as INSERT, UPDATE, DELETE, and also cascade operations from foreign keys. The rate at which the AUTOINC value changes depends on how many times auto-increment numbers have been ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-processlist-table.html
For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. Important INFORMATION_SCHEMA.PROCESSLIST is deprecated and subject to removal in a future MySQL ...As such, the implementation of SHOW PROCESSLIST which uses this table is also ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-next-key-locking.html
The so-called phantom problem occurs within a transaction when the same query produces different sets of rows at different times. For example, if a SELECT is executed twice, but returns a row the second time that was not returned the first time, ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-bulk-data-loading.html
Note When adding FTS_DOC_ID column at table creation time, ensure that the FTS_DOC_ID column is updated when the FULLTEXT indexed column is updated, as the FTS_DOC_ID must increase monotonically with each INSERT or UPDATE. If you choose not to add ...To disable autocommit during your import operation, surround it with SET autocommit and COMMIT statements: SET autocommit=0; ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-backup-recovery.html
For information about point-in-time recovery, recovery from disk failure or corruption, and how InnoDB performs crash recovery, see Section 17.18.2, “InnoDB Recovery”. This section covers topics related to InnoDB backup and recovery. For ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-restrictions-limitations.html
This section describes restrictions and limitations of the InnoDB storage engine. You cannot create a table with a column name that matches the name of an internal InnoDB column (including DB_ROW_ID, DB_TRX_ID, and DB_ROLL_PTR. InnoDB does not keep ...This restriction applies to use of the names in any ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-options-variables.html
If configuration values specified at startup time are incorrect, X Plugin could fail to initialize properly and the server does not load it. This section describes the command options and system variables that configure X Plugin, as well as the ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-crash-recovery.html
This section describes how to check for and deal with data corruption in MySQL databases. If you run myisamchk to check tables that mysqld is updating at the same time, you may get a warning that a table is corrupt even when it is not. If the ...If ...