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

Error in OPTIMIZE TABLE xf_template

Discussion in 'General PHP and MySQL Discussions' started by vinafix, Aug 15, 2016.

  1. vinafix

    vinafix Active Member

    Error in OPTIMIZE TABLE `xf_template` -> Lost connection to MySQL server during query
    How to fix?

    Thanks you.
     
  2. Chris D

    Chris D XenForo Developer Staff Member

    How would this be an XF bug? The software itself doesn't run that query, so presumably you're running it directly, or via some sort of client like PhpMyAdmin.

    This kind of error would usually be related to a timeout or other limits.

    Try adjusting wait_timeout and max_allowed_packet values in MySQL.
     
  3. vinafix

    vinafix Active Member

    I do not see it
    wait_timeout
    max_allowed_packet

    in my.cnf

     
  4. Sunka

    Sunka Well-Known Member

    Add it
     
  5. vinafix

    vinafix Active Member

    the same problem.
     
  6. Mike

    Mike XenForo Developer Staff Member

    This is more likely to indicate internal InnoDB corruption, though it could also indicate that you don't have disk space for what you're trying. Look at your MySQL log to see if there's anything of note in there.
     

Share This Page