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/performance-schema-prepared-statements-instances-table.html
Instrument Server Command statement/com/Prepare COM_STMT_PREPARE statement/com/Execute COM_STMT_EXECUTE statement/sql/prepare_sql SQLCOM_PREPARE statement/sql/execute_sql SQLCOM_EXECUTE The Performance Schema manages the contents of the ...This is ... The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-table-distribution-status.html
The table_distribution_status table provides information about the progress of table distribution for NDB tables. is_reorg_ongoing Whether the table is currently being reorganized (1 if true) .
https://dev.mysql.com/doc/refman/8.0/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 28.2 INFORMATION_SCHEMA General Tables Table Name Description Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-statements-current-table.html
CREATED_TMP_DISK_TABLES Like the Created_tmp_disk_tables status variable, but specific to the statement. CREATED_TMP_TABLES Like the Created_tmp_tables status variable, but specific to the statement. The table stores one row per thread showing the ...The THREAD_ID and EVENT_ID values taken together uniquely identify the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-wait-summary-tables.html
If an instrument is used to create multiple instances, each instance has a unique OBJECT_INSTANCE_BEGIN value and is summarized separately in this table. The Performance Schema maintains tables for collecting current and recent wait events, and ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-internals.html
If innodb_strict_mode is ON, MySQL checks the maximum row size during CREATE TABLE or CREATE INDEX. If you create a table when innodb_strict_mode is OFF, and a subsequent INSERT or UPDATE statement attempts to create an index entry that does not fit ... This section describes some internal implementation details about compression for InnoDB ...The information presented here may ...
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/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/myisam-repair.html
In this case, you must use ALTER TABLE to increase the MAX_ROWS and AVG_ROW_LENGTH table option values: ALTER TABLE tbl_name MAX_ROWS=xxx AVG_ROW_LENGTH=yyy; If you do not know the current table option values, use SHOW CREATE TABLE. Use the table ...