On Fri, Aug 13, 2004 at 01:19:14AM -0500, Donny Simonton wrote: > > There is only one thread for replication on the slave. It does one > step a time. If you use mysqlbinlog on one of your binary files on > your master, you will see exactly how it all works.
No, there are 2 threads: the IO (or relay) thread, and the SQL thread. > Multi-threaded would probably cause thousands of problems. Unless > it was threaded per table, but that would still cause problems > because of multi-table deletes and updates. Agreed. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]