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/innodb-undo-logs.html
InnoDB supports a maximum of 128 rollback segments, 32 of which are allocated to the temporary tablespace. Note It is possible to encounter a concurrent transaction limit error before reaching the number of concurrent read-write transactions that ...
https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html
The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be examined. If the slow query log is enabled and FILE is selected as an output destination, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-standard-monitor.html
Status This section shows the timestamp, the monitor name, and the number of seconds that per-second averages are based on. The number of seconds is the elapsed time between the current time and the last time InnoDB Monitor output was printed. This ... The Lock Monitor is the same as the Standard Monitor except that it includes additional lock ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-midpoint_insertion.html
The configuration parameter innodb_old_blocks_time specifies the time window (in milliseconds) after the first access to a page during which it can be accessed without being moved to the front (most-recently used end) of the LRU list. The pages are ... Rather than using a strict LRU algorithm, InnoDB uses a technique to minimize the amount of data that is brought into the buffer pool and never accessed ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-functions.html
MySQL Enterprise Encryption functions have these general characteristics: For arguments of the wrong type or an incorrect number of arguments, each function returns an error. (OpenSSL imposes its own key-length limits, and server administrators can ...If the arguments are not suitable to permit a function to perform the requested operation, it returns NULL or 0 as ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup-using-management-client.html
If an existing backup_id value is used, the backup fails with the error Backup failed: file already exists. Execute this command: ndb_mgm> ABORT BACKUP backup_id The number backup_id is the identifier of the backup that was included in the response ... Before starting a backup, make sure that the cluster is properly configured for performing ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-secondary-indexes.html
A secondary index defined on a virtual column is sometimes referred to as a “virtual index”. If a secondary index is not defined on a virtual column, there are additional costs for reads, as virtual column values must be computed each time the ...A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated ...If the index is a covering index (one that includes all the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-analyze-table-complexity.html
Using these parameters, an approximate formula for estimating ANALYZE TABLE complexity would be: The value of innodb_stats_persistent_sample_pages * number of indexed columns in a table * the number of partitions Typically, the greater the resulting ... ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by ...
https://dev.mysql.com/doc/refman/5.7/en/using-system-variables.html
To restrict the maximum value to which a system variable can be set at runtime with the SET statement, specify this maximum by using an option of the form --maximum-var_name=value at server startup. For example, to prevent the value of ...The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-multi-versioning.html
This removal operation is called a purge, and it is quite fast, usually taking the same order of time as the SQL statement that did the deletion. Multi-Versioning and Secondary Indexes InnoDB multiversion concurrency control (MVCC) treats secondary ...It keeps information about old versions of changed rows to support transactional features such as concurrency and ...