ssolstad Posted May 30, 2017 Share Posted May 30, 2017 This might be a really stupid question, but I'll have a go anyway; I'm in the middle of upgrading from 3.4 to the current version of IPB and was asked to run a manual query ALTER TABLE ibf_forums_posts DROP INDEX post; I'm running this query now, but it seems to take forever. How long should such a query take to finis? I understand it is depending on the size of the table, but are there any guidelines/indications you can give? Link to comment Share on other sites More sharing options...
Stuart Silvester Posted May 30, 2017 Share Posted May 30, 2017 As you indicated it really depends on the size of the table, the performance of the server etc. If you have a lot of posts, dropping an index (and then rebuilding them) may take quite a while Link to comment Share on other sites More sharing options...
ssolstad Posted May 30, 2017 Author Share Posted May 30, 2017 It's taken 1 hour and 40 minutes so far... I'm a novise when it comes to sql databases and running scripts, so I believed I might be doing something wrong. I'm using MySQL workbench and I can't find a way to se what is actually going on - I have barely used the workbench before so it is unfamiliar to me... Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.