https://dev.mysql.com/set-statement.html
SET CHARACTER SET and SET NAMES assign values to character set and collation variables associated with the current connection to the server. Descriptions for those forms that are not associated with a specific server capability appear in subsections ...
https://dev.mysql.com/set-variable.html
However, the change affects the corresponding session value only for clients that connect after the change. qualifier: SET PERSIST max_connections = 1000; SET @@PERSIST.max_connections = 1000; This SET syntax enables you to make configuration ...
https://dev.mysql.com/setup-actors-table.html
The setup_actors table contains information that determines whether to enable monitoring and historical event logging for new foreground server threads (threads associated with client connections). This table has a maximum size of 100 rows by ...
https://dev.mysql.com/setup-instruments-table.html
For example, the wait/synch/mutex/sql/THD::LOCK_query_plan mutex is created each time a session connects, and destroyed when the session disconnects. The setup_instruments table lists classes of instrumented objects for which events can be ...
https://dev.mysql.com/show-grants.html
SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 6.2.4, “Specifying Account Names”) | role (see Section 6.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...
https://dev.mysql.com/show-slave-hosts.html
SHOW SLAVE HOSTS Displays a list of replication slaves currently registered with the master. SHOW SLAVE HOSTS should be executed on a server that acts as a replication master. Host: The host name of the slave server as specified on the slave with ...
https://dev.mysql.com/shutdown.html
SIGTERM enables server shutdown to be performed without having to connect to the server. SHUTDOWN provides an SQL-level interface to the same functionality available using the mysqladmin shutdown command or the mysql_shutdown() C API function.
https://dev.mysql.com/slave-logs.html
The master info log contains status and current configuration information for the slave's connection to the master. During replication, a slave server creates several logs that hold the binary log events relayed from the master to the slave, and ...
https://dev.mysql.com/solaris-installation.html
If too many processes try to connect very rapidly to mysqld, you should see this error in the MySQL log: Error in accept: Protocol error You might try starting the server with the --back_log=50 option as a workaround for this. Note MySQL 8.0 ...
https://dev.mysql.com/source-installation-prerequisites.html
An SSL library is required for support of encrypted connections, entropy for random number generation, and other encryption-related operations. Some of these tools are needed no matter whether you use a standard source distribution or a development ...
