Shulou(Shulou.com)05/31 Report--

This article focuses on "what are the performance framework view parameters of MySQL5.7 SYS Schema". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "what are the performance framework view parameters of MySQL5.7 SYS Schema?"

1 host_summary and x$host_summary Views

The view shows statement activity, file io, and connection information, grouped by host

2 host_summary_by_file_io and x$host_summary_by_file_io Views

The view totals the file io, grouped by host

3 host_summary_by_file_io_type and x$host_summary_by_file_io_type Views

The view totals the file io, grouped by host and event types.

4 host_summary_by_stages and x$host_summary_by_stages Views

Total statement stage, grouped by host

5 host_summary_by_statement_latency and x$host_summary_by_statement_latency Views

Statistics for total statements, grouped by host

6 host_summary_by_statement_type and x$host_summary_by_statement_type Views

Execution of total statements, grouped by host and statement type

7 innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema Views

Statistical information_schema.innodb_buffer_page, grouped by schema, object_schema is the schema of the object, if the innodb table belongs to innodb system.

8 innodb_buffer_stats_by_table and x$innodb_buffer_stats_by_table Views

Statistical information_schema.innodb_buffer_page, grouped by table name.

9 innodb_lock_waits and x$innodb_lock_waits Views

Total number of innodb lock waits. The list is as follows:

Wait_started: wait for the start event.

Wait_age: the length of time to wait for the lock.

Wait_age_secs: how many seconds did you wait?

Locked_table: the locked table.

Locked_index: locked index

Locked_type: lock wait type

Waiting_trx_started: waits for the start event of the transaction.

Waiting_trx_age: wait transaction wait time.

Waiting_trx_rows_locked: the number of row locks waiting for the transaction to lock.

……

10 io_by_thread_by_latency and x$io_by_thread_by_latency Views

The total IO consumer shows the thread's IO wait.

11 io_global_by_file_by_bytes and x$io_global_by_file_by_bytes Views

The total number of reads and writes displayed by IO consumers for each file, grouped by files

12 io_global_by_file_by_latency and x$io_global_by_file_by_latency Views

Summarize io consumer display io times and delay events, grouped by files

13 io_global_by_wait_by_bytes and x$io_global_by_wait_by_bytes Views

The total io bytes of each event.

14 io_global_by_wait_by_latency and x$io_global_by_wait_by_latency Views

Total number of io and io wait time per event

15 latest_file_io and x$latest_file_io Views

Total active file IO, grouped by files and threads.

16 memory_by_host_by_current_bytes and x$memory_by_host_by_current_bytes Views

Total memory used by host

17 memory_by_thread_by_current_bytes and x$memory_by_thread_by_current_bytes Views

Memory usage of threads

18 memory_by_user_by_current_bytes and x$memory_by_user_by_current_bytes Views

Total memory used by the user

19 memory_global_by_current_bytes and x$memory_global_by_current_bytes Views

Memory allocated for each allocation type

20 memory_global_total and x$memory_global_total Views

Total memory usage of the service

21 metrics View

View the total metrics of the mysql service, showing the variable name, variable value, type, and their startup. The view was added in mysql 5.7.9, and the view mainly contains information:

O global state variables for the global_ status table.

O from information_schema.global_status.Innodb indicators

O current and all memory allocations

O current time

There are some metrics that are duplicated in global_status and innodb_status, which are eliminated by the metrics view.

22 processlist and x$processlist Views

More detailed than the information returned by showprocesslist

23 ps_check_lost_instrumentation View

Returns the missing performance framework record point, showing whether the performance framework can track all data.

24 schema_auto_increment_columns View

The view shows the columns with auto_increment and provides useful information.

25 schema_index_statistics and x$schema_index_statistics Views

All statistics provided by the view

26 schema_object_overview View

Object statistics under schema

27 schema_redundant_indexes and x$schema_flattened_keys Views

Shows redundant indexes

28 schema_table_lock_waits and x$schema_table_lock_waits Views

Shows which sessions are locked by metadata locks and what locks them

29 schema_table_statistics and x$schema_table_statistics Views

Statistics of table operations, io and latency

30 schema_table_statistics_with_buffer and x$schema_table_statistics_with_buffer Views

Statistics of table operations, io and latency statistics, and memory allocation

31 schema_tables_with_full_table_scans and x$schema_tables_with_full_table_scans Views

Shows which tables are accessed by the table scan

32 schema_unused_indexes View

Unused index

33 session and x$session Views

Similar to processlist but does not show background processes

34 session_ssl_status View

Displays the SSL version, chipher, and count for each connection

35 statement_analysis and x$statement_analysis Views

Shows the execution of the statement, the number of times it was executed, the number of response lines, delays, etc.

36 statements_with_errors_or_warnings and x$statements_with_errors_or_warnings Views

Error or warning of statement

37 statements_with_full_table_scans and x$statements_with_full_table_scans Views

The statement of table scan is used

38 statements_with_runtimes_in_95th_percentile and x$statements_with_runtimes_in_95th_percentile Views

Statements with runtimes less than 95%

39 statements_with_sorting and x$statements_with_sorting Views

The sorted statement was executed

40 statements_with_temp_tables and x$statements_with_temp_tables Views

Statements with temporary tables are used

41 user_summary and x$user_summary Views

Total user information, including statements, file io, connection

42 user_summary_by_file_io and x$user_summary_by_file_io Views

Total user files io

43 user_summary_by_file_io_type and x$user_summary_by_file_io_type Views

Total user file io types

44 user_summary_by_stages and x$user_summary_by_stages Views

Total user stage events

45 user_summary_by_statement_latency and x$user_summary_by_statement_latency Views

The user's delay in executing the statement

46 user_summary_by_statement_type and x$user_summary_by_statement_type Views

User's delay in statement type

47 version View

Version

48 wait_classes_global_by_avg_latency and x$wait_classes_global_by_avg_latency Views

Delay summary of wait types, sorted by average delay

49 wait_classes_global_by_latency and x$wait_classes_global_by_latency Views

Delay summary of wait types, sorted by total delay

50 waits_by_host_by_latency and x$waits_by_host_by_latency Views

Host, waiting for event delay summary

51 waits_by_user_by_latency and x$waits_by_user_by_latency Views

User wait for event delay

52 waits_global_by_latency and x$waits_global_by_latency Views

Wait for event delay.

At this point, I believe that you have a deeper understanding of "what are the performance framework view parameters of MySQL5.7 SYS Schema?" you might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.