Warchamp7 Active member Dec 28, 2013 #1 Currently upgrading a forum with over ten million posts, using the CLI updater. I've been sitting on step 11 for at least an hour or two. MySQL processlist says the state is 'copy to tmp table' Do I just have to wait this out?
Currently upgrading a forum with over ten million posts, using the CLI updater. I've been sitting on step 11 for at least an hour or two. MySQL processlist says the state is 'copy to tmp table' Do I just have to wait this out?
Mike XenForo developer Staff member Dec 28, 2013 #2 Yes, this is an alter on the post table, so MySQL basically rebuilds it. You can tune your MySQL config to potentially speed it up, but not after it's already started. Upvote 0 Downvote
Yes, this is an alter on the post table, so MySQL basically rebuilds it. You can tune your MySQL config to potentially speed it up, but not after it's already started.