PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.8Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-threads-monitor-worker.html
The message lists the following statistics for the relevant replication channel, or the default replication channel (which is not named): Seconds elapsed The difference in seconds between the current time and the last time this information was ...
https://dev.mysql.com/doc/refman/8.0/en/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. Isolate and tune any part of the query, such as a function call, that ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
Each client can change its session sql_mode value at any time. It does not apply to TIMESTAMP columns, which always require a valid date. Because storage engines can be pluggable at runtime, unavailable engines are treated the same way: With ... The ...
https://dev.mysql.com/doc/refman/8.0/en/sys-metrics.html
This view summarizes MySQL server metrics to show variable names, values, types, and whether they are enabled. The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-sorting.html
total_latency The total wait time of timed occurrences of the statement. last_seen The time at which the statement was most recently seen. The statements_with_sorting and x$statements_with_sorting views have these columns: query The normalized ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-temp-tables.html
total_latency The total wait time of timed occurrences of the statement. last_seen The time at which the statement was most recently seen. These views list normalized statements that have used temporary tables. By default, rows are sorted by ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-tuning.html
Of chief importance is the number of thread groups in the thread pool, which can be set on server startup using the --thread-pool-size option; this cannot be changed at runtime. The recommendation initial setting for this system variable is the ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-initialization.html
TIMESTAMP and DATETIME columns can be automatically initialized and updated to the current date and time (that is, the current timestamp). For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, ...An auto-updated column remains unchanged if all other columns are set to their current ...
https://dev.mysql.com/doc/refman/8.0/en/user-resources.html
To establish resource limits for an account at account-creation time, use the CREATE USER statement. For example, to remove the limit on how many times per hour francis can connect, use this statement: mysql> ALTER USER 'francis'@'localhost' WITH ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-connection-compression.html
The benefits of compression therefore occur primarily when there is low network bandwidth, network transfer time dominates the cost of compression and decompression operations, and result sets are large. As the compression level for an algorithm ...