On Mit, 2003-01-29 at 21:22, Brion Vibber wrote:
Just a note; of our current slowdowns, many are coming from locks on the 'old' table (which is still MyISAM, not the new table type). I'm going to try tweaking the sort buffer a bit, as I notice a lot of the stuck threads are in "sorting" state.
Can we convert it to InnoDB? I think we don't need to take the site down for long to do this, we could do it on a separate machine, then copy the files back and insert all rows which have a newer timestamp (this requires some downtime, but probably not much). Do we have a machine we could use for this?
Regards,
Erik