Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-replicas.html
SHOW REPLICAS should be executed on a server that acts as a replication source. Host: The host name of the replica server, as specified on the replica with the --report-host option. This can differ from the machine name as configured in the ... SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-api-definition.html
For information about MySQL server system variables relating to NDB Cluster, see Section 25.4.3.9.2, “NDB Cluster System Variables”. The [mysqld] and [api] sections in the config.ini file define the behavior of the MySQL servers (SQL nodes) and ...If no computer or host name is provided, any host can use this SQL or API ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-log-table.html
Typically, the server writes diagnostics to a file on the server host or to a system log service. Granting the SELECT privilege for the error_log table thus gives clients and applications access to error log contents using SQL queries, enabling DBAs ... Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The Error ...
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/replication-howto-additionalslaves.html
The Event Scheduler is controlled by the event_scheduler system variable, which defaults to ON, so events that are active on the original server run by default when the new replica starts up. On the new replica, edit the configuration and give the ...To stop all events from running on the new replica, set the event_scheduler system variable to OFF or DISABLED on the new ...
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 ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync-installation.html
To enable the plugins, set the appropriate system variable either at runtime using SET GLOBAL, or at server startup on the command line or in an option file. After a plugin has been installed, you control it by means of the system variables ...To ...