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/create-view.html
(Selecting from the view selects, in effect, using the SELECT statement.) The select_statement can select from base tables or from other views. Beginning with MySQL 8.0.19, the SELECT statement can use a VALUES statement as its source, or can be ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-information-schema.html
In particular, for each INFORMATION_SCHEMA table that is a view on data dictionary tables: The server no longer must create a temporary table for each query of the INFORMATION_SCHEMA table. When the underlying data dictionary tables store values ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking.html
Intention Locks InnoDB supports multiple granularity locking which permits coexistence of row locks and table locks. WRITE takes an exclusive lock (an X lock) on the specified table. Intention locks are table-level locks that indicate which type of ...Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two types of locks, shared (S) locks and exclusive (X) ...
https://dev.mysql.com/doc/refman/8.0/en/insert.html
| TABLE table_name | VALUES row_constructor_list } [ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} value_list: value [, value] ... TABLE in MySQL 8.0.19 and later to insert rows from a single table. For the reasons for this, see ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo.html
This database contains a number of tables, each providing a different sort of data about NDB Cluster node status, resource usage, and operations. You can find more detailed information about each of these tables in the next several sections. ndbinfo ... ndbinfo is a database containing information specific to NDB ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-reference.html
Users communicate with the plugin by modifying the set of rules stored in this table. The plugin communicates information to users by setting the table's message column. Note The rules table is loaded into the plugin by the flush_rewrite_rules ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-statistics-estimation.html
Optimizer statistics are not persisted to disk when innodb_stats_persistent=OFF or when individual tables are created or altered with STATS_PERSISTENT=0. Optimizer Statistics Updates Non-persistent optimizer statistics are updated when: Running ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-events-table.html
The EVENTS table provides information about Event Manager events, which are discussed in Section 27.4, “Using the Event Scheduler”. The EVENTS table has these columns: EVENT_CATALOG The name of the catalog to which the event belongs. EXECUTE_AT ...EVENT_SCHEMA The name of the schema (database) to which the event ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-datafiles-table.html
The INNODB_DATAFILES table provides data file path information for InnoDB file-per-table and general tablespaces. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. Note The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-session-temp-tablespaces-table.html
The INNODB_SESSION_TEMP_TABLESPACES table provides metadata about session temporary tablespaces used for internal and user-created temporary tables. The INNODB_SESSION_TEMP_TABLESPACES table has these columns: ID The process or session ID. A range ...Space IDs are not persisted when the server is shut down and may be ...