PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-instruments-table.html
The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM performance_schema.setup_instruments; +---------------------------------------------------+---------+-------+ | NAME | ENABLED ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-objects-table.html
The setup_objects table controls whether the Performance Schema monitors particular objects. This table has a maximum size of 100 rows by default. To change the table size, modify the performance_schema_setup_objects_size system variable at server ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-socket-instances-table.html
The socket_instances table provides a real-time snapshot of the active connections to the MySQL server. The table contains one row per TCP/IP or Unix socket file connection. Information available in this table provides a real-time snapshot of the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-socket-summary-tables.html
These socket summary tables aggregate timer and byte count information for socket operations: socket_summary_by_event_name: Aggregate timer and byte count statistics generated by the wait/io/socket/* instruments for all socket I/O operations, per ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variable-summary-tables.html
The Performance Schema supports TRUNCATE TABLE for status variable summary tables as follows; in all cases, status for active sessions is unaffected: status_by_account: Aggregates account status from terminated sessions to user and host status, then ... Note The value of the show_compatibility_56 system variable affects the information available from the tables described ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variable-tables.html
The Performance Schema supports TRUNCATE TABLE for status variable tables as follows: global_status: Resets thread, account, host, and user status. Note The value of the show_compatibility_56 system variable affects the information available from ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-system-variable-tables.html
TRUNCATE TABLE is not supported for Performance Schema system variable tables. Note The value of the show_compatibility_56 system variable affects the information available from the tables described here. For details, see the description of that ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-handles-table.html
The Performance Schema exposes table lock information through the table_handles table to show the table locks currently in effect for each opened table handle. This information shows which table handles the server has open, how they are locked, and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-threads-table.html
The threads table contains a row for each server thread. Each row contains information about a thread and indicates whether monitoring and historical event logging are enabled for it: mysql> SELECT * FROM performance_schema.threads\G ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-timing.html
To avoid unpredictable results after you make timer changes, use TRUNCATE TABLE to reset Performance Schema statistics. Events are collected by means of instrumentation added to the server source code. Instruments time events, which is how the ...