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/optimize-character.html
For column values less than 8KB in size, use binary VARCHAR instead of BLOB. When MySQL retrieves any value from a row, it reads a data block containing all the columns of that row (and possibly other adjacent rows). Keeping each row small, with ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-pruning.html
By limiting the search, it is possible to expend much less time and effort in finding matching rows than by scanning all partitions in the table. An INSERT statement also accesses only one partition per inserted row; this is true even for a table ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-memory.html
The statement is always logged in statement format, even if the binary logging format is set to ROW, and it is written even if read_only or super_read_only mode is set on the server. This causes the replica to be out of synchrony with the source and ... When a replication source server shuts down and restarts, its MEMORY tables become ...
https://dev.mysql.com/doc/refman/8.0/en/window-functions-frames.html
Frames are determined with respect to the current row, which enables a frame to move within a partition depending on the location of the current row within its partition. Examples: By defining a frame to be all rows from the partition start to the ... The definition of a window used with a window function can include a frame ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. The INNODB_FT_INDEX_CACHE table has these columns: WORD A word extracted from the text of a newly inserted row. DOC_COUNT The number of rows ...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 the FULLTEXT index (for example, ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tables-table.html
row *************************** TABLE_ID: 1064 NAME: test/t1 FLAG: 33 N_COLS: 6 SPACE: 3 ROW_FORMAT: Dynamic ZIP_PAGE_SIZE: 0 SPACE_TYPE: Single INSTANT_COLS: 0 TOTAL_ROW_VERSIONS: 3 Notes You must have the PROCESS privilege to query this table. The ...For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-data-locks-table.html
row *************************** ENGINE: INNODB ENGINE_LOCK_ID: 139664434886512:1059:139664350547912 ENGINE_TRANSACTION_ID: 2569 THREAD_ID: 46 EVENT_ID: 12 OBJECT_SCHEMA: test OBJECT_NAME: t1 PARTITION_NAME: NULL SUBPARTITION_NAME: NULL INDEX_NAME: ...For information about which lock requests are blocked by which held locks, see Section 29.12.13.2, “The data_lock_waits ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-stages-history-long-table.html
When the table becomes full, the oldest row is discarded when a new row is added, regardless of which thread generated either row. The Performance Schema autosizes the value of N during server startup. To set the table size explicitly, set the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-statements-history-long-table.html
When the table becomes full, the oldest row is discarded when a new row is added, regardless of which thread generated either row. To set the table size explicitly, set the performance_schema_events_statements_history_long_size system variable at ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-transactions-history-long-table.html
When the table becomes full, the oldest row is discarded when a new row is added, regardless of which thread generated either row. The Performance Schema autosizes the value of N is autosized at server startup. To set the table size explicitly, set ... The events_transactions_history_long table contains the N most recent transaction events that have ended globally, across all ...