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/mysql-cluster-programs-ndb-desc.html
The Version column in the output contains the table's schema object version. For information about interpreting this value, see NDB Schema Object Versions. The number of bytes shown as Free extent_space is available for storing on-disk column data ... ndb_desc provides a detailed description of one or more NDB ...
https://dev.mysql.com/doc/refman/5.7/en/replication-administration-status.html
From MySQL 5.7, the Performance Schema has replication tables that provide this information in a more accessible form. The replication_connection_status Performance Schema table shows when the most recent heartbeat signal was received by a replica, ... The most common task when managing a replication process is to ensure that replication is taking place and that there have been no errors between the replica and the ...
https://dev.mysql.com/doc/refman/5.7/en/server-configuration.html
In addition, the MySQL sys schema is a set of objects that provides convenient access to data collected by the Performance Schema; see Chapter 26, MySQL sys Schema. The MySQL server, mysqld, has many command options and system variables that can be ...
https://dev.mysql.com/doc/refman/5.7/en/sys-metrics.html
This view summarizes MySQL server metrics to show variable names, values, types, and whether they are enabled. The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-trace-statement-digest.html
Traces all Performance Schema instrumentation for a specific statement digest. If you find a statement of interest within the Performance Schema events_statements_summary_by_digest table, specify its DIGEST column MD5 value to this procedure and ...
https://dev.mysql.com/doc/refman/5.7/en/sys-sys-config.html
This table contains sys schema configuration options, one row per option. The value is NULL if the row has not been changed since the sys schema was installed. As an efficiency measure to minimize the number of direct reads from the sys_config ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
You must specify the schema name if the trigger is not in the default schema: mysql> DROP TRIGGER test.ins_sum; If you drop a table, any triggers for the table are also dropped. Trigger names exist in the schema namespace, meaning that all triggers ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 13.1.20, “CREATE TRIGGER Statement”, and Section 13.1.31, “DROP TRIGGER ...
https://dev.mysql.com/doc/refman/5.7/en/document-store.html
Relational databases such as MySQL usually required a document schema to be defined before documents can be stored. The features described in this section enable you to use MySQL as a document store, which is a schema-less, and therefore ... This ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
The value returned by CONNECTION_ID() is the same type of value as displayed in the ID column of the Information Schema PROCESSLIST table, the Id column of SHOW PROCESSLIST output, and the PROCESSLIST_ID column of the Performance Schema threads ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-change-buffer.html
The Information Schema INNODB_METRICS table provides most of the data points found in InnoDB Standard Monitor output plus other data points. To view change buffer metrics and a description of each, issue the following query: mysql> SELECT NAME, ...