April 2, 2016 in Classic self-hosted technical help
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.
Archive posts won't show in search - sorry...
What is your site and which forum?
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.
All the background processes are completed.
Also can you please let me know changing the storage to Mysql will help?
Won't help. Need the following:
Server: Is it dedicated, vps, or shared hosting? How much memory?
Also Mysql version and PHP version.
Dedicated server, 12 gb ram,
Sql version: 5.5.48
Php version: 5.4.45-cll
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.
Move to MySQL 5.6 and php 5.6 would help.
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.
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.
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:
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....
This topic is now archived and is closed to further replies.
Started September 8
Started Monday at 08:54 AM
Started April 7