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/upgrading-what-is-upgraded.html
If the actual data dictionary version is lower than the current expected version, 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, ... Installing a new version of MySQL may require upgrading these parts of the existing installation: The mysql system schema, which contains tables that store information required by the MySQL server as it runs (see Section 7.3, “The mysql System ...
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-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/nontransactional-tables.html
This can happen if you try to create a table using a transactional storage engine that is not supported by your mysqld server (or that was disabled with a startup option). If mysqld does not support a storage engine, it instead creates the table as ... If you receive the following message when trying to perform a ROLLBACK, it means that one or more of the tables you used in the transaction do not support transactions: Warning: Some non-transactional changed tables couldn't be rolled back These nontransactional tables are not affected by the ROLLBACK ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-dict-obj-tree.html
This means that you must know the name of any tablespace or log file group associated with a given table, or obtain this information from SHOW CREATE TABLE and then querying INFORMATION_SCHEMA.FILES, or similar means as shown here: mysql> SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-virtual-table.html
CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL, `c` int(11) GENERATED ALWAYS AS (5) VIRTUAL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; However, metadata for such a column does appear in the ... The ...
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 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-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 ...