PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/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.0/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.0/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.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-variables-info-table.html
The variables_info table shows, for each system variable, the source from which it was most recently set, and its range of values. VARIABLE_SOURCE The source from which the variable was most recently set: COMMAND_LINE The variable was set on the ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-null.html
When using DISTINCT, GROUP BY, or ORDER BY, all NULL values are regarded as equal. When using ORDER BY, NULL values are presented first, or last if you specify DESC to sort in descending order. The concept of the NULL value is a common source of ...