Search Results
https://dev.mysql.com/doc/refman/9.7/en/set-resource-group.html
If the resource group or any named thread ID does not exist, an error occurs. SET RESOURCE GROUP group_name [FOR thread_id [, thread_id] ...] SET RESOURCE GROUP is used for resource group management (see Section 7.1.16, “Resource Groups”).
https://dev.mysql.com/doc/refman/9.7/en/set-transaction.html
transaction_characteristic: { ISOLATION LEVEL level | access_mode } level: { REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | SERIALIZABLE } access_mode: { READ WRITE | READ ONLY } This statement specifies transaction characteristics. It takes ...
https://dev.mysql.com/doc/refman/9.7/en/show-create-user.html
SHOW CREATE USER user This statement shows the CREATE USER statement that creates the named user. The statement requires the SELECT privilege for the mysql system schema, except to see information for the current user. For the current user, the ...
https://dev.mysql.com/doc/refman/9.7/en/show-processlist.html
The SHOW PROCESSLIST statement is very useful if you get the “too many connections” error message and want to find out what is going on. SHOW [FULL] PROCESSLIST Important The INFORMATION SCHEMA implementation of SHOW PROCESSLIST is deprecated ...
https://dev.mysql.com/doc/refman/9.7/en/show-profile.html
For example, SHOW PROFILING is an illegal statement, and a syntax error occurs if you try to execute it, but it shows up in the profiling list. Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future ...
https://dev.mysql.com/doc/refman/9.7/en/show-relaylog-events.html
When using multiple replication channels, if a SHOW RELAYLOG EVENTS statement does not have a channel defined using a FOR CHANNEL channel clause an error is generated. SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] ...
https://dev.mysql.com/doc/refman/9.7/en/show.html
SHOW has many forms that provide information about databases, tables, columns, or status information about the server. The pattern is useful for restricting statement output to matching values. Several SHOW statements also accept a WHERE clause ...
https://dev.mysql.com/doc/refman/9.7/en/silent-column-changes.html
In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. These might be changes to a data type, to attributes associated with a data type, or to an index specification. All changes are ...
https://dev.mysql.com/doc/refman/9.7/en/socket-pluggable-authentication.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%socket%'; +-------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +-------------+---------------+ | auth_socket | ACTIVE | ... The ...
https://dev.mysql.com/doc/refman/9.7/en/source-ssl-library-configuration.html
If the installed OpenSSL version is older than 1.0.1, CMake produces an error at MySQL configuration time. An SSL library is required for support of encrypted connections, entropy for random number generation, and other encryption-related ...