Search Results
https://dev.mysql.com/doc/refman/8.4/en/myisam-storage-engine.html
There is no significant speed penalty for storing data low byte first; the bytes in a table row normally are unaligned and it takes little more processing to read an unaligned byte in order than in reverse order. When rows are inserted in sorted ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-backup-using-management-client.html
If both a wait_option and a snapshot_option are used, they may be specified in either order. The management client acknowledges the abort request with Abort of backup backup_id ordered. (The remaining nodes report that the backup was aborted due to ... Before starting a backup, make sure that the cluster is properly configured for performing ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-disk-data-objects.html
A log file group, a tablespace, and any Disk Data tables using these must be created in a particular order. NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts as containers for other Disk Data objects. A ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-transactions.html
Because the MySQL server creates a shadowing ordered index for every unique index created in NDB, this lets the ordered index be read instead, and avoids unique index access locking. Reading via an ordered index makes less efficient use of resources ... A number of limitations exist in NDB Cluster with regard to the handling of ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-log-statistics.html
This does not include range scans (that is, ordered index scans). This is the number of ordered index scans using this TC as the transaction coordinator that were started in the last reporting interval. Unique key operations may result in multiple ... The NDB management client's CLUSTERLOG STATISTICS command can provide a number of useful statistics in its ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-config-editor.html
For information about the order in which option files are used, see Section 6.2.2.2, “Using Option Files”. mysql_config_editor adds login paths to the login path file in the order you create them, so you should create more general login paths ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-bulk-data-loading.html
When performing bulk inserts, it is faster to insert rows in PRIMARY KEY order. InnoDB tables use a clustered index, which makes it relatively fast to use data in the order of the PRIMARY KEY. Performing bulk inserts in PRIMARY KEY order is ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-queries-myisam.html
This is a good way to make queries faster if you have a unique index from which you want to read all rows in order according to the index. Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations.html
ORDER BY column statement run against a partitioned table causes ordering of rows only within each partition. This section discusses current restrictions and limitations on MySQL partitioning support. The following constructs are not permitted in ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-quick-start.html
This section briefly introduces the Performance Schema with examples that show how to use it. For additional examples, see Section 29.19, “Using the Performance Schema to Diagnose Problems”. To enable or disable it explicitly, start the server ...