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-event-tables.html
The _current tables show what is currently happening within the server. The _history and _history_long tables show what has happened in the recent past. For wait, stage, statement, and transaction events, the Performance Schema can monitor and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-metadata-locks-table.html
The Performance Schema exposes metadata lock information through the metadata_locks table: Locks that have been granted (shows which sessions own which current metadata locks). Locks that have been requested but not yet granted (shows which sessions ... MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency; see Section 8.11.4, “Metadata ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-summary-tables.html
This row helps you estimate whether the digest summary is representative: A DIGEST = NULL row that has a COUNT_STAR value that represents 5% of all digests shows that the digest summary table is very representative; the other rows cover 95% of the ... 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-table-handles-table.html
The Performance Schema exposes table lock information through the table_handles table to show the table locks currently in effect for each opened table handle. This information shows which table handles the server has open, how they are locked, and ...It is autosized by default; to configure the table size, set the performance_schema_max_table_handles system variable at server ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-timing.html
The columns have these meanings: The TIMER_NAME column shows the names of the available timers. The value shown was obtained on a system with a 2.4GHz processor. For display when events are retrieved from Performance Schema tables, times are shown ... Events are collected by means of instrumentation added to the server source ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication-system-variables.html
The following table shows the permitted level values and their meanings. The following table shows the permitted level values and their meanings. Communication between the authentication plugin and the LDAP server occurs according to this ...
https://dev.mysql.com/doc/refman/5.7/en/plugin-loading.html
These can be identified as those that have a library name of NULL in the output from INFORMATION_SCHEMA.PLUGINS or SHOW PLUGINS. If the plugin still appears in the output from INFORMATION_SCHEMA.PLUGINS or SHOW PLUGINS, use UNINSTALL PLUGIN to ...
https://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery-binlog.html
This section explains the general idea of using the binary log to perform a point-in-time-recovery. The next section, Section 7.5.2, “Point-in-Time Recovery Using Event Positions”, explains the operation in details with an example. Note Many of ...
https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.html
Then change the '%' in the user table row to the actual host name that shows up in the log. Then you can change the MySQL grant tables and use the SHOW GRANTS statement to check whether your modifications have the desired effect. If you encounter ...
https://dev.mysql.com/doc/refman/5.7/en/programs-development.html
This section describes some utilities that you may find useful when developing MySQL programs. In shell scripts, you can use the my_print_defaults program to parse option files and see what options would be used by a given program. This works well ...