xtech Posted May 6, 2015 Share Posted May 6, 2015 Hi,i've just upgraded to 4.0.3. All is going fine (i think), it is taking ages to perform the background tasks (more than a million posts), i suppose it will take about more one day or two, but till now it seems ok.I have one issue though. The "Latest Topics" widget (which is fundamental for me) takes ages to load. With it my main page takes about 7-8 seconds to load. Without it is almost imediate. How can this be? With 3.4.x i had it and i had no problem whatsoever... Alternative suggestions? Link to comment Share on other sites More sharing options...
不中用 Posted May 7, 2015 Share Posted May 7, 2015 Hi,i've just upgraded to 4.0.3. All is going fine (i think), it is taking ages to perform the background tasks (more than a million posts), i suppose it will take about more one day or two, but till now it seems ok.I have one issue though. The "Latest Topics" widget (which is fundamental for me) takes ages to load. With it my main page takes about 7-8 seconds to load. Without it is almost imediate. How can this be? With 3.4.x i had it and i had no problem whatsoever... Alternative suggestions?.Can you try the "customizable topic feed" .. you can do the same thing as "latest topics" with it .. at least you have some more filters to smooth things out .. . Link to comment Share on other sites More sharing options...
Sebbo78 Posted May 7, 2015 Share Posted May 7, 2015 I have same issue with latest topics or posts. If i use latest posts it is 100% sure that my site would go down and i start to receive 500 - timeout errors.Then i could just wait and when my site is live i can remove that widget. I have done it several times. Link to comment Share on other sites More sharing options...
AutoItScript Posted May 7, 2015 Share Posted May 7, 2015 Are you using innodb? Latest Topics uses a query that utterly kills innodb. 3 min query on innodb vs .01 seconds on myisam. I bugged it but no response. Link to comment Share on other sites More sharing options...
Sebbo78 Posted May 7, 2015 Share Posted May 7, 2015 I have Database client version: libmysql - 5.1.73Server type: MySQLServer version: 5.5.40-log - MySQL Community Server (GPL)Protocol version: 10 Link to comment Share on other sites More sharing options...
craigf136 Posted May 7, 2015 Share Posted May 7, 2015 Actually, I've just disabled this on our site, what a massive difference. Link to comment Share on other sites More sharing options...
xtech Posted May 7, 2015 Author Share Posted May 7, 2015 Are you using innodb? Latest Topics uses a query that utterly kills innodb. 3 min query on innodb vs .01 seconds on myisam. I bugged it but no response. I do have innoDB, and i had to disable the widget too.Did you put at the bug tracker? I'll add some pressure to it Is it for that reason that IPS is not using that widget at this board? Link to comment Share on other sites More sharing options...
xtech Posted May 7, 2015 Author Share Posted May 7, 2015 Actually, I've just disabled this on our site, what a massive difference.Indeed! Something must be wrong with those queries! Link to comment Share on other sites More sharing options...
AutoItScript Posted May 7, 2015 Share Posted May 7, 2015 Yeah I bugged it here:http://community.invisionpower.com/4bugtrack/402-latest-topics-widget-has-problems-on-innodb-r5447/ Link to comment Share on other sites More sharing options...
Kirill N Posted May 7, 2015 Share Posted May 7, 2015 Wow thanks so much for noticing this. Link to comment Share on other sites More sharing options...
AutoItScript Posted May 7, 2015 Share Posted May 7, 2015 It took me ages to track down in mysql monitor...Removing access to Activity Stream and disabling Latest Topics made my load go from 10.0 and unable to stay online, to 0.40 and snappy. Link to comment Share on other sites More sharing options...
xtech Posted May 7, 2015 Author Share Posted May 7, 2015 Removing access to Activity Stream...Nice suggestion!Where can you disable that? I cannot find it in ACP? Link to comment Share on other sites More sharing options...
Kirill N Posted May 7, 2015 Share Posted May 7, 2015 Nice suggestion!Where can you disable that? I cannot find it in ACP?System > Applications > System > Activity Stream > Disable Link to comment Share on other sites More sharing options...
xtech Posted May 7, 2015 Author Share Posted May 7, 2015 Thank man! Tried it: another good step forward concerning speed! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.