PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
At some point, you might upgrade to a higher version, so it is a good idea to have a look at future reserved words, too. Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as ...
https://dev.mysql.com/doc/refman/8.0/en/locking-service.html
For example, if the statement fails part way through and rolls back, locks acquired up to the point of failure still exist. MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable ...
https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engine.html
Shared-nothing architecture and multiple-host operation with no single point of failure, enabling 99.999% availability. The memory needed for one row in a MEMORY table is calculated using the following expression: ... The MEMORY storage engine ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
Table 18.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather than in the storage engine.) Yes Cluster database support No Clustered indexes No Compressed data Yes ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-using-management-client.html
At this point in the backup process the cluster has received and processed the backup request. Note At this point, the management client has not yet received a response from the cluster data nodes to this request, and the backup has not yet actually ... Before starting a backup, make sure that the cluster is properly configured for performing ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-basics.html
In addition, to provide a single point of configuration, all configuration data for the cluster as a whole is located in one configuration file. NDB Cluster logs events by category (startup, shutdown, errors, checkpoints, and so on), priority, and ... NDBCLUSTER (also known as NDB) is an in-memory storage engine offering high-availability and data-persistence ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-example-data.html
There are two key points to keep in mind: For a table to be replicated in the cluster, it must use the NDBCLUSTER storage engine. Note The information in this section applies to NDB Cluster running on both Unix and Windows platforms. Working with ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication.html
For information about performing point-in-time recovery with NDB Cluster and NDB Cluster Replication, see Section 25.7.9.2, “Point-In-Time Recovery Using NDB Cluster Replication”. NDB Cluster supports asynchronous replication, more usually ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to ...
https://dev.mysql.com/doc/refman/8.0/en/nested-loop-joins.html
At that point, no speed is gained by making it larger. 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 Algorithm A simple ...