MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 851 to 860 of 869 total results

26.4.3.39 The statements_with_sorting and x$statements_with_sorting Views

https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-sorting.html

The statements_with_sorting and x$statements_with_sorting views have these columns: query The normalized statement string. db The default database for the statement, or NULL if there is none. total_latency The total wait time of timed occurrences of ...

26.4.3.40 The statements_with_temp_tables and x$statements_with_temp_tables Views

https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-temp-tables.html

The statements_with_temp_tables and x$statements_with_temp_tables views have these columns: query The normalized statement string. These views list normalized statements that have used temporary tables. By default, rows are sorted by descending ...

26.4.2.2 The sys_config_insert_set_user Trigger

https://dev.mysql.com/doc/refman/5.7/en/sys-sys-config-insert-set-user.html

For rows added to the sys_config table by INSERT statements, the sys_config_insert_set_user trigger sets the set_by column to the current user.

26.4.2.1 The sys_config Table

https://dev.mysql.com/doc/refman/5.7/en/sys-sys-config.html

The sys_config table has these columns: variable The configuration option name. This table contains sys schema configuration options, one row per option. Configuration changes made by updating this table persist across client sessions and server ...

26.4.3.47 The version View

https://dev.mysql.com/doc/refman/5.7/en/sys-version.html

The version view has these columns: sys_version The sys schema version. This view provides the current sys schema and MySQL server versions. Note As of MySQL 5.7.28, this view is deprecated and subject to removal in a future MySQL version.

26.4.3.48 The wait_classes_global_by_avg_latency and x$wait_classes_global_by_avg_latency Views

https://dev.mysql.com/doc/refman/5.7/en/sys-wait-classes-global-by-avg-latency.html

The wait_classes_global_by_avg_latency and x$wait_classes_global_by_avg_latency views have these columns: event_class The event class. These views summarize wait class average latencies, grouped by event class. An event class is determined by ...

26.4.3.49 The wait_classes_global_by_latency and x$wait_classes_global_by_latency Views

https://dev.mysql.com/doc/refman/5.7/en/sys-wait-classes-global-by-latency.html

The wait_classes_global_by_latency and x$wait_classes_global_by_latency views have these columns: event_class The event class. These views summarize wait class total latencies, grouped by event class. An event class is determined by stripping from ...

26.4.3.50 The waits_by_host_by_latency and x$waits_by_host_by_latency Views

https://dev.mysql.com/doc/refman/5.7/en/sys-waits-by-host-by-latency.html

The waits_by_host_by_latency and x$waits_by_host_by_latency views have these columns: host The host from which the connection originated. These views summarize wait events, grouped by host and event. By default, rows are sorted by host and ...

26.4.3.51 The waits_by_user_by_latency and x$waits_by_user_by_latency Views

https://dev.mysql.com/doc/refman/5.7/en/sys-waits-by-user-by-latency.html

The waits_by_user_by_latency and x$waits_by_user_by_latency views have these columns: user The user associated with the connection. These views summarize wait events, grouped by user and event. By default, rows are sorted by user and descending ...

26.4.3.52 The waits_global_by_latency and x$waits_global_by_latency Views

https://dev.mysql.com/doc/refman/5.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.

Displaying 851 to 860 of 869 total results