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/performance-schema-system-variable-tables.html
System variable information is available in these Performance Schema tables: global_variables: Global system variables. An application that wants only global values should use this table. An application that wants all system variable values for its ... The MySQL server maintains many system variables that indicate how it is configured (see Section 7.1.8, “Server System ...
https://dev.mysql.com/doc/refman/8.0/en/table-scan-avoidance.html
The output from EXPLAIN shows ALL in the type column when MySQL uses a full table scan to resolve a query. This usually happens under the following conditions: The table is so small that it is faster to perform a table scan than to bother with a ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-key-column-usage-table.html
This table provides no information about functional key parts because they are expressions and the table provides information only about columns. The KEY_COLUMN_USAGE table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the ...CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint ...
https://dev.mysql.com/doc/refman/8.0/en/metadata-locking.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 14.14, “Locking Functions”), and ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-upgrade.html
Each time you upgrade MySQL, you should execute mysql_upgrade, which looks for incompatibilities with the upgraded MySQL server: It upgrades the system tables in the mysql schema so that you can take advantage of new privileges or capabilities that ... Note As of MySQL 8.0.16, the MySQL server performs the upgrade tasks previously handled by mysql_upgrade (for details, see Section 3.4, “What the MySQL Upgrade Process ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-columns-table.html
For information about generated columns, see Section 15.1.20.8, “CREATE TABLE and Generated Columns”. You can cause such information to be hidden by setting show_gipk_in_create_table_and_information_schema = OFF. The related ST_GEOMETRY_COLUMNS ...ORDINAL_POSITION is necessary because you might want to say ORDER BY ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-tp-thread-state-table.html
The tp_thread_state table has one row per thread created by the thread pool to handle connections. Note The Performance Schema table described here is available as of MySQL 8.0.14. Prior to MySQL 8.0.14, use the corresponding INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-indexes-table.html
For GEN_CLUST_INDEX indexes, this value is 0 because the index is created using an artificial value rather than a real table column. Any other number represents a table created with a separate .ibd file in file-per-table mode. For related usage ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-deleted-table.html
The INNODB_FT_DELETED table stores rows that are deleted from the FULLTEXT index for an InnoDB table. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains ...For more information about InnoDB FULLTEXT search, see Section 17.6.2.4, “InnoDB Full-Text Indexes”, and Section 14.9, “Full-Text Search ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-relational-tables.html
You can also use X DevAPI to work with relational tables. In MySQL, each relational table is associated with a particular storage engine. The examples in this section use InnoDB tables in the world_x schema. Show All Tables To display all ...