binary log

ries. It would stand a better chance of being able to keep up. I'm not expecting real-time replication but after 24 hours, the slave is already 5 hours behind. Sam Jumper Director of Data Acquisition eRealty.com 713-490-7512

Speeding up "copy to tmp table"

What steps can be taken to speed up queries that show state="copy to tmp table" in show processlist? I am running MySql on a dual Xeon system running Windows 2000 server with 10 10K rpm drives in 5 raid 0 arrays and plenty of ram that isn't being utilized. Sam