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-consumer-configurations.html
The configuration descriptions occur in order of increasing functionality and overhead. The consumer settings in the setup_consumers table form a hierarchy from higher levels to lower. The following discussion describes how consumers work, showing ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrument-naming.html
For example, the statement/sp/cfetch and statement/sp/freturn instruments are used cursor fetch and function return instructions. An instrument name consists of a sequence of elements separated by '/' characters. Example names: ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-memory-summary-tables.html
Each memory summary table has these summary columns containing aggregated values: COUNT_ALLOC, COUNT_FREE The aggregated numbers of calls to memory-allocation and memory-free functions. Operation counts help to understand or tune the overall ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-processlist-table.html
This is the same value displayed in the Id column of the SHOW PROCESSLIST statement, displayed in the PROCESSLIST_ID column of the Performance Schema threads table, and returned by the CONNECTION_ID() function within the thread. Note The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-group-members-table.html
This table shows network and status information for replication group members. The network addresses shown are the addresses used to connect clients to the group, and should not be confused with the member's internal group communication address ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-digests.html
Warning Setting the max_digest_length system variable to zero disables digest production, which also disables server functionality that requires digests. The MySQL server is capable of maintaining statement digest information. The digesting process ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-summary-tables.html
Each row summarizes events for a given stored program (stored procedure or function, trigger, or event). The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in summary tables.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-timing.html
For example, the standard gettimeofday() function can take hundreds of cycles, which is an unacceptable overhead for data gathering that may occur thousands or millions of times per second. Events are collected by means of instrumentation added to ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema.html
In general, an event could be a function call, a wait for the operating system, a stage of an SQL statement execution such as parsing or sorting, or an entire statement or group of statements. The MySQL Performance Schema is a feature for ...
https://dev.mysql.com/doc/refman/5.7/en/perl-support.html
Although earlier versions are available, they do not support the full functionality of MySQL 5.7. The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many different database engines ...