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/information-schema-table-privileges-table.html
The TABLE_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. TABLE_CATALOG The name of the catalog to which the table belongs. TABLE_SCHEMA The name of the schema ...The output does not list GRANT OPTION as a separate row with PRIVILEGE_TYPE='GRANT ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-truncate-table-reclaim-space.html
For a table to be stored in its own .ibd file, innodb_file_per_table must enabled when the table is created. When a table is truncated, it is dropped and re-created in a new .ibd file, and the freed space is returned to the operating system. This is ... To reclaim operating system disk space when truncating an InnoDB table, the table must be stored in its own .ibd ...
https://dev.mysql.com/doc/refman/8.0/en/derived-condition-pushdown-optimization.html
For a query in which the condition is on the tables of a view created using ALGORITHM=TEMPTABLE instead of on the view itself, the multiple equality is not recognized at resolution, and thus the condition cannot be not pushed down. When a derived ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-examples.html
Note This section describes locking information as exposed by the Performance Schema data_locks and data_lock_waits tables, which supersede the INFORMATION_SCHEMA INNODB_LOCKS and INNODB_LOCK_WAITS tables in MySQL 8.0. For similar discussion ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-schema.html
If an upgrade is necessary and supported, the server creates data dictionary tables with updated definitions, copies persisted metadata to the new tables, atomically replaces the old tables with the new ones, and reinitializes the data dictionary.
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-table-statistics-with-buffer.html
These views summarize table statistics, including InnoDB buffer pool statistics. By default, rows are sorted by descending total wait time (tables with most contention first). The schema_table_statistics_with_buffer and ...
https://dev.mysql.com/doc/refman/8.0/en/sys-sys-config.html
This table contains sys schema configuration options, one row per option. Configuration changes made by updating this table persist across client sessions and server restarts. The sys_config table has these columns: variable The configuration ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-page-table.html
The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. For related usage information and examples, see Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”. Do not query this table on a ...To ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-variable-tables.html
Status variable information is available in these Performance Schema tables: global_status: Global status variables. An application that wants only global values should use this table. An application that wants all status variable values for its own ... The MySQL server maintains many status variables that provide information about its operation (see Section 7.1.10, “Server Status ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-extensions-table.html
The TABLES_EXTENSIONS table (available as of MySQL 8.0.21) provides information about table attributes defined for primary and secondary storage engines. The TABLES_EXTENSIONS table has these columns: TABLE_CATALOG The name of the catalog to which ...