cacheevent table lock wait timeout

[Wayne Luke]

Sorry. Your signature says MySQL 5.6.34.

The growth in the table should not affect transaction locks as long as all of your tables are using INNODB. INNODB performs locks on a row by row basis. The table size is irrelevant. If you are using MYISAM tables anywhere except for the language, phrase, and usertextfield tables, then you can cause TABLE level lockouts which will break transactions. TABLE level lockouts get worse the larger the table is. Since the cache and cacheevent tables are used multiple times on every single page view, this can significantly impact performance if you're using MYISAM.

[OrganForum]

Wayne Luke;n4407269[/LEFT]]
If you are using MYISAM tables anywhere except for the language, phrase, and usertextfield tables, then you can cause TABLE level lockouts which will break transactions.

Did you mean userfield rather than usertextfield? In this post you say userfield. All my tables are INNODB with the exception of language, phrase, and userfield which are MYISAM per your previous post. So should userfield be INNODB and usertextfield be MYISAM?

Sorry. Your signature says MySQL 5.6.34.

Sorry, my bad will fix.

Thanks.

[Wayne Luke]

Sorry, I mean userfield. That table is dynamic and we don't know what size it will be on each site.