Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery-connections.html
In this situation you can use MySQL Server's report_host system variable to configure a unique host name to be externalized by each of the servers. Important Distributed recovery can fail if a joining member cannot correctly identify the other ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
This enables the ; delimiter used in the procedure body to be passed through to the server rather than being interpreted by mysql itself. MySQL stores the sql_mode system variable setting in effect when a routine is created or altered, and always ...
https://dev.mysql.com/doc/refman/8.4/en/show-engine.html
The number in the created column is the same as the number of data nodes in the cluster to which the MySQL server has connected. Use SHOW ENGINE PERFORMANCE_SCHEMA STATUS to inspect the internal operation of the Performance Schema code: mysql> SHOW ... SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information about a storage ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-operation.html
Statements blocked on a row lock, table lock, sleep, or any other blocking activity that has not been reported back to the thread pool by MySQL Server or a storage engine. thread_pool_prio_kickup_timer: How long before the thread pool moves a ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-prerequisites.html
Before upgrading to the latest MySQL 8.4 release, ensure the upgrade readiness of your current MySQL 8.3 or MySQL 8.4 server instance by performing the preliminary checks described below. Tip Consider using the MySQL Shell upgrade checker utility ...The upgrade checker works for all Bugfix, Innovation, and LTS releases of ...The upgrade checker utility carries out the automated checks that are relevant for the specified target ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-destination-configuration.html
After the server interprets the default error log destination options, it sets the log_error system variable to indicate the default destination, which affects where several log sink components write error messages. If --log-error is given in an ...
https://dev.mysql.com/doc/refman/8.4/en/multifactor-authentication.html
When a client attempts a connection to the MySQL server using a single-factor account, the server invokes the authentication plugin indicated by the account definition and accepts or rejects the connection depending on whether the plugin reports ...
https://dev.mysql.com/doc/refman/8.4/en/log-destinations.html
MySQL Server provides flexible control over the destination of output written to the general query log and the slow query log, if those logs are enabled. The general_log and slow_query_log variables indicate whether the general query log and slow ...Possible destinations for log entries are log files or the general_log and slow_log tables in the mysql system ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-shell.html
Start MySQL Shell After you have installed and started MySQL server, connect MySQL Shell to the server instance. You need to know the address of the MySQL server instance you plan to connect to. If MySQL Shell is not already running, open a terminal ... This quick-start guide assumes a certain level of familiarity with MySQL ...For example to connect to the instance ds1.example.com on the ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-high-availability-and-clustering.html
Default Value 0 Since Version 5.1.6 ha.loadBalanceStrategy If using a load-balanced connection to connect to SQL servers in a MySQL Cluster configuration (by using the URL prefix "jdbc:mysql:loadbalance://"), which load balancing algorithm should ...