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

Fixed Upgrade transaction log - Extremely long (hanging?) mysql

kontrabass

Well-known member
#1
I'm glad to see that 1.3 has a user upgrade transaction log, however I cannot view it because of a hanging mysql query. Not sure why this would be... With Waindigo's User Upgrade addon, I can view the transaction log just fine. I uninstalled my other user upgrade addons in case of a conflict. I do have other addons installed, and don't have the time to uninstall all of them to test. Here's the query, as you can see it's been "executing" for 74 minutes


Code:
Kill    56867788    xf2014    192.xxxxxxx:xxxx    xenforo778    Execute    4447    Copying to tmp table    SELECT user_upgrade . * , user . * , log . *
FROM xf_user_upgrade_log AS log
LEFT JOIN xf_user_upg
The user upgrade log has about 30,000 records, and we have a couple hundred thousand users.