Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-status.html
A global status variable may represent status for some aspect of the server itself (for example, Aborted_connects), or the aggregated status over all connections to MySQL (for example, Bytes_received and Bytes_sent). With a SESSION modifier, the ...
https://dev.mysql.com/doc/refman/8.4/en/source-ssl-library-configuration.html
An SSL library is required for support of encrypted connections, entropy for random number generation, and other encryption-related operations. To check whether a mysqld server supports encrypted connections, examine the value of the tls_version ...
https://dev.mysql.com/doc/refman/8.4/en/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/doc/refman/8.4/en/sys-ps-thread-id.html
See Section 14.21, “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. Parameters in_connection_id BIGINT UNSIGNED: ... Note ps_thread_id() is deprecated, and subject to removal in a future MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/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/doc/refman/8.4/en/testing-server.html
The following commands provide simple tests to check whether the server is up and responding to connections: $> bin/mysqladmin version $> bin/mysqladmin variables If you cannot connect to the server, specify a -u root option to connect as root.
https://dev.mysql.com/doc/refman/8.4/en/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/doc/refman/8.4/en/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). Sending the signal enables the flush operations to be performed without having to connect ... On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account that owns the ...
https://dev.mysql.com/doc/refman/8.4/en/using-system-variables.html
(See Section 6.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/doc/refman/8.4/en/workbench.html
MySQL Workbench may connect to MySQL Server 8.4 and higher but some MySQL Workbench features may not function with those newer server versions. MySQL Workbench provides five main areas of functionality: SQL Development: Enables you to create and ...