GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

XtraDB Cluster locking on drop VS truncate

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • XtraDB Cluster locking on drop VS truncate

    Hi all, i got a question about the behavior of XtraDB Cluster. It seems like all tables are being locked (wsrep in pre-commit stage) if a drop table occur on a not used table. Is this standard behavior? And should there be a difference when i preform a truncate instead of a drop?

  • #2
    Hi,
    Can you describe exactly the sequence of statements that lead to such lock? What DDL method was it - TOI? Was that a big table? How long did the drop take? What is the status of flow control and send/receive queues on the nodes?

    Comment

    Working...
    X