PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-statement-avg-latency-histogram.html
Displays a textual histogram graph of the average latency values across all normalized statements tracked within the Performance Schema events_statements_summary_by_digest table. This procedure can be used to display a very high-level picture of ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-account.html
Given a Performance Schema thread ID, returns the user_name@host_name account associated with the thread. The value should match the THREAD_ID column from some Performance Schema threads table row. Parameters in_thread_id BIGINT UNSIGNED: The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-id.html
Returns the Performance Schema thread ID assigned to a given connection ID, or the thread ID for the current connection if the connection ID is NULL. This is a value of the type given in the PROCESSLIST_ID column of the Performance Schema threads ...Parameters in_connection_id BIGINT UNSIGNED: The ID of the connection for which to return the thread ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-stack.html
Returns a JSON formatted stack of all statements, stages, and events within the Performance Schema for a given thread ID. The value should match the THREAD_ID column from some Performance Schema threads table row. row *************************** ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-trace-thread.html
Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). in_start_fresh BOOLEAN: Whether to reset all Performance Schema data before tracing. Each result set returned from ...
https://dev.mysql.com/doc/refman/5.7/en/sys-version.html
This view provides the current sys schema and MySQL server versions. The version view has these columns: sys_version The sys schema version. Note As of MySQL 5.7.28, this view is deprecated and subject to removal in a future MySQL version.
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-elements.html
The Performance Schema has instruments that expose information about the thread pool and may be used to investigate operational performance. To identify them, use this query: SELECT * FROM performance_schema.setup_instruments WHERE NAME LIKE ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-operation.html
While a thread executes a statement from a user connection, Performance Schema instrumentation accounts thread activity to the user connection. The thread pool consists of a number of thread groups, each of which manages a set of client connections. As connections are established, the thread pool assigns them to thread groups in round-robin ...
https://dev.mysql.com/doc/refman/5.7/en/truncate-table.html
TRUNCATE TABLE can be used with Performance Schema summary tables, but the effect is to reset the summary columns to 0 or NULL, not to remove rows. Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of ...
https://dev.mysql.com/doc/refman/5.7/en/workbench.html
Data Modeling: Enables you to create models of your database schema graphically, reverse and forward engineer between a schema and a live database, and edit all aspects of your database using the comprehensive Table Editor. MySQL Workbench provides ...