Scalability issues due to tables without primary keys This scalability issue is caused by the usage of tables without primary keys. This issue typically shows itself as contention on the InnoDB dict_sys mutex. Now the dict_sys mutex controls access to the data dictionary. This mutex is used at various places. I will only mention a few of them: During operations such as opening and closing table handles, or When accessing I_S tables, or During undo of a freshly inserted row, or During other data dictionary modification operations such as CREATE TABLE, or Within the “Persistent Stats” subsystem,
Read full article from InnoDB scalability issues due to tables without primary keys
No comments:
Post a Comment