PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-solutions-performance.html
As the number of replicas connecting to a source increases, the load, although minimal, also increases, as each replica uses a client connection to the source. If you are using a large number of replicas connected to one source, and that source is ...Also, as each replica must receive a full copy of the source's binary log, the network load on the source may also increase and create a ...
https://dev.mysql.com/doc/refman/9.7/en/roles.html
Like user accounts, roles can have privileges granted to and revoked from them. A user account can be granted roles, which grants to the account the privileges associated with each role. This enables assignment of sets of privileges to accounts and ...
https://dev.mysql.com/doc/refman/9.7/en/starting-server-troubleshooting.html
If you do not get an error message like telnet: Unable to connect to remote host: Connection refused, some other program is using the TCP/IP port that mysqld is trying to use. In this case, specify the same non-default port number for client ...
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-setup-disable-thread.html
Given a connection ID, disables Performance Schema instrumentation for the thread. Example Disable a specific connection by its connection ID: mysql> CALL sys.ps_setup_disable_thread(225); +-------------------+ | summary | +-------------------+ | ...This is a value of the type given in the PROCESSLIST_ID column of the Performance Schema threads table or the Id column of SHOW PROCESSLIST ...
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-setup-enable-thread.html
Given a connection ID, enables Performance Schema instrumentation for the thread. Example Enable a specific connection by its connection ID: mysql> CALL sys.ps_setup_enable_thread(225); +------------------+ | summary | +------------------+ | ...
https://dev.mysql.com/doc/refman/9.7/en/sys-session-ssl-status.html
For each connection, this view displays the SSL version, cipher, and count of reused SSL sessions. The session_ssl_status view has these columns: thread_id The thread ID for the connection.
https://dev.mysql.com/doc/refman/9.7/en/thread-commands.html
Connect Used by replication receiver threads connected to the source, and by replication worker threads. Daemon This thread is internal to the server, not a thread that services a client connection. A thread can have any of the following Command ...
https://dev.mysql.com/doc/refman/9.7/en/windows-testing.html
(Be sure that an account exists that specifies an IP address or you may not be able to connect.) You can force a MySQL client to use a named-pipe connection rather than TCP/IP by specifying the --pipe or --protocol=PIPE option, or by specifying . If ...In this case, start mysqld with the skip_name_resolve system variable enabled and use only localhost and IP addresses in the Host column of the MySQL grant ...
https://dev.mysql.com/doc/refman/9.7/en/xa-states.html
Detached transactions are disconnected from the current session following execution of XA PREPARE (and can be committed or rolled back by another connection). When XA transactions are detached, a connection has no special knowledge of any XA ... An ...
https://dev.mysql.com/doc/refman/9.7/en/account-categories.html
To kill a session or statement that is executing with the SYSTEM_USER privilege, your own session must have the SYSTEM_USER privilege, in addition to any other required privilege (CONNECTION_ADMIN or the deprecated SUPER privilege). If the user that ... MySQL incorporates the concept of user account categories, based on the SYSTEM_USER ...