PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/host-cache.html
Initially, the host name is set to NULL and the flag is false. For permanent failures, the host name remains NULL and the validation flag is set to true. The MySQL server maintains an in-memory host cache that contains information about clients: IP ...
https://dev.mysql.com/doc/refman/9.7/en/ibd2sdi.html
ibd2sdi is a utility for extracting serialized dictionary information (SDI) from InnoDB tablespace files. ibd2sdi can be run on file-per-table tablespace files (*.ibd files), general tablespace files (*.ibd files), system tablespace files (ibdata* ...
https://dev.mysql.com/doc/refman/9.7/en/index-hints.html
row *************************** id: 1 select_type: DELETE table: t1 partitions: NULL type: range possible_keys: col2 key: col2 key_len: 5 ref: NULL rows: 72 filtered: 11.11 Extra: Using where 1 row in set, 1 warning (0.00 sec) . Index hints give ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-buffer-page-lru-table.html
The column is NULL if the server has not yet accessed the table. The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-foreign-table.html
0 = ON DELETE/UPDATE RESTRICT, 1 = ON DELETE CASCADE, 2 = ON DELETE SET NULL, 4 = ON UPDATE CASCADE, 8 = ON UPDATE SET NULL, 16 = ON DELETE NO ACTION, 32 = ON UPDATE NO ACTION. For related usage information and examples, see Section 17.15.3, ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-tablestats-table.html
This value might be null if no statistics are collected yet for the table. This value might be null if no statistics are collected yet for the table. The INNODB_TABLESTATS table provides a view of low-level status information about InnoDB tables.
https://dev.mysql.com/doc/refman/9.7/en/information-schema-processlist-table.html
DB The default database for the thread, or NULL if none has been selected. INFO The statement the thread is executing, or NULL if it is executing no statement. Important INFORMATION_SCHEMA.PROCESSLIST is deprecated and subject to removal in a ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-referential-constraints-table.html
The possible values are CASCADE, SET NULL, SET DEFAULT, RESTRICT, NO ACTION. The possible values are CASCADE, SET NULL, SET DEFAULT, RESTRICT, NO ACTION. The REFERENTIAL_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-routine-libraries-table.html
row *************************** ROUTINE_CATALOG: def ROUTINE_SCHEMA: jslib ROUTINE_NAME: foo ROUTINE_TYPE: FUNCTION LIBRARY_CATALOG: def LIBRARY_SCHEMA: jslib LIBRARY_NAME: lib1 LIBRARY_VERSION: NULL *************************** 2. row ... The ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-file-defragmenting.html
To speed up index scans, you can periodically perform a “null” ALTER TABLE operation, which causes MySQL to rebuild the table: ALTER TABLE tbl_name ENGINE=INNODB You can also use ALTER TABLE tbl_name FORCE to perform a “null” alter operation ... Random insertions into or deletions from a secondary index can cause the index to become ...