Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Chinna444 Posted April 2, 2016 Posted April 2, 2016 Hi, We recently upgraded to 4.1.9 and having some performance issues. If anyone can help me out to resolve these issues that will be great. 1) Page load issues. Pages are loading very slow compared to previous version. Out post table size is 5GB and 90% of the posts belong to 1 perticular forum. Other forums are loading fine but the forum with highest number of posts is very slow. Also if i archive the posts will it increase the performance? Will the archived posts show in search results? Please let me know.
Flitterkill Posted April 2, 2016 Posted April 2, 2016 Archive posts won't show in search - sorry... What is your site and which forum?
Flitterkill Posted April 3, 2016 Posted April 3, 2016 Ok, so.. a lot of posts. When you log into the ACP do you still see background processes running? You'd see them right on top of the dashboard. If there is nothing there but the usual stuff then you have no background processes running and we/others can move on to the next step.
Chinna444 Posted April 3, 2016 Author Posted April 3, 2016 All the background processes are completed. Also can you please let me know changing the storage to Mysql will help?
Flitterkill Posted April 3, 2016 Posted April 3, 2016 Won't help. Need the following: Server: Is it dedicated, vps, or shared hosting? How much memory? Also Mysql version and PHP version.
Chinna444 Posted April 3, 2016 Author Posted April 3, 2016 Dedicated server, 12 gb ram, Sql version: 5.5.48 Php version: 5.4.45-cll
Flitterkill Posted April 3, 2016 Posted April 3, 2016 Heading to bed now. If you can pull your my.cnf and php.ini files and attach them here that would help (me and others who put their eyes on this) Might later need to pull some mysql error logs, some other stuff to see if you are getting table/row locks, indexes not working all that well, etc.not sure if that bridge has been crossed with the 4-series yet.
Chinna444 Posted April 6, 2016 Author Posted April 6, 2016 We moved to new dedicated server and things are lot better now. New server has Mysql 5.6 and php5.6 ... Generally with such huge databases what will be the best practices? and also to increase performance do i need to disable any features in our forums? any kind of information will help us. Also if you know where i can find any freelancers that are experienced in IPB forums please let me know.
ASTRAPI Posted April 6, 2016 Posted April 6, 2016 It looks like that you got a dedicated server and do a basic installation of mysql and php so it is normal to not have very good performance..... Installing software without optimizing will never help alone.... You will need system adjustments and optimization of your installed software.
Management Matt Posted April 6, 2016 Management Posted April 6, 2016 If you can archive off some older posts, that will really help. If you have years worth, it's probably worth archiving off topics that haven't had a reply in > 18 months. These topics are still readable but you cannot reply and they do not show in search. Check out our guide for more help:
ASTRAPI Posted April 6, 2016 Posted April 6, 2016 Archiving will help performance but in my opinion in most cases is not good for the forums as it is limiting functionality for members And let's say that you do it now then after a few months you will have the same problem I think it is better to look for a scaling solution than hiding temporary the problem....
Recommended Posts
Archived
This topic is now archived and is closed to further replies.