[MediaWiki-l] Mediawiki MySQL user-related database [dead]locks?

Jan Steinman Jan at EcoReality.org
Sun Sep 18 17:37:42 UTC 2016


Are you using InnoDB?

This sounds like a MyISAM issue.

MyISAM does table level locking. InnoDB does row locking. So a transaction should not hang in InnoDB unless two processes are attempting to modify the same record, whereas it can happen in MyISAM if two processes are trying to modify the same table.

    Jan Steinman
    EcoReality Co-op, http://www.EcoReality.org
    2152 Fulford-Ganges Road
    Salt Spring Island, BC V8K 1Z7 CANADA
    +1 250.653.2024






More information about the MediaWiki-l mailing list