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/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). Statements that affect mysql database tables are written to the binary log ...This pertains to statements such as INSERT, UPDATE, DELETE, REPLACE, DO, LOAD DATA, SELECT, and TRUNCATE ...
https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html
Supported table DDL statements include CREATE, ALTER, and DROP statements for databases, tablespaces, tables, and indexes, and the TRUNCATE TABLE statement. DROP DATABASE is atomic if all tables use a storage engine which supports atomic DDL. If ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-database-objects.html
Some database objects such as tables and indexes have different limitations when using the NDBCLUSTER storage engine: Number of database objects. The maximum number of all NDB database objects in a single NDB Cluster—including databases, tables, ...The maximum number of attributes (that is, columns and indexes) that can belong to a given table is ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-database-structure.html
In your role as a database designer, look for the most efficient way to organize your schemas, tables, and columns. Starting with an efficient database design makes it easier for team members to write high-performing application code, and makes the ...As when tuning application code, you minimize I/O, keep related items together, and plan ahead so that performance stays high as the data volume ...
https://dev.mysql.com/doc/refman/8.0/en/database-count-limit.html
The underlying file system may have a limit on the number of directories. The underlying file system may have a limit on the number of files that represent tables.
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-copying-database.html
$> mysqldump db1 > dump.sql $> mysqladmin create db2 $> mysql db2 < dump.sql Do not use --databases on the mysqldump command line because that causes USE db1 to be included in the dump file, which overrides the effect of naming db2 on the mysql ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
This enhancement aligns the syntax of these statements more closely with that of CREATE DATABASE, CREATE TABLE, CREATE USER, and CREATE EVENT (all of which already support IF NOT EXISTS), and acts to complement the IF EXISTS option supported by DROP ...MySQL now incorporates a transactional data dictionary that stores information about database ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-collections-operations.html
mysql-js> db.getCollections() [ <Collection:countryinfo>, <Collection:flags> ] Drop a Collection To drop an existing collection from a schema, use the db object's dropCollection() method. For example, to drop the flags collection from the current ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-indexes-create.html
mysql-js> db.countryinfo.createIndex("name", {"fields": [{"field": "$.Name", "type": "TEXT(40)", "required": true}], "unique": true}) Drop an Index To drop an index, pass the name of the index to drop to the dropIndex() method. For example, you can ... Indexes are used to find documents with specific field values ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-collections-operations.html
mysql-py> db.get_collections() [ <Collection:countryinfo>, <Collection:flags> ] Drop a Collection To drop an existing collection from a schema, use the db object's drop_collection() method. For example, to drop the flags collection from the current ... 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 ...