PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/innodb-performance-schema.html
The Summary tables, which provide aggregated information for terminated events over time. This section provides a brief introduction to InnoDB integration with Performance Schema. For comprehensive Performance Schema documentation, see Chapter 29, ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-redo-log.html
InnoDB tries to maintain 32 redo log files in total, with each file equal in size to 1/32 * innodb_redo_log_capacity; however, file sizes may differ for a time after modifying the innodb_redo_log_capacity setting. Redo Log Archiving Backup utilities ... The redo log is a disk-based data structure used during crash recovery to correct data written by incomplete ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-system-tablespace.html
For example, this tablespace has one auto-extending data file: innodb_data_home_dir = innodb_data_file_path = /ibdata/ibdata1:10M:autoextend Suppose that the data file has grown to 988MB over time. Then initialize the server for the first time by ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-temporary-tablespace.html
Because the pool of session temporary tablespaces is recreated each time the server is started, space IDs for session temporary tablespaces are not persisted when the server is shut down, and may be reused. The global temporary tablespace is removed ... InnoDB uses session temporary tablespaces and a global temporary ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-transaction-isolation-levels.html
Isolation is the I in the acronym ACID; the isolation level is the setting that fine-tunes the balance between performance and reliability, consistency, and reproducibility of results when multiple transactions are making changes and performing ...
https://dev.mysql.com/doc/refman/9.7/en/insert-on-duplicate.html
If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row occurs. If column b is also unique, the INSERT is equivalent to this UPDATE statement ...
https://dev.mysql.com/doc/refman/9.7/en/ipv6-brokers.html
Note that if the broker allocates dynamic addresses, the address provided for your system might change the next time you connect to the broker. For example: userid=gogouser passwd=gogopass Start gogoc: $> /etc/init.d/gogoc start To start gogoc each ... If you do not have a public IPv6 address that enables your system to communicate over IPv6 outside your local network, you can obtain one from an IPv6 ...
https://dev.mysql.com/doc/refman/9.7/en/ipv6-system-support.html
As a simple test to determine whether that is true, try this command: $> ping6 ::1 16 bytes from ::1, icmp_seq=0 hlim=64 time=0.171 ms 16 bytes from ::1, icmp_seq=1 hlim=64 time=0.077 ms ... Before MySQL Server can accept IPv6 connections, the ...
https://dev.mysql.com/doc/refman/9.7/en/json-attribute-functions.html
The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...
https://dev.mysql.com/doc/refman/9.7/en/json-table-functions.html
This section contains information about JSON functions that convert JSON data to tabular data. JSON_TABLE(expr, path COLUMNS (column_list) [AS] alias) Extracts data from a JSON document and returns it as a relational table having the specified ...