https://dev.mysql.com/sys-host-summary.html
These views summarize statement activity, file I/O, and connections, grouped by host. The host_summary and x$host_summary views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying ...
https://dev.mysql.com/sys-ps-thread-id.html
See Section 12.22, “Performance Schema Functions” Returns the Performance Schema thread ID assigned to a given connection ID, or the thread ID for the current connection if the connection ID is NULL. in_connection_id BIGINT UNSIGNED: The ID of ... Note As of MySQL 8.0.16, ps_thread_id() is deprecated and will be removed in a future MySQL ...
https://dev.mysql.com/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/sys-user-summary.html
These views summarize statement activity, file I/O, and connections, grouped by user. unique_hosts The number of distinct hosts from which connections for the user have originated. The user_summary and x$user_summary views have these columns: user ...
https://dev.mysql.com/testing-server.html
The following commands provide simple tests to check whether the server is up and responding to connections: shell> bin/mysqladmin version shell> bin/mysqladmin variables If you cannot connect to the server, specify a -u root option to connect as ...
https://dev.mysql.com/thread-pool.html
The default thread-handling model in MySQL Server executes statements using one thread per client connection. As more clients connect to the server and execute statements, overall performance degrades. The plugin implements a thread pool that ...
https://dev.mysql.com/using-system-variables.html
(See Section 4.2.2, “Specifying Program Options”.) The server also maintains a set of session variables for each client that connects. The client's session variables are initialized at connect time using the current values of the corresponding ... The MySQL server maintains many system variables that configure its ...
https://dev.mysql.com/version-tokens-usage.html
Based on the type of statements it will issue (for example, reads versus writes), a client selects an appropriate server and connects to it. The client-side logic for detecting version token errors and selecting a new server can be implemented ...
https://dev.mysql.com/account-locking.html
If a client attempts to connect to a locked account, the attempt fails. The server increments the Locked_connects status variable that indicates the number of attempts to connect to a locked account, returns an ER_ACCOUNT_HAS_BEEN_LOCKED error, and ... MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new ...
https://dev.mysql.com/account-names.html
MySQL account names consist of a user name and a host name, which enables creation of distinct accounts for users with the same user name who can connect from different hosts. The user name part of an account name is either a nonblank value that ...
