Vaso Koutsonikola wrote: > Hi, > I am replicating a table between 2 servers. > The table on the master executes many transactions that should be > replicated to the table on the slave.. > The table on the slave is only readable... > I have noticed that the changes on the master are not replicated at once > but it takes about 2 hours to > get the slave updated.. > When this happens I see on the slaves error log file the error > Error reading packet from server: Lost connection to MySQL server during > query (read_errno 134,server_errno=2013) > and then the slave seems to reconnect to the master. > Has anyone any idea why is this happening? > Is it possible that when I read data from the table on the slave, the > slave cannot be updated because it gets locked or something > like that? > > Thanks.. > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Vaso, What version of mysql and what OS? walt --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
