PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysqlslap.html
Invoke mysqlslap like this: mysqlslap [options] Some options such as --create or --query enable you to specify a string containing an SQL statement or a file containing statements. mysqlslap runs in three stages: Create schema, table, and optionally ... mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-add-node-example.html
You can do this by issuing a CREATE NODEGROUP command in the cluster management client. ALGORITHM=INPLACE, REORGANIZE PARTITION does not work on tables that were created with the MAX_ROWS option. REORGANIZE PARTITION statements for NDBCLUSTER tables ... In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having 2 data nodes in a single node group and concluding with a cluster having 4 data nodes in 2 node ...
https://dev.mysql.com/doc/refman/8.0/en/archive-storage-engine.html
The ARCHIVE engine also supports the AUTO_INCREMENT table option in CREATE TABLE statements to specify the initial sequence value for a new table or reset the sequence value for an existing table, respectively. When you create an ARCHIVE table, the ... The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
The default setting (which is the maximum permitted sequence number for a transaction in a GTID) means that state transfer from a donor's binary log is virtually always attempted rather than cloning. Group members that are still online can ... This ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
To specify explicitly that you want a MyISAM table, indicate that with an ENGINE table option: CREATE TABLE t (i INT) ENGINE = MYISAM; In MySQL 8.0, it is normally necessary to use ENGINE to specify the MyISAM storage engine because InnoDB is the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-logs-cluster-log.html
Keep GCI = current_gci oldest restorable GCI = old_gci The local checkpoint having sequence ID lcp has been started on node node_id. LocalCheckpointStarted Checkpoint 7 INFO Node node_id: Local checkpoint lcp completed The local checkpoint having ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-system-variables.html
See the description of that variable for details, as well as for considerations to take into account if you create the directory manually. At plugin startup, if the value assigned to keyring_aws_data_file specifies a file that does not exist, the ...
https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engine.html
The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memory. The following sections illustrate the syntax for creating both kinds of indexes. Characteristics of MEMORY Tables The MEMORY ...Because the data is vulnerable to crashes, hardware issues, or power outages, only use these tables as temporary work areas or read-only caches for data pulled from other ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-range-list.html
If you now execute a SHOW CREATE TABLE statement, you can see how the partitioning makeup of the table has been changed: mysql> SHOW CREATE TABLE tr\G *************************** 1. Another solution might appear to be to make a copy of the table ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-monitoring.html
Performance_schema_xxx_instances_lost indicates how many instances of object type xxx could not be created. If the server cannot create a given instrumented mutex instance, it increments Performance_schema_mutex_instances_lost. The server allocates ...Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many instruments of type xxx could not be ...