Search Results
https://dev.mysql.com/doc/relnotes/mysql-router/9.7/en/news-9-2-0.html
If set to 0 (default), the metadata_cache keeps the connection open if the refresh succeeded and if the next refresh is to the same MySQL server. (WL #14119) Bugs Fixed Important Change: MySQL Router no longer supports MySQL Server versions from a ... Functionality Added or Changed Bugs Fixed Functionality Added or Changed Added a new close_connection_after_refresh metadata_cache option to control whether a connection remains open for future metadata refresh ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-configuring-io-capacity.html
For busy systems capable of higher I/O rates, you can set a higher value to help the server handle the background maintenance work associated with a high rate of row changes. You can set the innodb_io_capacity value in the MySQL option file (my.cnf ...InnoDB attempts to perform these tasks in a way that does not adversely affect the normal working of the ... The InnoDB master thread and other threads perform various tasks in the background, most of which are I/O related, such as flushing ...
https://dev.mysql.com/doc/refman/9.7/en/replication-privilege-checks-account.html
The REPLICATION_APPLIER privilege explicitly or implicitly allows the PRIVILEGE_CHECKS_USER account to carry out the following operations that a replication thread needs to perform: Setting the value of the system variables gtid_next, ...If you set ...Updating the system tables mysql.gtid_executed, mysql.slave_relay_log_info, mysql.slave_worker_info, and mysql.slave_master_info, to update replication ... The user account that is specified using the CHANGE REPLICATION SOURCE TO statement as the ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-crystal-displaying.html
To display a report we first populate a data set with the data needed for the report, then load the report and bind it to the data set. Finally we pass the report to the crViewer control for display to the user. The following references are needed ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-crystal-displaying.html
To display a report we first populate a data set with the data needed for the report, then load the report and bind it to the data set. Finally we pass the report to the crViewer control for display to the user. The following references are needed ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-top.html
Each thread is represented by two rows in the output, the first showing system statistics, the second showing the measured statistics for the thread. Usage ndb_top [-h hostname] [-t port] [-u user] [-p pass] [-n node_id] ndb_top connects to a MySQL ... ndb_top displays running information in the terminal about CPU usage by NDB threads on an NDB Cluster data ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/restore-performance.html
This section describes the performance considerations for restoring a database server with MySQL Enterprise Backup. The restore operation (except for Table-Level Restore) is always performed with the database server shut down. on the database ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/manage-sandbox-instances.html
The operation fails with a timeout, and the error log contains: 2020-03-26T11:43:12.969131Z 5 [System] [MY-013381] [Server] Server upgrade from '80019' to '80020' started. 2020-03-26T11:44:03.543082Z 5 [System] [MY-013381] [Server] Server upgrade ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-installation-windows-path.html
To make it easier to invoke MySQL programs, you can add the path name of the MySQL bin directory to your Windows system PATH environment variable: On the Windows desktop, right-click the My Computer icon, and select Properties. Next select the ...
https://dev.mysql.com/doc/refman/9.7/en/replica-logs-relaylog.html
The default relay log file and relay log index file names and locations can be overridden with, respectively, the relay_log and relay_log_index system variables (see Section 19.1.6, “Replication and Binary Logging Options and Variables”). On a ...For the default replication channel, relay log file names have the default form host_name-relay-bin.nnnnnn, where host_name is the name of the replica server host and nnnnnn is a sequence ...