PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.3Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/memory-use.html
Temporary tables with a large row length (calculated as the sum of all column lengths) or that contain BLOB columns are stored on disk. The table_definition_cache system variable defines the number of table definitions that can be stored in the ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk.html
The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). You can also use the CHECK TABLE and ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-transactions.html
NDBCLUSTER stores only part of a column value that uses any of MySQL's BLOB or TEXT data types in the table visible to MySQL; the remainder of the BLOB or TEXT is stored in a separate internal table that is not accessible to MySQL. A number of ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-mgmd.html
You can do this by starting the ndb_mgmd process with any one of the following options: --config-cache=0 --config-cache=FALSE --config-cache=OFF --skip-config-cache Using one of the options just listed is effective only if the management server has ... The management server is the process that reads the cluster configuration file and distributes this information to all nodes in the cluster that request ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-security-mysql-privileges.html
As with any other MySQL Server, user and privilege information is stored in the mysql system database. If you wish, you can enable synchronization of MySQL users and privileges across NDB Cluster SQL nodes; see Section 25.6.13, “Privilege ... In ...
https://dev.mysql.com/doc/refman/8.0/en/nested-loop-joins.html
Only columns of interest to a join are stored in its join buffer, not whole rows. MySQL executes joins between tables using a nested-loop algorithm or variations on it. Nested-Loop Join Algorithm Block Nested-Loop Join Algorithm Nested-Loop Join ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-statistics.html
The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution plans. HISTOGRAM: A JSON value describing the column statistics, stored as a histogram. Column ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-diskio.html
Store system tablespace files on Fusion-io devices You can take advantage of a doublewrite buffer-related I/O optimization by storing the files that contain the doublewrite storage area on Fusion-io devices that support atomic writes. If you follow ...
https://dev.mysql.com/doc/refman/8.0/en/order-by-optimization.html
Take into account that the size of column values stored in the sort buffer is affected by the max_sort_length system variable value. For example, if tuples store values of long string columns and you increase the value of max_sort_length, the size ... This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort operation used when an index cannot be used, and execution plan information available from the optimizer about ORDER ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-hash.html
In other words, for a given expression expr, the partition in which the record is stored is partition number N, where N = MOD(expr, num). Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of ...