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-file-summary-tables.html
In this way, aggregations at higher levels are available directly without the need for user-defined views that sum lower-level columns. The Performance Schema maintains file I/O summary tables that aggregate information about I/O operations.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-hosts-table.html
This is NULL for an internal thread, or for a user session that failed to authenticate. 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 ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-mutex-instances-table.html
The mutex_instances table lists all the mutexes seen by the Performance Schema while the server executes. 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 ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-objects-summary-global-by-type-table.html
row *************************** OBJECT_TYPE: TABLE OBJECT_SCHEMA: mysql OBJECT_NAME: user COUNT_STAR: 14 SUM_TIMER_WAIT: 365567592 MIN_TIMER_WAIT: 1141704 AVG_TIMER_WAIT: 26111769 MAX_TIMER_WAIT: 334783032 ... The Performance Schema maintains the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-pre-filtering.html
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 consumer stage of event processing: To configure pre-filtering at the producer stage, several ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variables.html
Performance_schema_users_lost The number of times a row could not be added to the users table because it was full. Performance Schema status variables have the following meanings: Performance_schema_accounts_lost The number of times a row could not ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-tables.html
The cost of transaction instrumentation can be reduced various ways, such as enabling or disabling transaction instrumentation according to user, account, host, or thread (client connection). Within the event hierarchy, wait events nest within stage ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-storage-common-layer.html
Memory Caches: Different applications respond better to some memory caching strategies than others, so although some memory caches are common to all storage engines (such as those used for user connections or MySQL's high-speed Query Cache), others ... A MySQL pluggable storage engine is the component in the MySQL database server that is responsible for performing the actual data I/O operations for a database as well as enabling and enforcing certain feature sets that target a specific application ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-storage.html
MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL server. Plugging in a Storage Engine Before a storage engine can be used, the storage engine plugin shared ...
https://dev.mysql.com/doc/refman/5.7/en/privilege-checking.html
In complex scenarios where the query uses SQL SECURITY DEFINER views or stored routines, it may be that a user is denied from seeing the trace of its query because it lacks some extra privileges on those objects. In that case, the trace will be ...