TSP Posted December 11, 2014 Share Posted December 11, 2014 Eventually I decided to do a test upgrade on the smallest board I'll need to upgrade, with 170 000 members and 3 500 000 posts. I'm not sure if it's just that my localhost environment isn't providing enough "computer power" to the upgrade, compared to a real life server enviroment. So far I'm at least seeing quite slow progress. I'm currently on the part where the upgrader upgrades members: «Upgrading members (Upgraded so far: 21000 out of 170705)»It takes approximately 22 seconds for each 350 members, which means that this part will take 3 hours in itself. Is this the normal speed for this part or should I expect faster speed on a live server environment? I guess it's not an easy question to answer, but I would like some input. This worries me, especially since it's not done in a CLI-interface. (Which also contributes to this taking longer time) Link to comment Share on other sites More sharing options...
TSP Posted December 11, 2014 Author Share Posted December 11, 2014 And now I received an error on a step too http://community.invisionpower.com/4bugtrack/error-on-upgrading-members-r743/ The upgrader will take at least half a year for me to test on all communities I need to do Link to comment Share on other sites More sharing options...
Andy Millne Posted December 11, 2014 Share Posted December 11, 2014 You're right it's quite difficult to answer questions like this as it is very much dependent on the hardware used as well as how it is set up. An optimised web server will of course be faster than a development setup and 3 hours for the members step wouldn't be completely surprising on this type of environment but it does seem a little on the slow side. It took us around 2-3 hours to upgrade the 400k members here to give you some sort of comparison.We've made some further tweaks to this step for beta4 so you should see some improvement but it's also worth noting that the members step is by far the most intensive and the posts aren't even touched during the upgrader. Post rebuilding is run as a background task after the upgrade is complete so you can get the site back online as soon as possible. Link to comment Share on other sites More sharing options...
Andy Millne Posted December 11, 2014 Share Posted December 11, 2014 I forgot to add, we also identified an issue with a slow member upgrade using InnoDB specifically and added a fix for this in beta 4. You may wish to alter the table type to MyISAM temporarily to test. Link to comment Share on other sites More sharing options...
Codehusker Posted December 11, 2014 Share Posted December 11, 2014 This worries me, especially since it's not done in a CLI-interface. (Which also contributes to this taking longer time)Are there any plans to add a CLI? Or at least the previous option for large communities that listed the queries to run? Link to comment Share on other sites More sharing options...
Management Charles Posted December 12, 2014 Management Share Posted December 12, 2014 Are there any plans to add a CLI? Or at least the previous option for large communities that listed the queries to run?The system already shows you large queries to run manually. Link to comment Share on other sites More sharing options...
Codehusker Posted December 12, 2014 Share Posted December 12, 2014 The system already shows you large queries to run manually. Previous upgraders did, but I've never seen the option when testing upgrades from v3 to v4. Link to comment Share on other sites More sharing options...
Andy Millne Posted December 12, 2014 Share Posted December 12, 2014 Previous upgraders did, but I've never seen the option when testing upgrades from v3 to v4.Manual queries will be shown in the upgrader if it is being run on a table exceeding 150k rows Link to comment Share on other sites More sharing options...
Codehusker Posted December 12, 2014 Share Posted December 12, 2014 Ah, the old system let anyone opt-in. I have a large community, but shy of 150k members (we're more post heavy). I would appreciate still being able to run the queries manually. Link to comment Share on other sites More sharing options...
bfarber Posted December 15, 2014 Share Posted December 15, 2014 You can create a constants.php and add (adjust the number as desired) <?php define( 'UPGRADE_MANUAL_THRESHOLD', 50000 ); Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.