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/partitioning-management.html
It is possible to add, drop, redefine, merge, or split existing partitions. MySQL 5.7 provides a number of ways to modify partitioned tables. All of these actions can be carried out using the partitioning extensions to the ALTER TABLE statement.
https://dev.mysql.com/doc/refman/5.7/en/password-management.html
It is also possible for an administrative user to reset the account password, but any existing restricted sessions for that account remain restricted. MySQL enables database administrators to expire account passwords manually, and to establish a ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-pre-filtering.html
Modifications to the setup_actors table affect only foreground threads created subsequent to the modification, not existing threads. Pre-filtering is done by the Performance Schema and has a global effect that applies to all users. Pre-filtering ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-quick-start.html
For example, use either of these statements to see what Performance Schema tables exist: mysql> SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'performance_schema'; +------------------------------------------------------+ | ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-objects-table.html
For existing rows, only the ENABLED and TIMED columns can be modified, by users with the UPDATE privilege on the table. The setup_objects table controls whether the Performance Schema monitors particular objects. This table has a maximum size of ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-digests.html
If the table becomes full, the Performance Schema groups statements that have SCHEMA_NAME and DIGEST values not matching existing values in the table in a special row with SCHEMA_NAME and DIGEST set to NULL. The MySQL server is capable of ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-summary-tables.html
If a events_statements_summary_by_digest row already exists with the digest value for the statement that just completed, statistics for the statement are aggregated to that row. The Performance Schema maintains tables for collecting current and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-descriptions.html
Tables in the performance_schema database can be grouped as follows: Setup tables. The events_waits_current table contains the most recent event for each thread. Other similar tables contain current events at different levels of the event ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-variable-table-migration.html
Applications that have been revised to work in MySQL 5.7 when show_compatibility_56=OFF should work without further changes, except that it is not possible to test or set show_compatibility_56 because it does not exist. The INFORMATION_SCHEMA has ...
https://dev.mysql.com/doc/refman/5.7/en/perl-support-problems.html
For example, if the linker cannot find libc because it is in /lib and the link command specifies -L/usr/lib, change the -L option to -L/lib or add -L/lib to the existing link command. If Perl reports that it cannot find the ../mysql/mysql.so ...