https://dev.mysql.com/optimizing-innodb-transaction-management.html
For example, an application might encounter performance issues if it commits thousands of times per second, and different performance issues if it commits only every 2-3 hours. To optimize InnoDB transaction processing, find the ideal balance ...
https://dev.mysql.com/mysql-innodb-cluster-production-deployment.html
Depending on the amount of data on the cluster this might take from a few seconds to several hours. When working in a production environment, the MySQL server instances which make up an InnoDB cluster run on multiple host machines as part of a ...
https://dev.mysql.com/mysql-installer-catalog-dashboard.html
Product Catalog MySQL Installer Dashboard Locating Products to Install This section describes the MySQL Installer product catalog and the dashboard. The product catalog stores the complete list of released MySQL products for Microsoft Windows that ...
https://dev.mysql.com/innodb-online-ddl.html
Benefits of this feature include: Improved responsiveness and availability in busy production environments, where making a table unavailable for minutes or hours is not practical. The online DDL feature provides support for instant and in-place ...
https://dev.mysql.com/sys-format-time.html
Depending on the size of the value, the units part is ps (nanoseconds), ns (nanoseconds), us (microseconds), ms (milliseconds), s (seconds), m (minutes), h (hours), d (days), or w (weeks). Note As of MySQL 8.0.16, format_time() is deprecated and ...
https://dev.mysql.com/partitioning-limitations-functions.html
This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning expressions. Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the ...
https://dev.mysql.com/window-functions-usage.html
For example, if a table contains a TIMESTAMP column named ts, standard SQL permits PARTITION BY ts but not PARTITION BY HOUR(ts), whereas MySQL permits both. However, whereas an aggregate operation groups query rows into a single result row, a ...
https://dev.mysql.com/gone-away.html
By default, the server closes the connection after eight hours if nothing has happened. This section also covers the related Lost connection to server during query error. The most common reason for the MySQL server has gone away error is that the ...
https://dev.mysql.com/performance-schema-functions.html
As of MySQL 8.0.16, MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored functions. The built-in functions can be invoked in any schema ...
https://dev.mysql.com/group-replication-responses-failure-expel.html
To avoid unnecessary expulsions on slower networks, or in the case of expected transient network failures or machine slowdowns, you can specify a timeout value greater than zero, up to a maximum of 3600 seconds (1 hour). You can use the ...
