PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-shell-userguide.html
The AdminAPI enables database administrators to work with InnoDB Cluster, which provides an integrated solution for high availability and scalability using InnoDB based MySQL databases, without requiring advanced MySQL expertise. The AdminAPI also ... MySQL Shell is an advanced client and code editor for MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-storage-engines.html
Partitioned InnoDB tables cannot have foreign key references, nor can they have columns referenced by foreign keys. InnoDB tables which have or which are referenced by foreign keys cannot be partitioned. InnoDB does not support the use of multiple ... The following limitations apply to the use of storage engines with user-defined partitioning of ...
https://dev.mysql.com/doc/refman/5.7/en/storage-requirements.html
InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage ...
https://dev.mysql.com/doc/refman/5.7/en/sys-metrics.html
The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the global_status table For InnoDB metrics: The NAME column of the INNODB_METRICS table For other metrics: A view-provided ... This view summarizes MySQL server metrics to show variable names, values, types, and whether they are ...
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions.html
For transactional storage engines such as InnoDB, storing an exact row count is problematic. InnoDB does not keep an internal count of rows in a table because concurrent transactions might “see” different numbers of rows at the same time. Prior ... This section describes aggregate functions that operate on sets of ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-foreign-keys.html
For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent rows. When performing foreign key checks, InnoDB sets shared row-level locks on child ...If ON UPDATE CASCADE or ON UPDATE SET NULL recurses to update the same table it has previously updated during the same cascade, it acts like ...
https://dev.mysql.com/doc/refman/5.7/en/backup-methods.html
(Ideally, the InnoDB tables should represent a substantial majority of the data.) Tables from other storage engines are copied using a warm backup mechanism. (See Section 7.4, “Using mysqldump for Backups”.) For InnoDB tables, it is possible to ...Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical backups of entire instances or selected databases, tables, or ...
https://dev.mysql.com/doc/refman/5.7/en/column-indexes.html
See Chapter 14, The InnoDB Storage Engine, and Chapter 15, Alternative Storage Engines. For example: CREATE TABLE test (blob_col BLOB, INDEX(blob_col(10))); Prefixes can be up to 1000 bytes long (767 bytes for InnoDB tables, unless you have ... The ...
https://dev.mysql.com/doc/refman/5.7/en/disk-issues.html
For information about optimizing an InnoDB configuration to improve I/O performance, see Section 8.5.8, “Optimizing InnoDB Disk I/O”. However, it is possible to place InnoDB data and log files on different physical disks. This section describes ...
https://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html
To start with an AUTO_INCREMENT value other than 1, set that value with CREATE TABLE or ALTER TABLE, like this: mysql> ALTER TABLE tbl AUTO_INCREMENT = 100; InnoDB Notes For information about AUTO_INCREMENT usage specific to InnoDB, see Section ...