Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 7 Years, 8 Months, 3 Weeks ago MYBB reduce the server response time?
#1
Solved: 7 Years, 8 Months, 3 Weeks ago
Please share your tips on how to reduce server load for MYBB?

Is this save to do??????


Quote:Step 5: Change your mybb_sessions table to a HEAP. (MEMORY) This table will be stored in the memory for increased performance. Go into PHPMYADMIN, click on your forum's database, find mybb_sessions, click on it, then press 'operations' at the top and change it to MEMORY.
http://community.mybb.com/thread-93652.html
#2
Solved: 7 Years, 8 Months, 3 Weeks ago
This user has been denied support. This user has been denied support.
Yes it's "save" to do, but each time you restart the sql server it will clear the amount of user online count and data.
Beep Boop          
                                          ~ RIP Server 2014-2014
#3
Solved: 7 Years, 8 Months, 3 Weeks ago
Unless you start removing code for features you don't want, there's not too much you'll be able to do that'll make much of a difference unless you have a really large forum (i.e. 1mil+ posts and hundreds of users online at a time). Until you start getting a larger, more active site, any changes you make with have a negligible or non-existent effect.
MyReactions - All Plugins

Can you still feel the butterflies?

Free never tasted like pudding.
#4
Solved: 7 Years, 8 Months, 3 Weeks ago
Does type of server has something to do with respond time?
#5
Solved: 7 Years, 8 Months, 3 Weeks ago
Yes, shared hosting is generally slowest (Hundreds of users/sites on the one server all with active sites). VPS is generally better (but can also be oversold depending on the provider) - but you have the ability to configure the server to run one application well (proper PHP cache/MySQL buffers make a notable difference in load times - and you can't configure that on shared hosting). Obviously dedicated is likely to be the fastest, but unless you have hundreds of users active at once it wouldn't even be worth considering.
#6
Solved: 7 Years, 8 Months, 3 Weeks ago
Cool good to know that Smile
#7
Solved: 7 Years, 8 Months, 3 Weeks ago
Yes changing mybb_sessions table to MEMORY engine helps. It uses the RAM on the server.
That table is the most used in MyBB.

Also note that enabling GZIP compressing might slow your server response. This is because the server might have already enabled compressing and you enabling it from MyBB may cause it to compress two times. So check it before doing so.

Servers with SSD instead of a normal HDD, will help significantly.
#8
Solved: 7 Years, 8 Months, 3 Weeks ago
(2014-08-28, 12:20 PM)Rakes Wrote: Yes it's "save" to do, but each time you restart the sql server it will clear the amount of user online count and data.

Hi, could you please tell me what do you mean by "restart the sql server" And what data will be lost. Are you saying the data will be lost forever?
#9
Solved: 7 Years, 8 Months, 3 Weeks ago
Yes, data in a MEMORY table only exists until MySQL is restarted. That isn't really a problem for the sessions table as the only thing lost would be the list of current users/guests (and on their next page load they'd show up again).
#10
Solved: 7 Years, 8 Months, 3 Weeks ago
By how much this will improve server responds time or performance?


Forum Jump:


Users browsing this thread: 1 Guest(s)