Locked mysql while delete IP (huge tables)

[phpclub]

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

Lock over 1020 sek !!!

 

[phpclub]

xf_ip have 567 812 records

 

[Mike]

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.

 

[Gene Steinberg]

For those who don't understand this, do we run this as a query in PHPMyAdmin?

 

[Jake Bunce]

Yes, you can run queries in the SQL tab in phpmyadmin.