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/performance-schema-file-summary-tables.html
The Performance Schema maintains file I/O summary tables that aggregate information about I/O operations. Example file I/O event summary information: mysql> SELECT * FROM performance_schema.file_summary_by_event_name\G ... row ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-filtering-names.html
To check which instrument or consumer names a pattern matches, perform a simple test: SELECT NAME FROM performance_schema.setup_instruments WHERE NAME LIKE 'pattern'; SELECT NAME FROM performance_schema.setup_consumers WHERE NAME LIKE 'pattern'; For ... Names given for filtering operations can be as specific or general as ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-host-cache-table.html
The Performance Schema must be enabled or this table is empty. The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to avoid Domain Name System (DNS) lookups. The host_cache_size ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrumentation-checking.html
It is always possible to determine what instruments the Performance Schema includes by checking the setup_instruments table. Changes to this code occur often, which also affects the set of instruments. It is not practical to list all the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-objects-summary-global-by-type-table.html
The Performance Schema maintains the objects_summary_global_by_type table for aggregating object wait events. Example object wait event summary information: mysql> SELECT * FROM performance_schema.objects_summary_global_by_type\G ... row ...It ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-rwlock-instances-table.html
The rwlock_instances table lists all the rwlock (read write lock) instances seen by the Performance Schema while the server executes. An rwlock is a synchronization mechanism used in the code to enforce that threads at a given time can have access ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-session-account-connect-attrs-table.html
For descriptions of common attributes, see Section 25.12.9, “Performance Schema Connection Attribute Tables”. Application programs can provide key-value connection attributes to be passed to the server at connect time. The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-session-connect-attrs-table.html
For descriptions of common attributes, see Section 25.12.9, “Performance Schema Connection Attribute Tables”. Application programs can provide key-value connection attributes to be passed to the server at connect time. To see connection ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-actors-table.html
To change the table size, modify the performance_schema_setup_actors_size system variable at server startup. For each new foreground thread, the Performance Schema matches the user and host for the thread against the rows of the setup_actors table.
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 ...| stage/sql/end | NO | NO | | stage/sql/executing | NO | NO | | stage/sql/init | NO | NO | | stage/sql/insert | NO | NO | ...