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/information-schema-schema-privileges-table.html
The SCHEMA_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. TABLE_CATALOG The name of the catalog to which the schema belongs. The value can be any privilege ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-alter-table-performance-schema.html
You can monitor ALTER TABLE progress for InnoDB tables using Performance Schema. ALTER TABLE Monitoring Example Using Performance Schema The following example demonstrates how to enable the stage/innodb/alter table% stage event instruments and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-attribute-tables.html
These Performance Schema tables expose attribute information: session_account_connect_attrs: Connection attributes for the current session, and other sessions associated with the session account session_connect_attrs: Connection attributes for all ... Connection attributes are key-value pairs that application programs can pass to the server at connect ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-event-tables.html
For wait, stage, statement, and transaction events, the Performance Schema can monitor and store current events. In addition, when events end, the Performance Schema can store them in history tables. For each event type, the Performance Schema uses ...The tables have names of the following forms, where xxx indicates the event type (waits, stages, statements, transactions): events_xxx_current: The “current events” table stores the current monitored event for each thread (one row per ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variable-tables.html
Status variable information is available in these Performance Schema tables: global_status: Global status variables. The Performance Schema collects statistics for global status variables only for threads for which the INSTRUMENTED value is YES in ... Note The value of the show_compatibility_56 system variable affects the information available from the tables described ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-examples-compression-sect.html
Example 14.1 Using the Compression Information Schema Tables The following is sample output from a database that contains compressed tables (see Section 14.9, “InnoDB Table and Page Compression”, INNODB_CMP, INNODB_CMP_PER_INDEX, and ...The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-print-schema-file.html
Usage ndb_print_schema_file file_name file_name is the name of a cluster schema file. For more information about cluster schema files, see NDB Cluster Data Node File System Directory. Like ndb_print_backup_file and ndb_print_sys_file (and unlike ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-system-variable-tables.html
System variable information is available in these Performance Schema tables: global_variables: Global system variables. If not all threads are instrumented by the Performance Schema, this table may miss some rows. In this case, the ... Note The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-reference.html
The following table summarizes all available Performance Schema tables. For greater detail, see the individual table descriptions. Table 25.1 Performance Schema Tables Table Name Description Deprecated accounts Connection statistics per client ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-views.html
The sys schema contains many views that summarize Performance Schema tables in various ways. Most of these views come in pairs, such that one member of the pair has the same name as the other member, plus a x$ prefix. The view with the x$ prefix ...