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
--
FOKUS - Fraunhofer Insitute for Open Communication Systems
Project BerliOS -
http://www.berlios.de