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.
We may want to look at queries using the old table (reads: history list, diffs; sometimes show old version. writes: inserts on page edit; updates on rename; deletes on delete. There _oughtn't_ to be too much contention on this table.) and generally fix stuff up.
-- brion vibber (brion @ pobox.com)
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
wikitech-l@lists.wikimedia.org