Board very slow on Windows IIS

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Anti-Spam Guide
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
Locked
paul_f
Registered User
Posts: 8
Joined: Thu Jun 18, 2015 7:22 pm
Name: Paul
Contact:

Board very slow on Windows IIS

Post by paul_f » Thu Jun 18, 2015 7:44 pm

Support Request Template
What version of phpBB are you using? phpBB 3.1.5
What is your board's URL? http://www.ssvc.org.uk
Who do you host your board with? fasthosts dedicated windows box
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? No
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.4
What styles do you currently have installed? prosilver
What language(s) is your board currently using? english
Which database type/version are you using? MySQL 5
What is your level of experience? New to PHP but not phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? At the weekend we upgraded from phpBB 3.0.12 to 3.1.4
I then subsequently upgraded from 3.1.4 to 3.1.5.
Please describe your problem. The board is running on a Windows box dual core 4gb Windows 2008

The board has become very slow, and the CPU usage of both cores is nearly continuously at 100%

I am not certain if this is since the upgrade from 3.0.12 or whether it is the latest upgrade. I suspect it is the latest one.

I have disabled search, this does not significantly reduce the server load. If I disable the board, the server load drops to almost nothing.

The mysql log on the server is huge, this has been disabled now but I am struggling to open it.

The slow query log does not have much in it.

In the phpbb error log I have instances of the following every 2 hours, but I don't think it is related

Error while creating image
» Error in [ROOT]/phpbb/search/fulltext_mysql.php on line 90: Missing argument 8 for phpbb/search/fulltext_mysql::__construct(), called in [ROOT]/phpbb/cron/task/core/tidy_search.php on line 61 and defined
Generated by SRT Generator
Last edited by paul_f on Thu Jun 18, 2015 9:35 pm, edited 1 time in total.

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

Re: Board very slow on Windows IIS

Post by david63 » Thu Jun 18, 2015 8:40 pm

paul_f wrote:In the phpbb error log I have instances of the following every 2 hours, but I don't think it is related

Error while creating image
» Error in [ROOT]/phpbb/search/fulltext_mysql.php on line 90: Missing argument 8 for phpbb/search/fulltext_mysql::__construct(), called in [ROOT]/phpbb/cron/task/core/tidy_search.php on line 61 and defined
That is a reported bug in 3.1.5 - https://tracker.phpbb.com/browse/PHPBB3-13952

It is a known fact that 3.1.x requires more resources than 3.0.x which may be the cause of your server running slow
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

paul_f
Registered User
Posts: 8
Joined: Thu Jun 18, 2015 7:22 pm
Name: Paul
Contact:

Re: Board very slow on Windows IIS

Post by paul_f » Thu Jun 18, 2015 9:40 pm

I had heard that it had increased resources, but this is a dedicated server for our website so I would be very surprised if it the usage should have increased to an almost constant 100% when previously it was fairly low as surely many people run this board on shared hosting without problems

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Board very slow on Windows IIS

Post by Oyabun1 » Thu Jun 18, 2015 10:56 pm

paul_f wrote:At the weekend we upgraded from phpBB 3.0.12 to 3.1.4
How did you do that?
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

paul_f
Registered User
Posts: 8
Joined: Thu Jun 18, 2015 7:22 pm
Name: Paul
Contact:

Re: Board very slow on Windows IIS

Post by paul_f » Fri Jun 19, 2015 5:30 am

Oyabun1 wrote:
paul_f wrote:At the weekend we upgraded from phpBB 3.0.12 to 3.1.4
How did you do that?
We had quite a few mods on the old install, so I followed the instructions on this thread to upgrade

https://www.phpbb.com/customise/db/offi ... pic/132936

paul_f
Registered User
Posts: 8
Joined: Thu Jun 18, 2015 7:22 pm
Name: Paul
Contact:

Re: Board very slow on Windows IIS

Post by paul_f » Fri Jun 19, 2015 8:57 pm

It seems the load is all on the mysql database as it is mysqld.exe

When I look at phpmyadmin I seem to have sent a lot of data from the database in the past 24 hours, especially as i haven't got many users.
Capture.PNG
The phpmyadmin advisors has the following suggestions - should I look at some of these:
  • {long_query_time} is set to 10 seconds or more, thus only slow queries that take above 10 seconds are logged.
    Less than 80% of the query cache is being utilized.
    The query cache is considerably fragmented.
    Cached queries are removed due to low query cache memory from the query cache.
    The max size of the result set in the query cache is the default of 1 MiB.
    There are lots of rows being sorted.
    There are too many joins without indexes.
    The rate of reading the first index entry is high.
    The rate of reading data from a fixed position is high.
    The rate of reading the next table row is high.
    {tmp_table_size} and {max_heap_table_size} are not the same.
    Many temporary tables are being written to disk instead of being kept in memory.
    MyISAM key buffer (index cache) % used is low.
    The rate of opening tables is high.
    The rate of opening files is high.
    Too many table locks were not granted immediately.

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Board very slow on Windows IIS

Post by Oyabun1 » Fri Jun 19, 2015 10:27 pm

paul_f wrote: We had quite a few mods on the old install, so I followed the instructions on this thread to upgrade
https://www.phpbb.com/customise/db/offi ... pic/132936
OK then the board should has been correctly updated.

Database server configuration and maintenance is outside the scope of support here. You would do better to ask on a MySQL support site about that sort of thing.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

paul_f
Registered User
Posts: 8
Joined: Thu Jun 18, 2015 7:22 pm
Name: Paul
Contact:

Re: Board very slow on Windows IIS

Post by paul_f » Sat Jun 20, 2015 5:38 pm

I found the cause, some of the the indexes on the phpbb_posts table were missing, and the mysql full text search index wasn't actually created properly - similar to this thread viewtopic.php?f=46&t=2132695

Using another forum I administrate as i guide I manually recreated the indexes and the problem is solved

Cheers
Paul

Locked

Return to “[3.1.x] Support Forum”