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-quick-start.html
The Performance Schema is implemented as a storage engine, so you can see it listed in the output from the Information Schema ENGINES table or the SHOW ENGINES statement: mysql> SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ... This section briefly ...
https://dev.mysql.com/doc/refman/8.0/en/semijoins.html
A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and materialization. For an inner join between two tables, the join returns a row from one ...The optimizer uses semijoin strategies to improve subquery execution, as described in this ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-page-lru-table.html
The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes full. The ...It has ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-memory-summary-tables.html
Memory summary tables do not contain timing information because memory events are not timed. Example memory event summary information: mysql> SELECT * FROM performance_schema.memory_summary_global_by_event_name WHERE EVENT_NAME = ...Operation counts ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-stage-summary-tables.html
The Performance Schema maintains tables for collecting current and recent stage events, and aggregates that information in summary tables. Section 29.12.5, “Performance Schema Stage Event Tables” describes the events on which stage summaries ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-transaction-summary-tables.html
The Performance Schema maintains tables for collecting current and recent transaction events, and aggregates that information in summary tables. Section 29.12.7, “Performance Schema Transaction Tables” describes the events on which transaction ...Example transaction event summary information: mysql> SELECT * FROM performance_schema.events_transactions_summary_global_by_event_name LIMIT 1\G *************************** ...
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 ...
https://dev.mysql.com/doc/refman/8.0/en/implicit-commit.html
(This does not apply to other operations on temporary tables such as ALTER TABLE and CREATE INDEX, which do cause a commit.) However, although no implicit commit occurs, neither can the statement be rolled back, which means that the use of such ...
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/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 ...