Nice to be here
Last weekend I upgrade one of the largest literary forums in Poland (almost 249 k posts, more than 4 thousand registered users - of course not all are active user type...) - https://weryfikatorium.pl/forum.
The previous phpBB engine was v.3.1.8. Now is v.3.3.1
I have installed and adapted new style (Ravaio from Gramziu, themeforest). I'm frontend developer, so I add some little changes
The forum use several extensions, such as:
- Advanced BBCode Box (v.3.2.4)
- Auto Groups (v.2.0.3)
- Board Announcements (v.1.1.0)
- Board Rules (v.2.1.2)
- Collapsible Forum Categories (v.2.0.0)
- Display Last Post (v.1.2.0)
- Genders (v.1.1.1)
- Google Analytics (v.1.0.5)
- mChat (v.2.1.4)
- Posts merging (v.2.1.0-1 - strange version because I had to modify some core elements, so I added my version number to distinguish from the original)
- QuickReply Reloaded (v.2.0.1-beta4)
- RH Topic Tags (v.3.0.0)
- Robo Configuration 2 (v.2.3.4) - it's a Ravaio Configuration ext, but I modified the original enough that they are not completely compatible anymore :]
- Search user topics (v.1.0.2)
Language pack - polish.
I tried not to change the configuration in the admin panel to keep the settings from the previous version.
I've been working on the modifications for over two months on the forum clone, on separate hosting and when everything (or the vast majority) was ready, I upgraded the forum on last weekend. And it stared...
One more think, searching didn't work on prev version, so I cleared search_wordmatch and search_wordlist tables, and turned on reindexing. The database has grown from less than 1 GB to 2 GB.
The search engine used is phpBB Native Fulltext.
Everything works fine in general, except for one thing: Maybe I was missing something, but suddenly the number of rows read in the database exploded!
Below I am putting links to pictures with server load statistics from my hosting.
CPU time used by scripts: X - the day of mont, Y - time in hh:mm
Time of using the system on the database server during the day: X - date, Y - time
The number of rows readed from databases per server per day: X - date, Y - in milions reads (i'm not sure if I translated it correctly)
this red line is a limit on hosting for single account. As you can see, the limit has been significantly exceeded. The upgrade started on September 18 in the evening, there weren't that many readings before.
Interestingly, the number of database connections has not increased.
Number of database queries:
Please help me! What I'm doing wrong. Or maybe nothing and this is normal behav for v.3.3.1 of phpBB? Or maybe I should change some setting/settings?
Thanks from the mountain!*
Thomas
*it's a joke - it's mean thank you in advance