xtech Posted May 6, 2015 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?
不中用 Posted May 7, 2015 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 .. .
Sebbo78 Posted May 7, 2015 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.
AutoItScript Posted May 7, 2015 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.
Sebbo78 Posted May 7, 2015 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
craigf136 Posted May 7, 2015 Posted May 7, 2015 Actually, I've just disabled this on our site, what a massive difference.
xtech Posted May 7, 2015 Author 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?
xtech Posted May 7, 2015 Author 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!
AutoItScript Posted May 7, 2015 Posted May 7, 2015 Yeah I bugged it here:http://community.invisionpower.com/4bugtrack/402-latest-topics-widget-has-problems-on-innodb-r5447/
AutoItScript Posted May 7, 2015 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.
xtech Posted May 7, 2015 Author Posted May 7, 2015 Removing access to Activity Stream...Nice suggestion!Where can you disable that? I cannot find it in ACP?
Kirill N Posted May 7, 2015 Posted May 7, 2015 Nice suggestion!Where can you disable that? I cannot find it in ACP?System > Applications > System > Activity Stream > Disable
xtech Posted May 7, 2015 Author Posted May 7, 2015 Thank man! Tried it: another good step forward concerning speed!
Recommended Posts
Archived
This topic is now archived and is closed to further replies.