https://dev.mysql.com/tp-thread-group-state-table.html
CONNECT_THREAD_COUNT The number of threads that are processing or waiting to process connection initialization and authentication. There can be a maximum of four connection threads per thread group; these threads expire after a period of inactivity.
https://dev.mysql.com/transaction-summary-tables.html
For summary tables aggregated by account, host, or user, truncation removes rows for accounts, hosts, or users with no connections, and resets the summary columns to zero for the remaining rows. In addition, each transaction summary table that is ...
https://dev.mysql.com/type-conversion.html
Implicit conversion of a numeric or temporal value to string produces a value that has a character set and collation determined by the character_set_connection and collation_connection system variables. For information about connection character ...
https://dev.mysql.com/unix-signal-response.html
This is like executing a SHUTDOWN statement without having to connect to the server (which for shutdown requires an account that has the SHUTDOWN privilege). One use for SIGUSR1 is to implement log rotation without having to connect to the server ...
https://dev.mysql.com/using-explain.html
When EXPLAIN is used with FOR CONNECTION connection_id rather than an explainable statement, it displays the execution plan for the statement executing in the named connection. See Section 8.8.4, “Obtaining Execution Plan Information for a Named ... The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE ...
https://dev.mysql.com/windows-restrictions.html
Limited number of ports Windows systems have about 4,000 ports available for client connections, and after a connection on a port closes, it takes two to four minutes before the port can be reused. In situations where clients connect to and ... The ...
https://dev.mysql.com/workbench.html
MySQL Workbench provides five main areas of functionality: SQL Development: Enables you to create and manage connections to database servers. As well as enabling you to configure connection parameters, MySQL Workbench provides the capability to ...
https://dev.mysql.com/backup-strategy-example.html
You should include such options as necessary to enable client programs to connect to the MySQL server. InnoDB: Apply batch completed InnoDB: Started mysqld: ready for connections For the cases of file system crashes or hardware problems, we can ...
https://dev.mysql.com/backup-types.html
Online backup methods have these characteristics: The backup is less intrusive to other clients, which can connect to the MySQL server during the backup and may be able to access data depending on what operations they need to perform. This section ...
https://dev.mysql.com/binlog-replication-configuration-overview.html
This means that multiple slaves can be connected to the master and executing different parts of the same binary log. Because the slaves control this process, individual slaves can be connected and disconnected from the server without affecting the ... This section describes replication between MySQL servers based on the binary log file position method, where the MySQL instance operating as the master (the source of the database changes) writes updates and changes as “events” to the binary ...
