Shao Hou Kun comments

Results 6 comments of


                                            Shao Hou Kun

gh-ost may lose data when performing DDL on mysql with semi-sync replication enabled

https://github.com/github/gh-ost/pull/1054 No need to use lock. And add a heartbeat between the `addDMLEventsListener` and `ReadMigrationRangeValues` to fix this bug.

If MySQL two-phase commit is time-consuming, it will cause gh-ost to lose data.

👍

How to set the log file path?

我能说中文吗？ T.T，请问怎么打开日志文件呀？

feat concurrent chunk data

MySQL insert ... select ... does not permit concurrent. https://dev.mysql.com/doc/refman/5.7/en/insert-select.html

feat concurrent chunk data

When the unique index used for copying blocks includes an auto-increment column, concurrency is blocked on the auto-inc lock. If the unique index used does not include an auto-increment column,...

analyze table before cutover

When the modified table is a partition table, the execution time of the ANALYZE command will increase as the number of partitions increases. When the ANALYZE statement is synchronized to...