phpBB 3.2.3 too many database row reads

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
User avatar
boogi
Registered User
Posts: 15
Joined: Sat Feb 20, 2016 5:38 pm

phpBB 3.2.3 too many database row reads

Post by boogi » Sat Oct 27, 2018 5:48 pm

Hi!

Story:
I tried to upgrade phpBB forum from 3.1.8 to 3.2.3, all by this instruction using phpcli tool, process went with no error, users were happily using site for few hours. But I've found that row reads went from small numbers (like 1 million rows read per hour for 3.1.8) to bigger like 70-100 million row reads per hour. I switched back to old version (yup, good old backups), so no big problem for now, but I'd like to eventually upgrade forum version to new one. I can't let it run with so many reads, because it's shared hosting that allow for only limited number of reads per day which this 3.2.3 forum would "eat" in only few hours.

Question:
What can I do about it? I have no idea where to start searching for the problem.
I've turned off all extensions for few hours (and db row reads didn't come lower) so looks like it's not extension problem.
Before 3.1.8, this forum was run under 2.x "phpbb by Przemo" (Polish version; by previous admin), I converted it to 3.1.8 about two years ago, if that's something relevant.
Any help appreciated :) if I'm to provide more information - just ask question. If there is someone willing to take a closer look, I have this 3.2.3 forum running "in shadow" and can provide admin account and so on. Unfortunately, as it's shared hosting, I don't have satisfactory access to logs.
Last edited by boogi on Sat Oct 27, 2018 5:51 pm, edited 1 time in total.

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50667
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: phpBB 3.2.3 too many database row reads

Post by stevemaury » Sat Oct 27, 2018 5:51 pm

Please fill out the Support Request Template and post it back here to enable us to assist you better.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

User avatar
boogi
Registered User
Posts: 15
Joined: Sat Feb 20, 2016 5:38 pm

Re: phpBB 3.2.3 too many database row reads

Post by boogi » Sat Oct 27, 2018 6:00 pm

Support Request Template
What version of phpBB are you using? phpBB 3.2.3
What is your board's URL? http://weryfikatorium.pl/forum323
Who do you host your board with? nazwa.pl (former NetArt)
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? Yes
Do you have any MODs installed? No
Do you have any extensions installed? No
What version of phpBB3 did you update from? phpBB 3.1.8
What styles do you currently have installed? prosilver, Volare (paid one)
What language(s) is your board currently using? polish
Which database type/version are you using? MariaDB
What is your level of experience? Comfortable with PHP and phpBB
What username can be used to view this issue? can provide via DM
What password can be used to view this issue? can provide via DM
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? Went through instruction: https://www.phpbb.com/support/docs/en/3 ... upgrade31/ using phpcli; installed polish language pack, paid Volare style, official phpBB extensions and mChat. Noticed that db row reads went through roof. Disabled extensions, didn't help, so switched back to 3.1.8 (3.2.3 is left for debugging).
Please describe your problem. Too many database row reads per hour while using 3.2.3 - around 100x times than it was for 3.1.8 (100mln vs 1mln db row reads per hour)
Generated by SRT Generator

User avatar
JoshyPHP
Code Contributor
Posts: 1012
Joined: Mon Jul 11, 2011 12:28 am

Re: phpBB 3.2.3 too many database row reads

Post by JoshyPHP » Sat Oct 27, 2018 10:51 pm

It could be reparsing 100,000,000 mChat messages.
I wrote the thing that does BBCodes in 3.2.

User avatar
boogi
Registered User
Posts: 15
Joined: Sat Feb 20, 2016 5:38 pm

Re: phpBB 3.2.3 too many database row reads

Post by boogi » Sun Oct 28, 2018 7:23 pm

Hi, thank you for the tip. I checked it, and they don't keep so many of them (only 2500 last messages to be precise), and also conversion of forum posts and mchat messages is done one time only at install stage.

Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 25318
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: phpBB 3.2.3 too many database row reads

Post by Paul » Sun Oct 28, 2018 7:26 pm

What queries are you seeing in what amounts?
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development

User avatar
boogi
Registered User
Posts: 15
Joined: Sat Feb 20, 2016 5:38 pm

Re: phpBB 3.2.3 too many database row reads

Post by boogi » Sun Oct 28, 2018 7:32 pm

It's shared hosting, so I don't see any. I installed mysql+apache locally, imported two databases (before upgrade 3.1.8 and after upgrade 3.2.3) and will try to do some tests locally and will post here what I've found, probably in next few days.
What I can see on this shared hosting is only basic apache logs (access and error), and apart from mainly "GET /mchat" or "GET /" there is nothing suspicious, and no difference in traffic depending on which forum version I run.

User avatar
Lumpy Burgertushie
Registered User
Posts: 66565
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: phpBB 3.2.3 too many database row reads

Post by Lumpy Burgertushie » Sun Oct 28, 2018 7:42 pm

you could contact your host support since they do have access to the logs etc. they should be able to tell you exactly what is causing it.

there is not really anything in a properly done upgrade that would cause this.

robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

User avatar
david63
Registered User
Posts: 16408
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: phpBB 3.2.3 too many database row reads

Post by david63 » Sun Oct 28, 2018 9:51 pm

boogi wrote:
Sun Oct 28, 2018 7:23 pm
conversion of forum posts and mchat messages is done one time only at install stage.
Not quite - depending on the size of your board the reparsing may be done in batches over several days.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

Post Reply

Return to “[3.2.x] Support Forum”