PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
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. This ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup.html
NDB 8.0 makes it possible to create backups using multiple LDMs to achieve parallelism on the data nodes. The next few sections describe how to prepare for and then to create an NDB Cluster backup using the functionality for this purpose found in ...To distinguish this type of backup from a backup made using mysqldump, we sometimes refer to it as a “native” NDB Cluster ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-arbitrator-validity-summary.html
The arbitrator_validity_summary table provides a composite view of the arbitrator with regard to the cluster's data nodes. If it has more than 1 row for longer than a few moments, then either not all nodes are connected to the arbitrator, or all ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-diskstat.html
The diskstat table provides information about writes to Disk Data tablespaces during the past 1 second.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-diskstats-1sec.html
The diskstats_1sec table provides information about writes to Disk Data tablespaces over the past 20 seconds.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-table-distribution-status.html
The table_distribution_status table provides information about the progress of table distribution for NDB tables. is_reorg_ongoing Whether the table is currently being reorganized (1 if true) .
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-threads.html
The threads table provides information about threads running in the NDB kernel.
https://dev.mysql.com/doc/refman/8.0/en/mysql-enterprise-encryption.html
These functions enable Enterprise applications to perform the following operations: Implement added data protection using public-key asymmetric cryptography Create public and private keys and digital signatures Perform asymmetric encryption and ...
https://dev.mysql.com/doc/refman/8.0/en/number-literals.html
The DECIMAL data type is a fixed-point type and calculations are exact. The FLOAT and DOUBLE data types are floating-point types and calculations are approximate. In MySQL, the DECIMAL type has several synonyms: NUMERIC, DEC, FIXED. An integer may ... Number literals include exact-value (integer and DECIMAL) literals and approximate-value (floating-point) ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-issues.html
In many cases, MySQL can calculate the best possible query plan, but sometimes MySQL does not have enough information about the data at hand and has to make “educated” guesses about the data. MySQL uses a cost-based optimizer to determine the ...