Locked mysql while delete IP (huge tables)

phpclub

Member
DELETE FROM `xf_ip` WHERE (
content_type = 'post' AND content_id IN ( 584317 )
)

Lock over 1020 sek !!!
 

Mike

XenForo developer
Staff member
Well, there's an index on those 2 columns in particular. And it's probably only deleting one record, so I'm unsure why that would take so long. There's no reason for it to. It's optimized as much as possible.
 
Top