Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-administration-status.html
The MySQL Performance Schema contains replication tables that provide this information in a more accessible form. The replication heartbeat information shown in the Performance Schema replication tables lets you check that the replication connection ... The most common task when managing a replication process is to ensure that replication is taking place and that there have been no errors between the replica and the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-invoked.html
You can do this by storing in a separate table the event names from the SELECT statement shown previously, or using ALTER EVENT statements to rename the events with a common prefix such as replicated_ to identify them. If you rename the events, then ... Replication of invoked features such as loadable functions and stored programs (stored procedures and functions, triggers, and events) provides the following characteristics: The effects of the feature are always ...
https://dev.mysql.com/doc/refman/8.4/en/replication-functions-async-failover.html
Source lists are stored in the mysql.replication_asynchronous_connection_failover and mysql.replication_asynchronous_connection_failover_managed tables, and can be viewed in the Performance Schema replication_asynchronous_connection_failover table.
https://dev.mysql.com/doc/refman/8.4/en/replication-problems.html
If the replica is running, check whether it established a connection to the source. Then make the replica's table identical to the source's and run START REPLICA. If you are sure that the replica started out perfectly synchronized with the source, ... If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for ...
https://dev.mysql.com/doc/refman/8.4/en/replication-setup-replicas.html
On the source, released the read lock: mysql> UNLOCK TABLES; On the replica, edited the MySQL configuration. You can list the events on a server using the SHOW statement or the Information Schema EVENTS table. By default, these repositories are ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups-read-only.html
Note The instructions in this section place the server to be backed up in a state that is safe for backup methods that get the data from the server, such as mysqldump (see Section 6.5.4, “mysqldump — A Database Backup Program”). You should not ...
https://dev.mysql.com/doc/refman/8.4/en/row-constructor-optimization.html
Consider the following table, which has a primary key on (c1, c2, c3): CREATE TABLE t1 ( c1 INT, c2 INT, c3 INT, c4 CHAR(100), PRIMARY KEY(c1,c2,c3) ); In this query, the WHERE clause uses all columns in the index. row *************************** ...
https://dev.mysql.com/doc/refman/8.4/en/show-privileges.html
row *************************** Privilege: Alter Context: Tables Comment: To alter the table *************************** 2. row *************************** Privilege: Create Context: Databases,Tables,Indexes Comment: To create new databases and ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-thread-trx-info.html
The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and events_statements_history tables. The value should match the THREAD_ID column from some ... Returns a JSON object containing information about a given ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-auto-increment-columns.html
This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum column values and the usage ratio (ratio of used to possible values). Tables in these schemas are excluded ...