Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-files-backed-up-summary.html
The following table shows the different types of files that are included in a single-file backup image or a directory backup. Table 1.1 Types of Files in a Backup File Name, Pattern, or Extension Relation to Original Data Files Notes ibdata* The ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-key-caches.html
This feature enables you to assign different table indexes to different key caches. Where there are multiple key caches, the server must know which cache to use when processing queries for a given MyISAM table. By default, all MyISAM table indexes ... Note As of MySQL 8.4, the compound-part structured-variable syntax discussed here for referring to multiple MyISAM key caches is ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-optimization.html
The most general way to satisfy a GROUP BY clause is to scan the whole table and create a new temporary table where all rows from each group are consecutive, and then use this temporary table to discover groups and apply aggregate functions (if ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-query-time-estimation.html
To view the current MySQL HeatWave query history, query the performance_schema.rpd_query_stats table: mysql> SELECT query_id, LEFT(query_text,160) FROM performance_schema.rpd_query_stats; *************************** 1. row ... Auto Query Time ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-crash-recovery.html
If your tables become corrupted frequently, you should try to find the reason why. For an explanation of how MyISAM tables can become corrupted, see Section 18.2.4, “MyISAM Table Problems”. If you run mysqld with external locking disabled (which ... This section describes how to check for and deal with data corruption in MySQL ...
https://dev.mysql.com/doc/refman/8.4/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. When the optimizer can make use of partition pruning in performing this query, execution of the query ... The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan partitions where there can be no matching ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrument-naming.html
Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm wait/synch/cond/sql/BINLOG::update_cond wait/synch/mutex/mysys/BITMAP_mutex wait/synch/mutex/sql/LOCK_delete ... An ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-mixed.html
When one or more tables with AUTO_INCREMENT columns are updated and a trigger or stored function is invoked. (Bug #28086) When one of the tables involved is a log table in the mysql database. In MySQL 8.4, operations on temporary tables are not ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/dynxml-auto-changelog-difflist-mysqld-8.4.0-ndb-8.4.0.html
(Bug #35997178) Functionality Added or Changed ndbinfo Information Database: Added the transporter_details table to the ndbinfo information database. This table is similar to the transporters table, but provides information about individual ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndb-api-statistics.html
Such actions include starting and closing (or aborting) transactions; primary key and unique key operations; table, range, and pruned scans; threads blocked while waiting for the completion of various operations; and data and events sent and ... A ...