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/cost-model.html
These estimates are stored in the server_cost and engine_cost tables in the mysql system database and are configurable at any time. Cost Model General Operation The Cost Model Database Making Changes to the Cost Model Database Cost Model General ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-page-lru-table.html
It has LRU_POSITION and COMPRESSED columns instead of BLOCK_ID and PAGE_STATE columns, and it does not include and IS_STALE column. For related usage information and examples, see Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”.
https://dev.mysql.com/doc/refman/8.0/en/innodb-error-handling.html
A lock wait timeout causes InnoDB to roll back the current statement (the statement that was waiting for the lock and encountered the timeout). Both deadlocks and lock wait timeouts are normal on busy servers and it is necessary for applications to ...InnoDB sometimes rolls back only the statement that failed, other times it rolls back the entire ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-connection-status-table.html
When the Performance Schema is disabled, local timing information is not collected, so the fields showing the start and end timestamps for queued transactions are zero. This table shows the current status of the I/O thread that handles the ...The ...
https://dev.mysql.com/doc/refman/8.0/en/set.html
See Section 13.3.1, “String Data Type Syntax” for SET type syntax and length limits. Note that SET columns can be assigned a character set and collation. For a column specified as SET('a','b','c','d'), the members have the following decimal and ... A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-restrictions.html
(See Section 10.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization”.) Example: UPDATE t ... FROM t...) AS dt ...); Here the result from the derived table is materialized as a ... In ...For example, this limitation applies to statements of the following forms: DELETE FROM t WHERE ...
https://dev.mysql.com/doc/refman/8.0/en/windows-create-option-file.html
If you need to specify startup options when you run the server, you can indicate them on the command line or place them in an option file. For options that are used every time the server starts, you may find it most convenient to use an option file ...You need to tune the server settings, such as memory, cache, or InnoDB configuration ...
https://dev.mysql.com/doc/refman/8.0/en/component-loading.html
MySQL supports manual component loading at runtime and automatic loading during server startup. For example: INSTALL COMPONENT 'file://component_validate_password'; UNINSTALL COMPONENT 'file://component_validate_password'; A loader service handles ...The INSTALL COMPONENT and UNINSTALL COMPONENT SQL statements enable component loading and ...
https://dev.mysql.com/doc/refman/8.0/en/error-handling.html
This appendix describes the types of error information MySQL provides and how to obtain information about them. It describes common problems and errors that may occur and potential resolutions.
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-innodb_cmpmem.html
The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information about compressed pages that reside in the buffer pool. Please consult Section 17.9, “InnoDB Table and Page Compression” for further information on compressed tables and ...Internal Details InnoDB uses a buddy allocator system to manage memory allocated to pages of various sizes, from 1KB to ...