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/performance-schema-threads-table.html
row *************************** THREAD_ID: 1 NAME: thread/sql/main TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: mysql PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 418094 PROCESSLIST_STATE: NULL ... The threads table contains a row for each server ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-transaction-tables.html
For additional information about configuring event collection, see Section 29.3, “Performance Schema Startup Configuration”, and Section 29.4, “Performance Schema Runtime Configuration”. Within the event hierarchy, wait events nest within ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/en/srjs-session-info.html
It also resets the session time zone, so that subsequent calls to JavaScript stored routines use the time zone set most recently in the session. Calling this function with no arguments continues to work as it did in previous versions of MySQL, ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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 ...