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-innodb-buffer-page-lru-table.html
Querying this table can require MySQL to allocate a large block of contiguous memory, more than 64 bytes times the number of active pages in the buffer pool. ACCESS_TIME An abstract number used to judge the first access time of the page. Querying ...
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/sys-statement-analysis.html
total_latency The total wait time of timed occurrences of the statement. max_latency The maximum single wait time of timed occurrences of the statement. avg_latency The average wait time per timed occurrence of the statement. lock_latency The total ...The statement_analysis and x$statement_analysis views have these columns: query The normalized statement ...
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 ...