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-transaction-tables.html
These tables store transaction events: events_transactions_current: The current transaction event for each thread. There are also summary tables that aggregate information about transaction events; see Section 29.12.20.5, “Transaction Summary ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-temp-table-info.html
INNODB_TEMP_TABLE_INFO provides information about user-created InnoDB temporary tables that are active in the InnoDB instance. It does not provide information about internal InnoDB temporary tables used by the optimizer. mysql> SHOW TABLES FROM ...
https://dev.mysql.com/doc/refman/8.0/en/insert-select.html
| TABLE table_name | VALUES row_constructor_list } [ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} value_list: value [, value] ... SELECT, you can quickly insert many rows into a table from the result of a SELECT statement, which ... INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html
This applies to statements such as UPDATE, INSERT, or DELETE (as before), but now also to statements such as ALTER TABLE and LOAD DATA. For example, BENCHMARK(10, (SELECT * FROM t)) fails if the table t has more than one column or more than one row.
https://dev.mysql.com/doc/refman/8.0/en/create-table-generated-columns.html
It is permitted to mix VIRTUAL and STORED columns within a table. A function is deterministic if, given the same data in tables, multiple invocations produce the same result, independently of the connected user. A generated column definition can ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-table-maintenance.html
This section discusses how to use myisamchk to check or repair MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). For general myisamchk background, see Section 6.6.4, “myisamchk — MyISAM Table-Maintenance ...
https://dev.mysql.com/doc/refman/8.0/en/show-open-tables.html
SHOW OPEN TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW OPEN TABLES lists the non-TEMPORARY tables that are currently open in the table cache. The FROM clause, if present, restricts the tables shown to those present in the db_name ...The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/data-size.html
To use a row format other than DYNAMIC, configure innodb_default_row_format, or specify the ROW_FORMAT option explicitly in a CREATE TABLE or ALTER TABLE statement. Design your tables to minimize their space on the disk. Smaller tables normally ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-issues.html
This can be done by issuing a statement such as ALTER TABLE mysql.ndb_apply_status ENGINE=MyISAM on the replica. In the event of a node failure, errors in replication of NDB tables without primary keys can still occur, due to the possibility of ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-handling-nulls.html
DROP PARTITION, see Section 15.1.9, “ALTER TABLE Statement”.) NULL is also treated in this way for partitioning expressions that use SQL functions. If you insert a row into a table partitioned by RANGE such that the column value used to ...