https://dev.mysql.com/mysql-cluster-options-variables.html
Time values can be optionally suffixed with h (hours), m (minutes), or s (seconds). This section provides information about MySQL server options, server and status variables that are specific to NDB Cluster. For general information on using these, ...
https://dev.mysql.com/select-optimization.html
Tuning these statements is a top priority, whether to achieve sub-second response times for dynamic web pages, or to chop hours off the time to generate huge overnight reports. Queries, in the form of SELECT statements, perform all the lookup ...
https://dev.mysql.com/data-dictionary-information-schema.html
In particular, for each INFORMATION_SCHEMA table that is a view on data dictionary tables: The server no longer must create a temporary table for each query of the INFORMATION_SCHEMA table. When the underlying data dictionary tables store values ...
https://dev.mysql.com/data-dictionary-usage-differences.html
Use of a data dictionary-enabled MySQL server entails some operational differences compared to a server that does not have a data dictionary: Previously, enabling the innodb_read_only system variable prevented creating and dropping tables only for ...
https://dev.mysql.com/server-system-variables.html
The default is 86400 seconds (24 hours), but the time period can be extended to as much as one year. The MySQL server maintains many system variables that configure its operation. System variables can be set at server startup using options on the ...
https://dev.mysql.com/host-cache-table.html
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS The number of errors caused by exceeding per-user connections-per-hour quotas. The host_cache table provides access to the contents of the host cache, which contains client host name and IP address ...
https://dev.mysql.com/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...
https://dev.mysql.com/point-in-time-recovery-times.html
If you did not detect the erroneous SQL statement that was entered until hours later, you will probably also want to recover the activity that occurred afterward. To indicate the start and end times for recovery, specify the --start-datetime and ...
https://dev.mysql.com/tables-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table ...
https://dev.mysql.com/mysql-cluster-replication-pitr.html
This backup should be updated regularly—perhaps even hourly—depending on your needs. Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the ...
