MySQL Select * On Every Table During Insert

I have a MySQL database with a single Replica. Statement-Based-Replication is being used.

Every time there is an insert into the Master database, the root user executes a SELECT /*40001 SQL_NO_CACHE / FROM on all the tables. The web application that is using this database, which is set up to read from the Replica, hangs until this query is finished. Several of the tables are large and the query can take ~ 30 seconds where it gets stuck in a "Writing to net" state.

Any ideas how to fix this?

链接地址: http://www.djcxy.com/p/83268.html

上一篇: 通过具有写权限的2台服务器复制Mongodb数据

下一篇: MySQL在插入过程中在每个表上选择*