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-object-filtering.html
(Tables in the INFORMATION_SCHEMA database are not instrumented regardless of the contents of setup_objects; the row for information_schema.% simply makes this default explicit.) When the Performance Schema checks for a match in setup_objects, it ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-performance-timers-table.html
The Performance Schema determines this value by invoking the timer 20 times during initialization and picking the smallest value. The total overhead really is twice this amount because the instrumentation invokes the timer at the start and end of ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-by-coordinator-table.html
For a multithreaded replica, the replica uses multiple worker threads and a coordinator thread to manage them, and this table shows the status of the coordinator thread. The replication_applier_status_by_coordinator table has these columns: ...For ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-summary-tables.html
To set this maximum explicitly, set the performance_schema_digests_size system variable at server startup. This row helps you estimate whether the digest summary is representative: A DIGEST = NULL row that has a COUNT_STAR value that represents 5% ... The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in summary ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-summary-tables.html
The tables in this group summarize event data in different ways. Exceptions to this truncation behavior are noted in individual summary table sections. Summary tables provide aggregated information for terminated events over time. Each summary ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-users-table.html
For a description of how the Performance Schema maintains rows in this table, including the effect of TRUNCATE TABLE, see Section 25.12.8, “Performance Schema Connection Tables”. This is NULL for an internal thread, or for a user session that ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-wait-summary-tables.html
If an instrument is used to create multiple instances, each instance has a unique OBJECT_INSTANCE_BEGIN value and is summarized separately in this table. This value is calculated only for timed events because nontimed events have a wait time of NULL. The Performance Schema maintains tables for collecting current and recent wait events, and aggregates that information in summary ...
https://dev.mysql.com/doc/refman/5.7/en/perror.html
This option is deprecated in NDB 7.6.4 and later, where perror prints a warning if it is used, and is removed in NDB Cluster 8.0. For most system errors, MySQL displays, in addition to an internal text message, the system error code in one of the ...
https://dev.mysql.com/doc/refman/5.7/en/privilege-changes.html
This may leave you wondering why your changes seem to make no difference! To tell the server to reload the grant tables, perform a flush-privileges operation. This can be done by issuing a FLUSH PRIVILEGES statement or by executing a mysqladmin ...
https://dev.mysql.com/doc/refman/5.7/en/problems-with-alias.html
This restriction is imposed because when the WHERE clause is evaluated, the column value may not yet have been determined. An alias can be used in a query select list to give a column a different name. In the select list of a query, a quoted column ...