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/partitioning-management-exchange.html
In addition to the ALTER, INSERT, and CREATE privileges usually required for ALTER TABLE statements, you must have the DROP privilege to perform ALTER TABLE ... In addition, both tables must use the same storage engine: mysql> CREATE TABLE es3 LIKE ...Table nt contains no foreign key references, and no other table has any foreign keys that refer to ...
https://dev.mysql.com/doc/refman/8.0/en/sys-create-synonym-db.html
Given a schema name, this procedure creates a synonym schema containing views that refer to all the tables and views in the original schema. This can be used, for example, to create a shorter name by which to refer to a schema with a long name ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-index.html
If a collection is large and queries on a specific field are common, then consider creating an index on a specific field inside a document. For example, the following query performs better with an index on the Population field: mysql-py> ... Indexes ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-collections-operations.html
In MySQL Shell, you can create new collections, get a list of the existing collections in a schema, and remove an existing collection from a schema. The following example creates a collection called flags in the world_x schema. For example, to drop ...Collection names are case-sensitive and each collection name must be ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-collections-operations.html
In MySQL Shell, you can create new collections, get a list of the existing collections in a schema, and remove an existing collection from a schema. The following example creates a collection called flags in the world_x schema. For example, to drop ...Collection names are case-sensitive and each collection name must be ...
https://dev.mysql.com/doc/refman/8.0/en/error-creating-innodb.html
Initialization Problems If something goes wrong when InnoDB attempts to initialize its tablespace or its log files, delete all files created by InnoDB: all ibdata files and all redo log files (#ib_redoN files in MySQL 8.0.30 and higher or ib_logfile ...Make sure mysqld has access rights to create files in those ... The troubleshooting steps for InnoDB I/O problems depend on when the problem occurs: during startup of the MySQL server, or during normal operations when a ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-using-management-client.html
In NDB 8.0.22 and later, START BACKUP supports the creation of encrypted backups using ENCRYPT PASSWORD=password. Cluster backups are created by default in the BACKUP subdirectory of the DataDir on each data node. The backup files created for a ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndbxfrm.html
The ndbxfrm utility, introduced in NDB 8.0.22, can be used to decompress, decrypt, and output information about files created by NDB Cluster that are compressed, encrypted, or both. The password must meet the requirements listed here: Uses any of ...Options --compress, -c Command-Line Format --compress Introduced 8.0.22-ndb-8.0.22 Compresses the input file, using the same compression method as is used for compressing NDB Cluster backups, and writes the output to an output ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-directories.html
When data is cloned, the following directories and files are created for internal use. *.#clone files: Temporary data files created on the recipient while data is removed from the recipient data directory and new data is cloned during a remote ...
https://dev.mysql.com/doc/refman/8.0/en/gis-mysql-specific-functions.html
MySQL provides a set of useful nonstandard functions for creating geometry values. GeomCollection() with no arguments is permitted as a way to create an empty geometry. GeometryCollection() with no arguments is permitted as a way to create an empty ...The functions described in this section are MySQL extensions to the OpenGIS ...