PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-performance.html
Figure 19.3 Using an Additional Replication Source to Improve Performance For this to work, you must configure the MySQL instances as follows: Source 1 is the primary source where all changes and updates are written to the database. If your replicas ...Also, as each replica must receive a full copy of the source's binary log, the network load on the source may also increase and create a ... As the number ...
https://dev.mysql.com/doc/refman/8.0/en/reset-replica.html
This statement is meant to be used for a clean start; it clears the replication metadata repositories, deletes all the relay log files, and starts a new relay log file. To use RESET REPLICA, the replication SQL thread and replication I/O (receiver) ... RESET REPLICA [ALL] [channel_option] channel_option: FOR CHANNEL channel RESET REPLICA makes the replica forget its position in the source's binary ...
https://dev.mysql.com/doc/refman/8.0/en/security.html
When thinking about security within a MySQL installation, you should consider a wide range of possible topics and how they affect the security of your MySQL server and related applications: General factors that affect security. These include ...The ...
https://dev.mysql.com/doc/refman/8.0/en/symbolic-links-to-tables.html
Note Symbolic link support as described here, along with the --symbolic-links option that controls it, and is deprecated; expect these to be removed in a future version of MySQL. To determine whether your system supports symbolic links, check the ...For files used by tables for other storage engines, you may get strange problems if you try to use symbolic ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-replication.html
2013-09-24T13:04:38.639684Z 49 [Note] Replication I/O thread: connected to source 'root@localhost:13000', replication started in log '0.000001' at position 114 Testing the InnoDB memcached Replication Configuration This example demonstrates how to ... Because the daemon_memcached plugin supports the MySQL binary log, source server through the memcached interface can be replicated for backup, balancing intensive read workloads, and high ...
https://dev.mysql.com/doc/refman/8.0/en/processlist-access.html
For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. The following discussion enumerates the sources of process information, the privileges required ...The other sources have negative performance consequences because they require a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-administration-status.html
row *************************** Id: 10 User: root Host: replica1:58371 db: NULL Command: Binlog Dump Time: 777 State: Has sent all binlog to slave; waiting for binlog to be updated Info: NULL Because it is the replica that drives the replication ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.html
To update cached values at any time for a given table, use ANALYZE TABLE. Even with file-per-table mode with each InnoDB table in a separate .ibd file, change buffering can delay the write to the data file, so the file modification time is different ...The information_schema_stats_expiry system variable defines the period of time before cached table statistics ...If there are no cached ...
https://dev.mysql.com/doc/refman/8.0/en/view-updatability.html
Some views are updatable and references to them can be used to specify tables to be updated in data change statements. Derived tables and common table expressions can also be specified in multiple-table UPDATE and DELETE statements, but can only be ...That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-restarting-group.html
The replication group must therefore be restarted beginning with the most up to date member, that is, the member that has the most transactions executed and certified. You must therefore restart each member to check the transactions, compare all the ...As long as the remaining members are a majority of the group they can elect a new primary and continue to function as a ... Group Replication is designed to ensure that the database service is continuously available, even if ...