PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
21.7.9.1 NDB Cluster Replication: Automating Synchronization of the Replica to the Source Binary Log
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-auto-sync.html
#!/user/bin/perl -w # file: reset-replica.pl # Copyright (c) 2005, 2020, Oracle and/or its affiliates. It is possible to automate much of the process described in the previous section (see Section 21.7.9, “NDB Cluster Backups With NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-schema.html
User intervention is normally not required to create or maintain either of these tables, since both are maintained by the NDB binary log (binlog) injector thread. This table can be updated by the user to perform filtering by database or table. Some ... 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 and in the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-commands.html
Resetting a connection has effects similar to mysql_change_user() or an auto-reconnect except that the connection is not closed and reopened, and re-authentication is not done. For example: $> mysql --prompt="(\u@\h) [\d]> " (user@host) [database]> ... mysql sends each SQL statement that you issue to the server to be ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-innodb-cluster-introduction.html
Advanced users can also take advantage of a multi-primary mode, where all instances are primaries. Operations enable you to create MySQL Router users at the cluster level, to work with the MySQL Routers bootstrapped against the cluster, and so on.
https://dev.mysql.com/doc/refman/5.7/en/mysql-server.html
To run the server as some specific user, add an appropriate user option to the [mysqld] group of the global /etc/my.cnf option file, as shown later in this section. To start up MySQL using this method, append a command like the one following to the ... MySQL distributions on Unix and Unix-like system include a script named mysql.server, which starts the MySQL server using ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-accounts-table.html
This is NULL for an internal thread, or for a user session that failed to authenticate. This is NULL for an internal thread, or for a user session that failed to authenticate. The accounts table contains a row for each account that has connected to ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-filtering.html
Pre-filtering is done by the Performance Schema and has a global effect that applies to all users. Post-filtering is performed on a per-user basis because individual users select which of the available events are of interest. Reasons to use ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-operation.html
The user has a column-level privilege for any of the involved tables. Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. This section describes how the query cache works when it is operational. Section 8.10.3.3, ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-provision-replica.html
For example: mysql -u<user> -p<password> < dumpM1_nopurge.sql mysql -u<user> -p<password> < dumpM2_nopurge.sql On the replica, issue RESET MASTER to clear the GTID execution history (assuming, as explained above, that all the dump files have been ...
https://dev.mysql.com/doc/refman/5.7/en/storage-engines.html
For advanced users, this chapter also contains a description of the pluggable storage engine architecture (see Section 15.11, “Overview of MySQL Storage Engine Architecture”). InnoDB is a transaction-safe (ACID compliant) storage engine for ...