1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Locked mysql while delete IP (huge tables)

Discussion in 'Troubleshooting and Problems' started by phpclub, Nov 9, 2010.

  1. phpclub

    phpclub Member

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

    Lock over 1020 sek !!!
     
  2. phpclub

    phpclub Member

    xf_ip have 567 812 records
     
  3. Mike

    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.
     
  4. Gene Steinberg

    Gene Steinberg Well-Known Member

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

    Jake Bunce XenForo Moderator Staff Member

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

Share This Page