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/identifier-mapping.html
If you are using tablespaces with InnoDB, then the specific tablespace files you create are used instead. There is a correspondence between database and table identifiers and names in the file system. For the basic structure, MySQL represents each ...
https://dev.mysql.com/doc/refman/5.7/en/index-merge-optimization.html
AND key_partN = constN Any range condition over the primary key of an InnoDB table. If one of the merged conditions is a condition over the primary key of an InnoDB table, it is not used for row retrieval, but is used to filter out rows retrieved ...
https://dev.mysql.com/doc/refman/5.7/en/internal-locking.html
Row-Level Locking Table-Level Locking Choosing the Type of Locking Row-Level Locking MySQL uses row-level locking for InnoDB tables to support simultaneous write access by multiple sessions, making them suitable for multi-user, highly concurrent, ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-system-variables.html
For example, InnoDB uses the file to store the master key used to decrypt the data in tables that use InnoDB tablespace encryption; see Section 14.14, “InnoDB Data-at-Rest Encryption”. These variables are unavailable unless the appropriate ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-native.html
2013-09-24T13:03:09.048353Z 0 [Note] InnoDB: 5.7.44 started; log sequence number 1566036 2013-09-24T13:03:10.057269Z 0 [Note] InnoDB: Starting shutdown... 2013-09-24T13:03:10.857032Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1566036 * ... Many Linux distributions include a version of the MySQL server, client tools, and development components in their native software repositories and can be installed with the platforms' standard package management ...
https://dev.mysql.com/doc/refman/5.7/en/mrr-optimization.html
The following scenarios illustrate when MRR optimization can be advantageous: Scenario A: MRR can be used for InnoDB and MyISAM tables for index range scans and equi-join operations. InnoDB and MyISAM do not use MRR if full table rows need not be ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-install-db.html
It initializes the system tablespace and related data structures needed to manage InnoDB tables. For example: bin/mysql_install_db --user=mysql \ --basedir=/opt/mysql/mysql \ --datadir=/opt/mysql/mysql/data Note After mysql_install_db sets up the ...
https://dev.mysql.com/doc/refman/5.7/en/table-size-limit.html
You are using InnoDB tables and have run out of room in an InnoDB tablespace file. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. For ...
https://dev.mysql.com/doc/refman/5.7/en/using-system-variables.html
For example, to prevent the value of innodb_log_file_size from being increased to more than 32MB at runtime, use the option --maximum-innodb-log-file-size=32M. | innodb_autoextend_increment | 8 | | innodb_buffer_pool_size | 8388608 | | ... The MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-setting.html
If you are using InnoDB tables and the transaction isolation level is READ COMMITTED or READ UNCOMMITTED, only row-based logging can be used. It is possible to change the logging format to STATEMENT, but doing so at runtime leads very rapidly to ...