Search Results
https://dev.mysql.com/doc/internals/en/the-myi-file.html
A .MYI file for a MyISAM table contains the table's indexes. In MySQL terminology, a "key" is something that you create with CREATE [UNIQUE] INDEX. Program files which read and write .MYI headers are in the ./myisam directory: mi_open.c has the ...
https://dev.mysql.com/doc/refman/8.4/en/backup-policy.html
This backup operation acquires a global read lock on all tables at the beginning of the dump (using FLUSH TABLES WITH READ LOCK). After that, the dump becomes lock-free and does not disturb reads and writes on the tables. It was assumed earlier that ...A full backup (a snapshot of the data at a point in time) can be done in MySQL with several ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-ddl-operations.html
Many DDL operations on tables and indexes (CREATE, ALTER, and DROP statements) can be performed online. Online DDL support for adding secondary indexes means that you can generally speed up the process of creating and loading a table and associated ...Use TRUNCATE TABLE to empty a table, not DELETE FROM ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-account.html
It is recommended that you never give any ACL privileges to the PRIVILEGE_CHECKS_USER account, including CREATE USER, CREATE ROLE, DROP ROLE, and GRANT OPTION, and do not permit the account to update the mysql.user table. Executing internal-use ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-4.html
ndbinfo Information Database: At table create and drop time, access of ndbinfo tables such as operations_per_fragment and memory_per_fragment sometimes examined data which was not valid. To fix this, during scans of these ndbinfo tables, we ignore ...(Bug #37049014) Bugs Fixed Microsoft Windows: Successive iterations of the sequence ndb_sign_keys --create-key followed by ndb_sign_keys --promote were unsuccessful on ... MySQL NDB Cluster 8.4.4 is a new LTS release of NDB ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-ml-model-metadata.html
For example, you can view the algorithm used to train the model, the columns in the training table, and values for the model explanation. When you run the ML_MODEL_IMPORT routine, the imported table has a model_metadata column that stores the ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-sysschema-statementanalysis-first-seen-category.html
Tmp Disk Tables The total number of internal on-disk temporary tables created by occurrences of the statement. Tmp Tables The total number of internal in-memory temporary tables created by occurrences of the statement. Tmp Tables Per Query Avg The ...Table 6.38 Sys Schema Statement Analysis by First Time Seen Metrics NameDescriptionAvg Latency The average wait time per timed occurrence of the ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-sysschema-statementanalysis-total-executions-category.html
Tmp Disk Tables The total number of internal on-disk temporary tables created by occurrences of the statement. Tmp Tables The total number of internal in-memory temporary tables created by occurrences of the statement. Tmp Tables Per Query Avg The ...Table 6.39 Sys Schema Statement Analysis by Total Executions Metrics NameDescriptionAvg Latency The average wait time per timed occurrence of the ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-sysschema-statementanalysis-total-latency-category.html
Tmp Disk Tables The total number of internal on-disk temporary tables created by occurrences of the statement. Tmp Tables The total number of internal in-memory temporary tables created by occurrences of the statement. Tmp Tables Per Query Avg The ...Table 6.40 Sys Schema Statement Analysis by Total Latency Metrics NameDescriptionAvg Latency The average wait time per timed occurrence of the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-database-objects.html
In addition, the maximum offset for a fixed-width column of an NDB table is 8188 bytes; attempting to create a table that violates this limitation fails with NDB error 851 Maximum offset for fixed-size columns exceeded. Some database objects such ...The maximum permitted size of any one row is 30000 ...