How to do safety mirroring innodb table on mysql? I have one Mysql InnoDb table with rush trafik on row update. The table is also frequently used for heavy select query (especially group by for summary report).  As I know this heavy select query will interfere or reduce the update peformance. So i have an idea to mirror this table, so the heavy select query will do in this mirror table (delay 15 menit still accepted).
Fyi, this table have size approximately 10 GB, I have used mysql event (scheduled every 15 minute) to copy this table to another with &quot;insert into select&quot; query. Actually it need more than 60 second for copy process, but the update query still impacted when this event running.
So Is there any best/common practise for mirroring table mysql with minimum impact to currently query (especially update) process on the master table?
Note : I want to do on the same server
Plan A:  Speed up the Summary by building and maintaining a Summary Table:  http://mysql.rjweb.org/doc.php/summarytables .  In particular, this is likely to segregate the summary select, which will now touch only the summary table, from the updates.  And it will
Plan B:  Use replication on the same server.  Be sure to have a different &quot;Port&quot; (such as 3307) for that Replica.  Direct summary requests to that port.  Continue to direct writes to the Primary (your current instance).
Plan C:  If the &quot;update&quot; is just a &quot;Likes&quot; or &quot;Visits&quot; counter, then do the following to avoid some of the interference.  Move that column to a separate table.  The two tables would have the same PRIMARY KEY for ease of JOINing.  The update will avoid interfering with any selects that don't need also need to counter.
Plan D:  Plans A,B,C are independent; do a combination of them.
The repeated copying of the table will (I predict) be poor for both maintenance and performance.