Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-redundant-indexes.html
The schema_redundant_indexes view has these columns: table_schema The schema that contains the table. The x$schema_flattened_keys view has these columns: table_schema The schema that contains the table. The schema_redundant_indexes view displays ...
https://dev.mysql.com/doc/refman/8.4/en/update-optimization.html
Performing multiple updates together is much quicker than doing one at a time if you lock the table. For a MyISAM table that uses dynamic row format, updating a row to a longer total length may split the row. If you do this often, it is very ... An ...