PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/sys-host-summary.html
These views summarize statement activity, file I/O, and connections, grouped by host. The host_summary and x$host_summary views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying ...
https://dev.mysql.com/doc/refman/9.7/en/sys-innodb-lock-waits.html
These views summarize the InnoDB locks that transactions are waiting for. The innodb_lock_waits and x$innodb_lock_waits views have these columns: wait_started The time at which the lock wait started. wait_age How long the lock has been waited for, ...
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-thread-trx-info.html
Returns a JSON object containing information about a given thread. The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and ...
https://dev.mysql.com/doc/refman/9.7/en/sys-user-summary.html
These views summarize statement activity, file I/O, and connections, grouped by user. The user_summary and x$user_summary views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table ...
https://dev.mysql.com/doc/refman/9.7/en/sys-waits-by-host-by-latency.html
These views summarize wait events, grouped by host and event. By default, rows are sorted by host and descending total latency. The waits_by_host_by_latency and x$waits_by_host_by_latency views have these columns: host The host from which the ...
https://dev.mysql.com/doc/refman/9.7/en/sys-waits-by-user-by-latency.html
These views summarize wait events, grouped by user and event. By default, rows are sorted by user and descending total latency. The waits_by_user_by_latency and x$waits_by_user_by_latency views have these columns: user The user associated with the ...
https://dev.mysql.com/doc/refman/9.7/en/sys-waits-global-by-latency.html
The waits_global_by_latency and x$waits_global_by_latency views have these columns: events The event name. total_latency The total wait time of timed occurrences of the event. avg_latency The average wait time per timed occurrence of the event.
https://dev.mysql.com/doc/refman/9.7/en/telemetry-trace-configuration.html
Server Configuration Client Configuration Client Configuration Example Server Configuration The following are the server trace telemetry configuration variables: telemetry.trace_enabled System Variable telemetry.trace_enabled Scope Global Dynamic ...
https://dev.mysql.com/doc/refman/9.7/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.27, “CREATE TRIGGER Statement”, and Section 15.1.41, “DROP TRIGGER Statement”. Here is a simple example that associates a ...
https://dev.mysql.com/doc/refman/9.7/en/upgrade-binary-package.html
This section describes how to upgrade MySQL binary and package-based installations on Unix/Linux. In-Place Upgrade Logical Upgrade MySQL Cluster Upgrade In-Place Upgrade An in-place upgrade involves shutting down the old MySQL server, replacing the ...