Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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 ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-general-using-deploying.html
Possible reasons include: To allow local UNIX domain socket connections to the application, instead of TCP/IP. Note Unix domain sockets can function with applications connecting to MySQL Router, but not for MySQL Router connecting to a MySQL Server.
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-innodb-cluster.html
MySQL Router also makes this possible by having applications connect to MySQL Router instead of directly to MySQL. During bootstrap, Router connects to the cluster, fetches its metadata, and configures itself for use. For example, passing in ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-server-starting.html
Although Router searches a predetermined list of default paths for the configuration file, it is common to start Router by passing in a configuration file with the --config option. The process of configuring MySQL Router to automatically start when ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/admin-api-bootstrapping-router.html
To bootstrap MySQL Router at the command-line, pass in the --bootstrap option when you start the mysqlrouter command, and it retrieves the topology information from the metadata and configures routing connections to the server instances. Once MySQL ... You bootstrap MySQL Router against an InnoDB ReplicaSet or InnoDB Cluster to automatically configure ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/admin-api-overview.html
Important MySQL Shell enables you to connect to servers over a socket connection, but AdminAPI requires TCP connections to a server instance. In addition to this documentation, there is developer documentation for all AdminAPI methods in the MySQL ...AdminAPI is accessed through the dba global variable and its associated ...