In the last episode (Jul 03), mos said: > If I'm replicating a master database to a slave (MyISAM tables), but > the slave is busy serving up web pages, how does it get write access > to the slave's table if it is always being read? TIA
Mysql places inserts in front of selects in its internal queue, so as soon as an insert comes in, subsequent selects will queue up behind it until the insert has finished. You can adjust this for individual queries with the HIGH_PRIORITY and LOW_PRIORITY flags. http://dev.mysql.com/doc/refman/5.0/en/insert.html http://dev.mysql.com/doc/refman/5.0/en/select.html -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
