tag:blogger.com,1999:blog-9188714267863327820.post8644811924287489816..comments2024-03-20T03:06:52.713-04:00Comments on J-F Gagné's MySQL Blog: An update on Write Set (parallel replication) bug fix in MySQL 8.0Jean-François Gagnéhttp://www.blogger.com/profile/12267071794432977020noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-9188714267863327820.post-75567699799030555972018-01-05T09:58:19.864-05:002018-01-05T09:58:19.864-05:00The primary key is different in my case (like in y...The primary key is different in my case (like in your case).<br /><br />Look at the intervals:<br /><br />#180105 22:18:19 [...] last_committed=9 sequence_number=10 [...] delete from t2 where str='d';<br />#180105 22:18:22 [...] last_committed=5 sequence_number=11 [...] insert t2(str) value('D');<br /><br />Even with a UNIQUE KEY on str, those 2 transactions can be run in parallelJean-François Gagnéhttps://www.blogger.com/profile/12267071794432977020noreply@blogger.comtag:blogger.com,1999:blog-9188714267863327820.post-18678421853593827842018-01-05T09:37:47.497-05:002018-01-05T09:37:47.497-05:00mysql [localhost] {msandbox} ((none)) > show va...mysql [localhost] {msandbox} ((none)) > show variables like '%coll%';<br />+----------------------+--------------------+<br />| Variable_name | Value |<br />+----------------------+--------------------+<br />| collation_connection | utf8mb4_0900_ai_ci |<br />| collation_database | utf8mb4_0900_ai_ci |<br />| collation_server | utf8mb4_0900_ai_ci |<br />+------Obeahttps://www.blogger.com/profile/11046734511358529566noreply@blogger.com