PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sys-memory-global-by-current-bytes.html
By default, rows are sorted by descending amount of memory used. These views summarize memory use, grouped by allocation type (that is, by event). The memory_global_by_current_bytes and x$memory_global_by_current_bytes views have these columns: ...
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-ps-thread-account.html
The value should match the THREAD_ID column from some Performance Schema threads table row. Given a Performance Schema thread ID, returns the user_name@host_name account associated with the thread. Parameters in_thread_id BIGINT UNSIGNED: The ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-auto-increment-columns.html
By default, rows are sorted by descending usage ratio and maximum column value. This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum column values and the usage ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-unused-indexes.html
These views display indexes for which there are no events, which indicates that they are not being used. This view is most useful when the server has been up and processing long enough that its workload is representative. Otherwise, presence of an ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-errors-or-warnings.html
By default, rows are sorted by descending error and warning counts. These views display normalized statements that have produced errors or warnings. The statements_with_errors_or_warnings and x$statements_with_errors_or_warnings views have these ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-temp-tables.html
By default, rows are sorted by descending number of on-disk temporary tables used and descending number of in-memory temporary tables used. These views list normalized statements that have used temporary tables. The statements_with_temp_tables and ...
https://dev.mysql.com/doc/refman/8.0/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.
https://dev.mysql.com/doc/refman/8.0/en/sys-sys-get-config.html
However, this should not be done inside a loop (for example, for each row in a result set) because for repeated calls where the assignment is needed only in the first iteration, using IFNULL(...) is expected to be significantly slower than using an ... Given a configuration option name, returns the option value from the sys_config table, or the provided default value (which may be NULL) if the option does not exist in the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-wait-classes-global-by-avg-latency.html
These views summarize wait class average latencies, grouped by event class. An event class is determined by stripping from the event name everything after the first three components. The wait_classes_global_by_avg_latency and ...