PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/show-engine.html
SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information about a storage engine. The statement has these variants: SHOW ENGINE INNODB STATUS SHOW ENGINE INNODB MUTEX SHOW ENGINE PERFORMANCE_SCHEMA STATUS SHOW ENGINE ...
https://dev.mysql.com/doc/refman/5.7/en/ssl-libraries.html
MySQL can be compiled using OpenSSL or yaSSL, both of which enable encrypted connections based on the OpenSSL API: MySQL Enterprise Edition binary distributions are compiled using OpenSSL. It is not possible to use yaSSL with MySQL Enterprise ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-information-schema-tables.html
The following sections describe the INFORMATION_SCHEMA tables associated with the thread pool plugin (see Section 5.5.3, “MySQL Enterprise Thread Pool”). They provide information about thread pool operation: TP_THREAD_GROUP_STATE: Information ...
https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html
To prevent fallback and fail if an encrypted connection cannot be obtained, connect like this: mysql --ssl-mode=REQUIRED If the account has more stringent security requirements, other options must be specified to establish an encrypted connection: ... Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-internals.html
The following configuration options are supported by the config_options table: separator: Used to separate values of a long string into separate values when there are multiple value_columns defined. The mapped key must be a non-Null CHAR or VARCHAR ... InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which are directly adopted from embedded ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-select-all.html
Usage ndb_select_all -c connection_string tbl_name -d db_name [> file_name] Options that can be used with ndb_select_all are shown in the following table. --connect-string Command-Line Format --connect-string=connection_string Type String Default ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-select.html
For example: mysql> CREATE TABLE test (a INT NOT NULL AUTO_INCREMENT, -> PRIMARY KEY (a), KEY(b)) -> ENGINE=InnoDB SELECT b,c FROM test2; This creates an InnoDB table with three columns, a, b, and c. Retrained attributes are NULL (or NOT NULL) and, ... You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-virtual-table.html
CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL, `c` int(11) GENERATED ALWAYS AS (5) VIRTUAL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; However, metadata for such a column does appear in the INNODB_SYS_COLUMNS table. The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tables-table.html
Not all storage engines update this time, in which case, the value is always NULL. For views, all TABLES columns are NULL except that TABLE_NAME indicates the view name and TABLE_COMMENT says VIEW. The TABLES table has these columns: TABLE_CATALOG ...
https://dev.mysql.com/doc/refman/5.7/en/obtaining-plugin-information.html
Any that have a PLUGIN_LIBRARY value of NULL are built in and cannot be unloaded. row *************************** PLUGIN_NAME: binlog PLUGIN_VERSION: 1.0 PLUGIN_STATUS: ACTIVE PLUGIN_TYPE: STORAGE ENGINE PLUGIN_TYPE_VERSION: 50158.0 PLUGIN_LIBRARY: ... There are several ways to determine which plugins are installed in the server: The Information Schema PLUGINS table contains a row for each loaded ...