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/password-management.html
MySQL enables database administrators to expire account passwords manually, and to establish a policy for automatic password expiration. Expiration policy can be established globally, and individual accounts can be set to either defer to the global ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-and-plugins.html
The associated event information, including aggregate information, remains readable in performance_schema database tables. Removing a plugin with UNINSTALL PLUGIN does not affect information already collected for code in that plugin. Time spent ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-build-configuration.html
You might see performance_schema listed in the output from SHOW DATABASES, but it has no tables and cannot be used. It is possible to exclude certain parts of the Performance Schema instrumentation. For example, to exclude stage and statement ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-tables.html
When a client connects to the MySQL server, it does so under a particular user name and from a particular host. They differ in that, for grant tables, the host part of an account can be a pattern, whereas for Performance Schema tables, the host ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-current-table.html
CURRENT_SCHEMA The default database for the statement, NULL if there is none. The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-examples.html
Tune a query by writing it differently, Tune the database schema (tables, indexes, and so forth). The Performance Schema is a tool to help a DBA do performance tuning by taking real measurements instead of “wild guesses.” This section ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrument-naming.html
For example, the statement/sql/create_db and statement/sql/select instruments are used for CREATE DATABASE and SELECT statements. 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-metadata-locks-table.html
MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency; see Section 8.11.4, “Metadata Locking”. Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-processlist-table.html
DB The default database for the thread, or NULL if none has been selected. Note The processlist table is automatically created in the Performance Schema for new installations of MySQL 5.7.39, or higher. The MySQL process list indicates the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-group-member-stats-table.html
Can be thought of as the current size of the conflict detection database against which each transaction is certified. This table shows statistical information for MySQL Group Replication members. The replication_group_member_stats table has these ...