Search Results
https://dev.mysql.com/doc/refman/9.7/en/backup-policy.html
In MySQL, these changes are represented in the binary log, so the MySQL server should always be started with the --log-bin option to enable that log. With binary logging enabled, the server writes each data change into a file while it updates data.
https://dev.mysql.com/doc/refman/9.7/en/federated-create.html
To create a FEDERATED table you should follow these steps: Create the table on the remote server. Create the table on the local server with an identical table definition, but adding the connection information that links the local table to the ...
https://dev.mysql.com/doc/refman/9.7/en/function-resolution.html
This section describes how the server recognizes whether the name of a built-in function is used as a function call or as an identifier, and how the server determines which function to use in cases when functions of different types exist with a ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-benchmarking.html
If InnoDB is not the default storage engine, you can determine if your database server and applications work correctly with InnoDB by restarting the server with --default-storage-engine=InnoDB defined on the command line or with ...Since changing ...
https://dev.mysql.com/doc/refman/9.7/en/multiple-windows-services.html
On Windows, a MySQL server can run as a Windows service. For the following instructions, suppose that you want to run the mysqld server from two different versions of MySQL that are installed at C:\mysql-5.7.9 and C:\mysql-9.7.0, respectively. The ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-security-networking-issues.html
Any ndb_mgm client This means that any cluster management client that is given the management server's host name (or IP address) and port (if not the standard port) can connect to the cluster and execute any management client command. You can ... In ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-socket-instances-table.html
The socket_instances table provides a real-time snapshot of the active connections to the MySQL server. Information available in this table provides a real-time snapshot of the active connections to the server. row *************************** ...
https://dev.mysql.com/doc/refman/9.7/en/replication-asynchronous-connection-failover.html
The asynchronous connection failover mechanism can be used to keep a replica synchronized with multiple MySQL servers or groups of servers that share data. The list of potential source servers is stored on the replica, and in the event of a ... You ...
https://dev.mysql.com/doc/refman/9.7/en/workbench.html
MySQL Workbench provides a graphical tool for working with MySQL servers and databases. MySQL Workbench may connect to MySQL Server 8.4 and higher but some MySQL Workbench features may not function with those newer server versions. MySQL Workbench ...For more information, see the MySQL Workbench manual, available at ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/index.html
Abstract This is the user manual for MySQL Enterprise Backup, a commercially licensed backup utility for MySQL databases. It explains the different kinds of backup and restore that can be performed with MySQL Enterprise Backup, and describes the ...