PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-operations-per-fragment.html
This currently has the following formats: Base table: DbName/def/TblName BLOB table: DbName/def/NDB$BLOB_BaseTblId_ColNo Ordered index: sys/def/BaseTblId/IndexName Unique index: sys/def/BaseTblId/IndexName$unique The $unique suffix shown for unique ... The operations_per_fragment table provides information about the operations performed on individual fragments and fragment replicas, as well as about some of the results from these ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-add-node-basics.html
Execute one or more CREATE NODEGROUP commands in the NDB Cluster management client to create the new node group or node groups to which the new data nodes belong. Exception: For tables created using the MAX_ROWS option, this statement does not work; ... In this section, we list the basic steps required to add new data nodes to an NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-config-editor.html
Invoke mysql_config_editor like this: mysql_config_editor [program_options] command [command_options] If the login path file does not exist, mysql_config_editor creates it. mysql_config_editor adds login paths to the login path file in the order you ... The mysql_config_editor utility enables you to store authentication credentials in an obfuscated login path file named ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-statistics.html
The table is persistent so that column statistics need not be created each time the server starts. sampling-rate: A number between 0.0 and 1.0 indicating the fraction of data that was sampled to create the histogram. This histogram type is created ... The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-bulk-data-loading.html
COMMIT; The mysqldump option --opt creates dump files that are fast to import into an InnoDB table, even without wrapping them with the SET autocommit and COMMIT statements. For optimal performance when loading data into an InnoDB FULLTEXT index, ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns-list.html
See Section 15.1.20, “CREATE TABLE Statement”, for additional information about PARTITION BY LIST COLUMNS() syntax. This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-hash.html
To partition a table using HASH partitioning, it is necessary to append to the CREATE TABLE statement a PARTITION BY HASH (expr) clause, where expr is an expression that returns an integer. Partitioning by HASH is used primarily to ensure an even ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-user-defined-functions-table.html
The user_defined_functions table contains a row for each loadable function registered automatically by a component or plugin, or manually by a CREATE FUNCTION statement. The value is NULL if the function was registered by a CREATE FUNCTION ...For ...
https://dev.mysql.com/doc/refman/8.0/en/repair-table.html
EXTENDED If you use the EXTENDED option, MySQL creates the index row by row instead of creating one index at a time with sorting. This option tells MySQL not to trust the information in the .MYI file header and to re-create it using information from ...[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-current-user.html
In some cases, such as statements that change passwords, the function reference is expanded before it is written to the binary log, so that the statement includes the user name. For all other cases, the name of the current user on the source is ...