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. The .MYI file has two parts: the header information and the key values. So the next sub-sections will be "The .MYI Header" and "The .MYI Key Values". The .MYI Header A .MYI file begins ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/schema-advisor-ref.html
MySQL's mechanism for doing this is the AUTO_INCREMENT column attribute, which enables you to generate sequential numbers automatically. However, the range of numbers that can be generated is limited by the underlying data type. For example, the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-result-outputfile.html
Exported query results are in CSV, Parquet, or JSON (As of MySQL 9.3.1) format. The number of output files and size of individual files depends on the amount of data generated by the query. The names for the output files are auto-generated and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-log-statistics.html
The NDB management client's CLUSTERLOG STATISTICS command can provide a number of useful statistics in its output. Counters providing information about the state of the cluster are updated at 5-second reporting intervals by the transaction ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-issues.html
This section discusses known problems or issues when using replication with NDB Cluster. A loss of connection can occur either between the source cluster SQL node and the replica cluster SQL node, or between the source SQL node and the data nodes ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each stage. Invoke mysqlslap like this: mysqlslap [options] Some options such as --create or --query enable you to specify a string ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-diagnostics-report.html
If you intend to communicate with MySQL Enterprise Monitor support, it is strongly recommended you provide this report with your support request. Introduction To generate a diagnostic report file, select Diagnostics Report from the Help menu. The ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-upgrade.html
The util.checkForServerUpgrade() function is an upgrade checker utility that enables you to verify whether MySQL server instances are ready for upgrade. You can select a target MySQL Server release to which you plan to upgrade, ranging from the ...
https://dev.mysql.com/doc/internals/en/full-text-search.html
MySQL uses Ranking with Vector Spaces for ordinary full-text queries. Rank, also known as relevance rank, also known as relevance measure, is a number that tells us how good a match is. Vector Space, which MySQL sometimes calls "natural language", ...
https://dev.mysql.com/doc/internals/en/replication-correct.html
In addition to what we guarantee in (P-rpl-correct), we also guarantee correct replication in the following scenarios: (P-rpl-different-file-system-case-sensitivities) TODO: allowed differences in file system case sensitivity ...