Only 1 thread works in mysql repliation master node
Posted by:
Pan Chen
Date: January 17, 2019 09:47PM
I just updated mysql from 5.1.73(single instance) to 5.7.22 replication(GTID rep mode),but when I run "show processlist;",I found that only 2 user threads established for my code,and only one of them working at the same time.
Same phenomenon even I increased minimum-connection-count from 1 to 10, 10 user threads established but only 1 of them working at the same time.
That's confused, cause I'm using the same code,the same config file as before.
So I tested it on a mysql5.7 single node(almost same my.cnf except some master-slave params),It goes well as before,multi threads works.
I've read some new features for mysql 5.7 replication,still can not find out the reason, anyone any tips? Thanks!
Subject
Views
Written By
Posted
Only 1 thread works in mysql repliation master node
866
January 17, 2019 09:47PM
424
January 20, 2019 10:34PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.