..but the core problem is all of the
> tables in the master DB were vbulletin default MyISAM, which was causing
> entire table locks on the user table (which almost any action updated),
> and sometimes the threads table. As a result, runaway lock waiting
> processes were piling up.
>
> I've converted the tables to IoDB which allows for per-row locking,
> and things seem to be better. Eventually we should probably convert all
> tables, but the posts table is likely to result in several hours of hard
> downtime, and this appears to be sufficient for now.
برچسب:
نویسنده: استخدام کار