MySQL Forums
Forum List  »  Replication

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!

Options: ReplyQuote


Subject
Views
Written By
Posted
Only 1 thread works in mysql repliation master node
629
January 17, 2019 09:47PM


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.