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/information-schema-statistics-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. To update cached values at any time for a given table, use ANALYZE TABLE. The higher the cardinality, the greater the chance that ...If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table statistics ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-in-core-file.html
Note Access to the data present in buffer pool pages at the time the mysqld process died may be beneficial in some debugging scenarios. Because the buffer pool resides in main memory, and the memory image of a running process is dumped to the core ... A core file records the status and memory image of a running ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-table-close.html
The counter works as follows: The first time a table is updated in MySQL, a counter in the header of the index files is incremented. (The table may still be okay because MySQL always issues writes for everything between each statement.) A table was ...Multiple mysqld servers are using the table and one server performed a REPAIR TABLE or CHECK TABLE on the table while it was in use by another ...
https://dev.mysql.com/doc/refman/8.0/en/repair-table.html
EXTENDED If you use the EXTENDED option, MySQL creates the index row by row instead of creating one index at a time with sorting. See Section B.3.3.3, “What to Do If MySQL Keeps Crashing”, and Section 18.2.4, “MyISAM Table Problems”. This ...
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-syntax.html
In MySQL 8.0.22 and later, a user variable referenced by a statement in a stored procedure has its type determined the first time the procedure is invoked, and retains this type each time the procedure is invoked thereafter. MySQL supports a very ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/8.0/en/audit-log-legacy-filtering.html
Legacy Mode Audit Log Filtering is deprecated as of MySQL 8.0.34. Legacy Event Filtering by Account Legacy Event Filtering by Status Legacy Event Filtering by Account To filter audited events based on the originating account, set one (not both) of ... Note This section describes legacy audit log filtering, which applies if the audit_log plugin is installed without the accompanying audit tables and functions needed for rule-based ...
https://dev.mysql.com/doc/refman/8.0/en/engine-condition-pushdown-optimization.html
For example, in a my.cnf file, use these lines: [mysqld] optimizer_switch=engine_condition_pushdown=off At runtime, disable condition pushdown like this: SET optimizer_switch='engine_condition_pushdown=off'; Limitations. Filtering can be also ...
https://dev.mysql.com/doc/refman/8.0/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. This means that you can use the following SELECT statement to find rows into which ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-consistency-guarantees.html
Transactions whose consistency level is not EVENTUAL hold execution until a timeout, configured by wait_timeout value is reached, which defaults to 8 hours. A transaction cannot be on-hold forever, and if the time held exceeds wait_timeout it ...