I've recently set up replication on one of my databases. Both master and slave are running MySQL 3.23.46 on FreeBSD 4.1. The only tables that get updated or inserted into hold approximately 140,000 records, growing at a rate of around 50-100 every day. The issue is it is currently taking approximately 20-30 minutes for an update/insert that occurs on the master to show up on the slave. An insert operation on the master usually only takes a second or so, so it doesn't make sense that it should take so long for the slave to update. There is nothing non-standard about either table - each contains approximately 20 columns, one auto-increment field, and one index.
Hoping someone has some insight into this matter... BTW, both servers are on the same private network, literally being right next to each other, so I know it's not a network issue. David Piasecki --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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