Not the answer you need?
Register and ask your own question!

MySQL replication error Got timeout reading communication packets

raghupradeepraghupradeep ContributorCurrent User Role Beginner
We have a simple master slave replication. In master we are creating federated tables and querying it to do bulk insert to a local table. On the master server we are not getting any issues, But, on the slave side we are getting SQL Error : Got timeout reading communication packets on query. Default database : xyz. Query 'INSERT into emp'

We have set max_allowed_packet to 200 Mb on both slave and master, ibdata is 4 Gb fixed. On the server we have enabled innodb_file_per_table.

Is this because, max_allowed_packet is low ? Or is there any particular variable we have to take care while using federated in master and replicating it ?

With Regards
Raghupradeep
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.