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/performance-schema-quick-start.html
row *************************** Table: setup_consumers Create Table: CREATE TABLE `setup_consumers` ( `NAME` varchar(64) NOT NULL, `ENABLED` enum('YES','NO') NOT NULL ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 Table structure is also available ... This section briefly introduces the Performance Schema with examples that show how to use ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-configuration-table.html
Parameters stored in the table can be changed at runtime with the CHANGE MASTER TO statement, as indicated in the column descriptions. The replication_applier_configuration table has these columns: CHANNEL_NAME The replication channel which this row ... This table shows the configuration parameters that affect transactions applied by the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-connection-status-table.html
The replication_connection_status table has these columns: CHANNEL_NAME The replication channel which this row is displaying. Issuing RESET MASTER or RESET SLAVE resets the values shown in these columns. The following table shows the correspondence ... This table shows the current status of the replication I/O thread that handles the replica's connection to the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-tables.html
No data is provided for the WORK_ESTIMATED column, which displays 0. Bounded progress instrumentation The WORK_COMPLETED and WORK_ESTIMATED columns are both meaningful. The Performance Schema instruments stages, which are steps during the ...
https://dev.mysql.com/doc/refman/5.7/en/repair-table.html
REPAIR TABLE Output REPAIR TABLE returns a result set with the columns shown in the following table. Column Value Table The table name Op Always repair Msg_type status, error, info, note, or warning Msg_text An informational message The REPAIR TABLE ...[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines ...
https://dev.mysql.com/doc/refman/5.7/en/row-subqueries.html
Scalar or column subqueries return a single value or a column of values. A row subquery is a subquery variant that returns a single row and can thus return more than one column value. A row constructor is used for comparisons with subqueries that ...If this row has col3 and col4 values equal to the col1 and col2 values of any rows in t1, the WHERE expression is TRUE and each query returns those t1 ...
https://dev.mysql.com/doc/refman/5.7/en/select-into.html
Column and line terminators can be specified to produce a specific output format. Column values are written converted to the character set specified in the CHARACTER SET clause. If a result set contains columns in several character sets, so does the ...INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
This value is incremented if you are querying an index column with a range constraint or if you are doing an index scan. To monitor any replication channel, use the HEARTBEAT_INTERVAL column in the replication_connection_configuration table for the ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/5.7/en/show-engine.html
SHOW ENGINE INNODB MUTEX output has these columns: Type Always InnoDB. The connection row's Status column contains the name/value pairs described in the following table. An NdbBlob is created for each new operation involving a BLOB column in an NDB ... SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information about a storage ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-types.html
A geometry-valued SQL column is implemented as a column that has a geometry type. MySQL spatial extensions enable the generation, storage, and analysis of geographic features: Data types for representing spatial values Functions for manipulating ...