MyBB Community Forums

Full Version: 16-30 seconds for a post to post
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2 3 4 5 6
http://www.ej8squad.com

It literally takes about 7-10 for a post to be posted via the quick reply. Today, I upgraded to 1.6 and in doing so I was hoping it would help my problem. For the most part the site load fine but clicking a link from the main index can take a long time.

I've contacted my host (KnownHost) numerous times and they do their thing and everything seems to work for awhile but eventually the posting times goes downhill again.

I will be honest and know very little about configuring and tweaking a Apache server but I would be willing to learn.

Index Stats:
Varies from this
Generated in 0.2255180 seconds (49.75% PHP / 50.25% MySQL)
SQL Queries: 21 / Global Parsing Time: 0.0427160 / Memory Usage: 2.25 MB
PHP version: 5.2.10 / Server Load: 1.25 / GZip Compression: Enabled

To This
Generated in 5.9874780 seconds (9.75% PHP / 90.25% MySQL)
SQL Queries: 21 / Global Parsing Time: 0.2655931 / Memory Usage: 2.25 MB
PHP version: 5.2.10 / Server Load: 1.83 / GZip Compression: Enabled

Posting a simple eBay link takes this long. Deleting the post is equally as long.
Generated in 20.5033500 seconds (1.69% PHP / 98.31% MySQL)
SQL Queries: 22 / Global Parsing Time: 0.0895209 / Memory Usage: 1.75 MB
PHP version: 5.2.10 / Server Load: 2.9 / GZip Compression: Enabled

VPS Stats:
Processor Information
Processor #1 Vendor: AuthenticAMD
Processor #1 Name: Dual-Core AMD Opteron™ Processor 2212
Processor #1 speed: 1995.051 MHz
Processor #1 cache size: 1024 KB

Processor #2 Vendor: AuthenticAMD
Processor #2 Name: Dual-Core AMD Opteron™ Processor 2212
Processor #2 speed: 1995.051 MHz
Processor #2 cache size: 1024 KB

Processor #3 Vendor: AuthenticAMD
Processor #3 Name: Dual-Core AMD Opteron™ Processor 2212
Processor #3 speed: 1995.051 MHz
Processor #3 cache size: 1024 KB

Processor #4 Vendor: AuthenticAMD
Processor #4 Name: Dual-Core AMD Opteron™ Processor 2212
Processor #4 speed: 1995.051 MHz
Processor #4 cache size: 1024 KB

total used free shared buffers cached
Mem: 524288 213944 310344 0 0 0
-/+ buffers/cache: 213944 310344
Swap: 0 0 0
Total: 524288 213944 310344

StartServers=5
MinSpareServers=5
MaxSpareServers=10
MaxClients=150
MaxRequestsPerChild=10000




Active Plugins:
Donation Page (1.1)
Fit on Page (2.3)
Game Section (1.2 RC3.2)
My Awards (1.2)
Online 24 (2.2) <-----users like this
Overview (3.1.1) <---I know the site takes a huge hit with this active but users freak out when I remove this
Private Messages Admin (2.4.1)
Side Boxes! (3.0)
SpiceFuse Shoutbox (1.1 Beta 1) <-----a riot would ensue if I removed this

Please advise!

Jeremy


what is your my.cnf (mysql config) looking like?
how many posts on the site?
are you using fulltext indexing?
how much overhead in your tables (as shown in phpMyAdmin)?
have you "optimized" the post and threads tables?
(2010-10-20, 08:05 PM)pavemen Wrote: [ -> ]what is your my.cnf (mysql config) looking like?
how many posts on the site?
are you using fulltext indexing?
how much overhead in your tables (as shown in phpMyAdmin)?
have you "optimized" the post and threads tables?

Not sure what my .cnf looks like. How do I locate it?
259,749 posts
I typically "optimize all tables that have overhead every-other day
if *nix, get into your shell and do a "locate my.cnf"

are you using fulltext indexing?
I am in the shell account and once in type in "dir" and I can see "my.cnf" but how do I view it to get you the information you are looking for?

Fulltext, are you referring to MyBB's search system? If is then yes I am using "Full Text" instead of "Standard".

EDIT
I logged in via FileZilla and was able to download the "my.cnf" file and the only thing in there are three lines; client, user, and pass.
are you on a VPS or dedicated server?

i noticed that it takes 1-2 seconds just for your host to start to respond. Then another 1-3 seconds to pull the flickr image on the home page.

add those to any issues mysql and/or php are having then it can take a while. but since its mostly post and delete, I have a feeling its something to do with the indexing of the posts table or the mysql config regarding memory settings for table reads and such

Yeah I am on a VPS.

You are correct in saying that it takes 1-2 seconds just for the host to respond. Are you referring to the banner image or the "Picture of the Day"?

Sounds like am at the mercy of KnownHost's tech support because I have no idea how to fix those things that you mentioned.
yes, the pic of the day caused a bit of lag according to my inspection.

you can try to change to standard indexing and see if that helps at all. if so, then switch back to full text indexing and see if that corrects the problem.

the other option is to run a "repair" on the table and that tries to rebuild the index as well. this might be the better option to test first.

of course, make a backup of the table first...

the other parts are going to be dependent on the host settings for mysql. something is up if they do something that fixes it then is progressively gets worse again.
The loading time I can deal with for now it's the eternity that it takes to post a reply or thread that I cannot deal with.

What table are you referring to when you suggest "repair"?
posts and threads tables are the only one with fulltext indexing so it would be those.
Pages: 1 2 3 4 5 6