Tips to increase mybb performence

[remshad]

Hey ,
Am not an expert on PHP,MYSQL but i can share something for mybb community

in my experiment i found
often using table data in MYBB forum is mybb_sessions , presently the storage engine for this table is MyIsm ... But if we change this to MEMORY ... The performance will increase well drastically ... But there could be an issue of RAM memory eating .. If we use storage engine as MEMORY ...

Use below steps to solve the issue ... And enjoy better performance

1.upload 10minutes.php in to inc/tasks ( available in attachment of given link http://kreview.com/t-Tips-to-increase-mybb-performence)
2.Login to mybb admin and open page "Tools And Maintenance"
3.Open "Task Manager" available in left menus
4.open "Add New Task"
5. Select "Task File" as 10minutes.php and fill " Title *" and "Short Description * " as "flush session 10 minute"
6. Fill "Minutes" as 0,10,20,30,40,50
7. All other input fields no need to change (Default is enough)

Below steps do after login to CPanel
8. Login to "phpmyadmin" and navigate your database then open the table named "mybb_sessions"
9.On top menu there is an option "Operations" having a spanner icon ... open it
10.Under "Table options" select box for "Storage Engine" select "MEMORY"
then "Go"



Thats ... You done alll ....

---

Another is in Home » Board Settings » Server and Optimization Options

set "NO" to "Output template start/end comments? " (it need only in debugging or designing)
set "NO" to "Enable Forum Jump Menu?" i believe this feature is not impacting to user experiance

[Leefish]

So what does this actually do?

Will it mean I am logged out every ten minutes?

[remshad]

no ... it just delete 10 minutes back "mybb_sessions"
( navigation/"page viewed" history )

you can increase time gap from 10 minute to higher ,,,

but you must consider that much additional RAM memory....

[StefanT]

Sessions are removed after one day which is IMHO no problem even on big boards as it doesn't store anything big.

[remshad]

I know there is nothing big storing in sesson

but session data is modifying frequently , so there's great chance of performance degradation and table corruption ... for active or big mybb forum's...

in mysql qury execution time is directly proportional to table size...

fetching data from small table give quick result

I don't know why we are keeping session data for a day long..!

[Will P]

Really the sessions table should be InnoDB so it locks at a row level rather than a table level, that will increase performance.

[User 12076]

All possible tables should be InnoDB. MyISAM "is dying".
Of course, there is problem with fulltext indexes - it's very efficient method, but we can use it only on MyISAM (MySQL 5.6 introduces fulltext in InnoDB).

I think, however, sessions isn't problem.
Problem is that mybb parse posts every time.
Problem is that mybb always mark thread as read.
Problem is that forums and permissions table can be very, very big.

And problem is that... users can easily install plugins
One plugin isn't problem. Two also...
But I often see boards with 30+ plugins, big plugins.
It must be "heavy" for server.

[dragonexpert]

Sessions are removed after one day which is IMHO no problem even on big boards as it doesn't store anything big.

I've had it be an issue on a forum I take care of. We actually had to Truncate the table once recently because it exceeded its limit. To be fair though, it was on a day where big news happened relating to the type of forum it is.

[User 2877]

Sessions best as InnoDB.

HF has a 300-500mb sessions table at any given time. It's perfectly fine. I had serious issues with MyISAM for sessions and even with MEMORY/HEAP. It's been 100% since I moved to InnoDB (MySQL 5.5+).

[seeker]

Sessions best as InnoDB.

HF has a 300-500mb sessions table at any given time. It's perfectly fine. I had serious issues with MyISAM for sessions and even with MEMORY/HEAP. It's been 100% since I moved to InnoDB (MySQL 5.5+).

....
Will it mean I am logged out every ten minutes?

FYI:
(Based on the current version)
You can trim/empty mybb_sessions any time without logging anyone out.

The session tracks your last location, time, IP, etc, but the login cookie uses your uid and login key.

• If the session is deleted from the DB, and the cookie is still valid, then a new session is started and you are still logged in.
  

mybb_adminsessions are totally different and you will be logged out.