Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/mysql-cluster-install-windows-binary.html
For management nodes and data nodes, it is not necessary to install the MySQL Server binary; however, each management node requires the management server daemon (ndb_mgmd.exe); each data node requires the data node daemon (ndbd.exe or ndbmtd.exe).
https://dev.mysql.com/doc/extending-mysql/9.7/en/adding-loadable-function.html
This directory is given by the value of the plugin_dir system variable. This directory is given by the value of the plugin_dir system variable. For the loadable function mechanism to work, functions must be written in C++ and your operating system ... The MySQL interface for loadable functions provides the following features and capabilities: Functions can return string, integer, or real values and can accept arguments of those same ...
https://dev.mysql.com/doc/internals/en/x-protocol-use-cases-use-cases.html
Topics in this section: Prepared Statements with Single Round-Trip Streaming Inserts SQL with Multiple Resultsets Inserting CRUD Data in a Batch Cross-Collection Update and Delete Prepared Statements with Single Round-Trip In the MySQL ...Figure ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-online-upgrade-combining-versions.html
Group Replication is versioned according to the MySQL Server version that the Group Replication plugin was bundled with. For optimal compatibility and performance, all members of a group should run the same version of MySQL Server and therefore of ...For example, if a member is running MySQL 9.7.0 then that is the version of the Group Replication ...
https://dev.mysql.com/doc/refman/9.7/en/macos-installation-pkg.html
Note Before proceeding with the installation, be sure to stop all running MySQL server instances by using either the MySQL Manager Application (on macOS Server), the preference pane, or mysqladmin shutdown on the command line. For example, for MySQL ... The package is located inside a disk image (.dmg) file that you first need to mount by double-clicking its icon in the ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-general.html
A replication channel requires two MySQL servers acting as replication servers (one each for the source and replica). This means that the replication source MySQL server must be running with --binlog-format=ROW or --binlog-format=MIXED, as ...For ...
https://dev.mysql.com/doc/refman/9.7/en/replication-mode-change-online-disable-gtids.html
This section describes how to disable GTID transactions on servers that are already online. This procedure does not require taking the server offline and is suited to use in production. However, if you have the possibility to take the servers ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/advanced.replica.html
MySQL Enterprise Backup allows you to set up a replica server (referred to as the “replica” below) by backing up the source server (referred to as the “source” below) and restoring the backup on a new replica, without having to stop the ...
https://dev.mysql.com/doc/refman/9.7/en/replication-setup-replicas.html
The Event Scheduler is controlled by the event_scheduler system variable (default ON), so events that are active on the original server run by default when the new replica starts up. To stop all events from running on the new replica, set the ...