PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/myisam-optimization.html
To coalesce fragmented rows and eliminate wasted space that results from deleting or updating rows, run myisamchk in recovery mode: $> myisamchk -r tbl_name You can optimize a table in the same way by using the OPTIMIZE TABLE SQL statement.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-multiple-nodes.html
The following are issues relating to the use of multiple MySQL servers as NDB Cluster SQL nodes, and are specific to the NDBCLUSTER storage engine: Stored programs not distributed. Stored procedures, stored functions, triggers, and scheduled events ...A LOCK TABLES statement or GET_LOCK() call works only for the SQL node on which the lock is issued; no other SQL node in the cluster “sees” this ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-resolved.html
A number of limitations and related issues that existed in earlier versions of NDB Cluster have been resolved in NDB 8.0. These are described briefly in the following list: Database and table names. In NDB 7.6 and earlier, when using the NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-unsupported.html
Statements referencing such features, even if effectively ignored by NDB, must be syntactically and otherwise valid. A statement containing an index prefix, and creating or modifying an NDB table, must still be syntactically valid. Replication using ... A number of features supported by other storage engines are not supported for NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-resources.html
This table provides information about data node resource availability and usage. In NDB 8.0.19 and later this can be controlled using the TransactionMemory configuration parameter. Sum of DataMemory and IndexMemory, plus 8 pages of 32 KB each if ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-add-node-remarks.html
This section provides general information about the behavior of and current limitations in adding NDB Cluster nodes online. The ability to add new nodes online includes a means to reorganize NDBCLUSTER table data and indexes so that they are ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-perror.html
This includes the error message, the type of error, and whether the error is permanent or temporary. To make substitution easier in scripts and other applications that might depend on perror for obtaining NDB error information, ndb_perror supports ... ndb_perror shows information about an NDB error, given its error ...
https://dev.mysql.com/doc/refman/8.0/en/number-literals.html
Number literals include exact-value (integer and DECIMAL) literals and approximate-value (floating-point) literals. Numbers represented in scientific notation with a mantissa and exponent are approximate-value numbers. Approximate-value numeric ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-ddl-operations.html
Many DDL operations on tables and indexes (CREATE, ALTER, and DROP statements) can be performed online. Online DDL support for adding secondary indexes means that you can generally speed up the process of creating and loading a table and associated ...Use TRUNCATE TABLE to empty a table, not DELETE FROM ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-maintenance.html
A number of table and partition maintenance tasks can be carried out on partitioned tables using SQL statements intended for such purposes. Table maintenance of partitioned tables can be accomplished using the statements CHECK TABLE, OPTIMIZE ...