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/information-schema-innodb-cmp-table.html
COMPRESS_OPS The number of times a B-tree page of size PAGE_SIZE has been compressed. COMPRESS_OPS_OK The number of times a B-tree page of size PAGE_SIZE has been successfully compressed. COMPRESS_TIME The total time in seconds used for attempts to ... The INNODB_CMP and INNODB_CMP_RESET tables provide status information on operations related to compressed InnoDB ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-processlist-table.html
TIME The time in seconds that the thread has been in its current state. For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. The following statements ... Important INFORMATION_SCHEMA.PROCESSLIST is deprecated and subject to removal in a future MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/insert-optimization.html
You can use the following methods to speed up inserts: If you are inserting many rows from the same client at the same time, use INSERT statements with multiple VALUES lists to insert several rows at a time. This is considerably faster (many times ... To optimize insert speed, combine many small operations into a single large ...
https://dev.mysql.com/doc/refman/9.7/en/json-search-functions.html
For escape character handling, a difference from the LIKE behavior is that the escape character for JSON_SEARCH() must evaluate to a constant at compile time, not just at execution time. For example, if JSON_SEARCH() is used in a prepared statement ... The functions in this section perform search or comparison operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-oci-component.html
Note Only one keyring component or plugin should be enabled at a time. The encryption endpoint is vault specific and Oracle Cloud Infrastructure assigns it at vault-creation time. The key management endpoint is vault specific and Oracle Cloud ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-okv-plugin.html
Connect again to the Oracle Key Vault server, this time without logging in. There is a 20-second wait for each connection attempt, so the presence of a long list of invalid servers can significantly affect the keyring_okv plugin’s connection time ... Note The keyring_okv plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/9.7/en/mle-component-options-variables.html
mle_session_resets The number of times MLE sessions have been cleared using the mle_session_reset() function. mle_sessions_max Maximum number of MLE sessions active at any one time since the MLE component became active. An MLE stored program is ...
https://dev.mysql.com/doc/refman/9.7/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when accessing individual rows, because you only have to uncompress exactly one row. MySQL uses mmap() ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-logs-cluster-log.html
LCPFragmentCompleted Checkpoint 11 INFO Node node_id: ACC Blocked num_1 and TUP Blocked num_2 times last second Undo logging is blocked because the log buffer is close to overflowing. Its state at the time of failure is described by an arbitration ... The following table lists the most common NDB cluster log ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-threadstat.html
The values of the os_ru_utime, os_ru_stime, os_ru_minflt, os_ru_majflt, os_ru_nvcsw, and os_ru_nivcsw columns are obtained using the system getrusage() call, or the equivalent. Since this table contains counts taken at a given point in time, for ...