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-routines-table.html
DATETIME_PRECISION For stored function temporal return values, the fractional seconds precision. LAST_ALTERED The date and time when the routine was last modified. The ROUTINES table provides information about stored routines (stored procedures and ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-statistics-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. To update cached values at any time for a given table, use ANALYZE TABLE. If there are no cached statistics or statistics have ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-benefits.html
InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless of what was happening in the database at the time, you don't need to do anything special after restarting the database.
https://dev.mysql.com/doc/refman/9.7/en/innodb-buffer-pool-in-core-file.html
Large core files can be problematic for a number of reasons including the time it takes to write them, the amount of disk space they consume, and the challenges associated with transferring large files. Note Access to the data present in buffer pool ... A core file records the status and memory image of a running ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-buffer-pool.html
Per second averages provided in InnoDB Standard Monitor output are based on the elapsed time since InnoDB Standard Monitor output was last printed. If you see very low youngs/s values when there are no large scans occurring, consider reducing the ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-data-encryption.html
Only one keyring component or plugin should be enabled at a time. Each time the master encryption key is rotated, all tablespace keys in the MySQL instance are re-encrypted and saved back to their respective tablespace headers. InnoDB supports ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-deadlocks.html
If deadlock detection is disabled using the innodb_deadlock_detect variable, InnoDB relies on the innodb_lock_wait_timeout setting to roll back transactions in case of a deadlock. A deadlock is a situation in which multiple transactions are unable ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-error-handling.html
InnoDB sometimes rolls back only the statement that failed, other times it rolls back the entire transaction. A lock wait timeout causes InnoDB to roll back the current statement (the statement that was waiting for the lock and encountered the ...If ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-metrics-table.html
Note Because each counter adds a degree of runtime overhead, use counters conservatively on production servers to diagnose specific issues or monitor specific functionality. The TIME_ENABLED and TIME_ELAPSED values indicate when the counter was last ... The INNODB_METRICS table provides information about InnoDB performance and resource-related ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-online-ddl-space-requirements.html
If the operation takes a long time and concurrent DML modifies the table so much that the size of the temporary log file exceeds the value of innodb_online_alter_log_max_size, the online DDL operation fails with a DB_ONLINE_LOG_TOO_BIG error, and ...