Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery-connections.html
Important Distributed recovery can fail if a joining member cannot correctly identify the other members using the host name as defined by MySQL Server's hostname system variable. In this situation you can use MySQL Server's report_host system ...The ... When a joining member connects to an online existing member for state transfer during distributed recovery, the joining member acts as a client on the connection and the existing member acts as a ...When state transfer from the ...
https://dev.mysql.com/doc/refman/8.4/en/load-xml.html
In other words, the FILE privilege affects only whether the client can read files on the server; it has no bearing on whether the client can read files on the local file system. To write data from a table to an XML file, you can invoke the mysql ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-24.html
Bugs Fixed Upon connecting to the server, Connector/C++ executed a number of SHOW [SESSION] VARIABLES statements to retrieve system variable values. Additionally, Connector/C++ was trying to fetch the value of the max_statement_time system variable, ...Typically, the client would see Lost connection to MySQL server during query (CR_SERVER_LOST) or MySQL server has gone away ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-functions.html
On server2, extract that statement from the mysqldump output, and store the GTID set into a local variable, such as $gtid_purged_set. To check, on server1, extract and store gtid_purged from the output into a local variable as done previously, then ...The UUID is the identifier used by the server where the transaction originated, which is normally the value of ... This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by ...
https://dev.mysql.com/doc/refman/8.4/en/install-plugin.html
The shared library must be located in the plugin directory (the directory named by the plugin_dir system variable). By default, plugin_dir is the plugin directory under the directory named by the pkglibdir configuration variable, but it can be ...
https://dev.mysql.com/doc/refman/8.4/en/slow-query-log.html
Slow Query Log Contents When the slow query log is enabled, the server writes output to any destinations specified by the log_output system variable. Enabling the log_slow_extra system variable causes the server to write the following extra fields ...To specify the log destination, use the log_output system variable (as described in Section 7.4.1, “Selecting General Query Log and Slow Query Log Output ... The ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
Input-Line Editing Disabling Interactive History Unicode Support on Windows Displaying Query Results Vertically Using Safe-Updates Mode (--safe-updates) Disabling mysql Auto-Reconnect mysql Client Parser Versus Server Parser Input-Line Editing mysql ... This section provides information about techniques for more effective use of mysql and about mysql operational ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-table-import.html
InnoDB page size is defined by the innodb_page_size variable, which is configured when initializing a MySQL server instance. There are many reasons why you might want to import tables: To run reports on a non-production MySQL server instance to ...
https://dev.mysql.com/doc/refman/8.4/en/statement-caching.html
The max_prepared_stmt_count system variable controls the total number of statements the server caches. The stored_program_cache system variable indicates the approximate number of stored programs the server caches per session. For certain ...(The ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-schema.html
ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated ...The ndb_binlog_index and ndb_apply_status tables are created in the mysql ...