PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/show-slave-status.html
Issuing RESET MASTER or RESET SLAVE resets the values shown in these columns. In other words, this column is useful only for fast networks. This timestamp uses the format YYMMDD hh:mm:ss, and appears in the Last_IO_Error_Timestamp column. Issuing ...
https://dev.mysql.com/doc/refman/5.7/en/tracing-example.html
Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. "resulting_clause_is_simple": true, ...row ...
https://dev.mysql.com/doc/refman/5.7/en/explain.html
The description for SHOW COLUMNS provides more information about the output columns. By default, DESCRIBE displays information about all columns in the table. col_name, if given, is the name of a column in the table. In this case, the statement ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-trx-table.html
The INNODB_TRX table has these columns: TRX_ID A unique transaction ID number, internal to InnoDB. To obtain details about the lock, join this column with the LOCK_ID column of the INNODB_LOCKS table. To obtain details about the thread, join this ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning.html
When to Use Compression In general, compression works best on tables that include a reasonable number of character string columns and where the data is read far more often than it is written. Character strings often compress well, whether defined in ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-transporters.html
This information is shown in the table's status column, which can have any one of the following values: CONNECTING, CONNECTED, DISCONNECTING, or DISCONNECTED. The remote_address is the host name or address for the node whose ID is shown in the ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-syntax.html
If you specify ZEROFILL for a numeric column, MySQL automatically adds the UNSIGNED attribute to the column. SERIAL DEFAULT VALUE in the definition of an integer column is an alias for NOT NULL AUTO_INCREMENT UNIQUE. MySQL can handle BIGINT in the ... For integer data types, M indicates the minimum display ...
https://dev.mysql.com/doc/refman/5.7/en/option-modifiers.html
For example, the mysql client supports a --column-names option that determines whether or not to display a row of column names at the beginning of query results. To disable column names, you can specify the option using any of these forms: ... Some ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-prepared-statements-instances-table.html
The prepared_statements_instances table has these columns: OBJECT_INSTANCE_BEGIN The address in memory of the instrumented prepared statement. For the text protocol, this column is the external statement name assigned by the user. OWNER_THREAD_ID, ... The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary ...
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
Summary of Available Privileges Privilege Descriptions Privilege-Granting Guidelines Summary of Available Privileges The following table shows the privilege names used in GRANT and REVOKE statements, along with the column name associated with each ... The privileges granted to a MySQL account determine which operations the account can ...