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!
<Jeremy@stripped> | http://jeremy.zawodny.com/
[book] High Performance MySQL -- http://highperformancemysql.com/
