PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-hosts-table.html
The hosts table contains a row for each host from which clients have connected to the MySQL server. For each host name, the table counts the current and total number of connections. To set the table size explicitly, set the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instance-tables.html
Instrument names may have multiple parts and form a hierarchy, as discussed in Section 29.6, “Performance Schema Instrument Naming Conventions”. They provide event names and explanatory notes or status information: cond_instances: Condition ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrumentation-checking.html
This information is always up to date for your version of MySQL, also includes instrumentation for instrumented plugins you might have installed that are not part of the core server, and can be used by automated tools. It is always possible to ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-mutex-instances-table.html
A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to some common resource. The mutex_instances table lists all the mutexes seen by the Performance Schema while the server ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-ndb-cluster-tables.html
The following table shows all Performance Schema tables relating to the NDBCLUSTER storage engine. This is done by default in the background at regular intervals as determined by the ndb_metadata_check_interval system variable, unless disabled ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-ndb-sync-pending-objects-table.html
This table provides information about NDB database objects for which mismatches have been detected and which are waiting to be synchronized between the NDB dictionary and the MySQL data dictionary.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-obtaining-parent-events.html
Rows of this table have a THREAD_ID column indicating the thread ID of the session that owns the lock, and an EVENT_ID column indicating the Performance Schema event that caused the lock. The relation is based on a nested set data model, so the join ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-options.html
Runtime configuration is also possible in many cases (see Section 29.4, “Performance Schema Runtime Configuration”), but startup configuration must be used when runtime configuration is too late to affect instruments that have already been ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-pre-filtering.html
That might be useful, for example, after you have made a runtime configuration change. Pre-filtering is done by the Performance Schema and has a global effect that applies to all users. Pre-filtering can be applied to either the producer or ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-queries.html
Pre-filtering limits which event information is collected and is independent of any particular user. By contrast, post-filtering is performed by individual users through the use of queries with appropriate WHERE clauses that restrict what event ...