DB issue help with question to hosting co

Discussion of non-phpBB related topics with other phpBB.com users.
Forum rules
General Discussion is a bonus forum for discussion of non-phpBB related topics with other phpBB.com users. All site rules apply.
Post Reply
User avatar
pollos
Registered User
Posts: 145
Joined: Wed Jul 30, 2003 7:44 pm
Location: Menorca
Contact:

DB issue help with question to hosting co

Post by pollos » Sun Feb 04, 2018 2:01 pm

Hi not directly related to a phpbb problem but any help would be gratefully received.

phpbb forum hosted with present hosting co for several years with no real problems. I have in the past suffered with slow posting but it only lasted a for a few mins. As I'm on shared hosting some other site hammering the db server is something you have to live with.

But for the past week+ static content served fast, forum db reads E.G forum list, posts ect serve as normal, fast, but when posting a new post it takes 20-30 second to return the page, causing double/treble posts and complaints from members.

Am I correct in thinking that the DB server could be the problem? I have asked my hosting co [via online chat] but all they say is "There are no issues with the DB servers at the moment"

I intend to open an e-mail support ticket. So if anyone would care to help a non too MYSQL knowledgeable guy with what should I ask them to check, I'd really appreciate it.

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

Re: DB issue help with question to hosting co

Post by JoshyPHP » Sun Feb 04, 2018 3:09 pm

You should post more info about your install, e.g. http://www.phpbb.com/support/srt/

Also: which search backend do you use, which extensions are installed, etc...
I wrote the thing that does BBCodes in 3.2.

User avatar
thecoalman
Community Team Member
Community Team Member
Posts: 2625
Joined: Wed Dec 22, 2004 3:52 am
Location: Pennsylvania, U.S.A.
Contact:

Re: DB issue help with question to hosting co

Post by thecoalman » Sun Feb 04, 2018 3:49 pm

If this is an issue that has slowly developed over time and you have never optimized the tables in your database it may or may not help but it's something you should do periodically anyway.

First backup your database. Go into your hosting control panel and open phpmyadmin. When you open the database you should be on list of tables, after the list of tables find the link that says "Check all tables with overhead". Next to that from the drop down menu select "optimize". If this is the first time you have done this you may want to select individual tables instead of all of them at once to prevent timeouts.

That said looking at your forum it appears to be fairly active and large to be on a simple low cost shared hosting plan.

User avatar
pollos
Registered User
Posts: 145
Joined: Wed Jul 30, 2003 7:44 pm
Location: Menorca
Contact:

Re: DB issue help with question to hosting co

Post by pollos » Sun Feb 04, 2018 4:50 pm

Hi thanx for the answers.

The version is 3.2.1 the update is downloaded but still to do.
I haven't updates yet as the first thing supports ask is have you made any changes? Gives them a possible excuse to blame the changes/updates made.

Extensions: pages and lightbox.

I do check and optimized the tables in the DB regularly.

It didn't happen slowly, all has run well over several years but 8-10 days ago I noticed that members were double posting and new posts/reply took ages. The first thing I did was to check and optimized the tables. I then contacted support:-
support wrote:I see that currently our server on 10.169.0.65 is experiencing load but it is not critical. If you wish I could migrate your database to another server.
Migration made no difference and when contacted again their response is "There are no issues with the DB servers at the moment"

It is difficult to get past their first line of defence [support staff] and as it happened overnight and no changes were made to the site all I can put it down to is a problem with the DB server.

sakm
Registered User
Posts: 473
Joined: Sun Jan 21, 2007 8:14 pm
Location: Hull, uk
Name: Stu
Contact:

Re: DB issue help with question to hosting co

Post by sakm » Fri Feb 09, 2018 9:27 pm

Is the database hosted on a different server to your files?

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

Re: DB issue help with question to hosting co

Post by JoshyPHP » Fri Feb 09, 2018 10:00 pm

There are several similar posts and the issue is usually related to the DNS blacklist checker.
I wrote the thing that does BBCodes in 3.2.

User avatar
pollos
Registered User
Posts: 145
Joined: Wed Jul 30, 2003 7:44 pm
Location: Menorca
Contact:

Re: DB issue help with question to hosting co

Post by pollos » Sun Feb 11, 2018 3:45 pm

Hi and thanx I have just [the other day] found it was related to the DNS blacklist checker. As it happened over night with no changes at my end I asked my host check their DFB server, looked through every file on the site, comparing with a local backup and an old server backup, looking to see if I had been hacked.

I may have missed something but as it was caused by slow response from the blacklist server I would have expected other phpbb users to have the same problem and request help in the support forum.

Thanx again for the reply

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

Re: DB issue help with question to hosting co

Post by Lumpy Burgertushie » Sun Feb 11, 2018 4:58 pm

that function is turned off by default and most people would not have it turned on. that is probably why you don't see the problem here very often.


robert

User avatar
pollos
Registered User
Posts: 145
Joined: Wed Jul 30, 2003 7:44 pm
Location: Menorca
Contact:

Re: DB issue help with question to hosting co

Post by pollos » Sun Feb 11, 2018 6:39 pm

Oh I must have turned it on at some time, must have been a long time ago .......

Post Reply

Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 47 guests

cron