2010-03-19, 06:42 PM
Over the last few weeks my guild's forum has gone from sluggish to practically unavailable at times. I've made no code changes other than to do more compression after this started. Everything seems to be an SQL issue. The forum is small and not very active www.sodalityguild.org/forums . We're a tiny guild and might generate 10 posts a day.
Our hosting is godaddy and they swear up and down it isn't on their end and that they cannot replicate the issue which I find hard to believe. Everyone else can!
I've been watching the messages at the bottom of the forum to track "times when it is slow" for them.
14:21
Generated in 36.0449769 seconds (0.42% PHP / 99.58% MySQL)
SQL Queries: 24 / Global Parsing Time: 24.0214128 / Memory Usage: 3 MB
PHP version: 5.2.5 / Server Load: / GZip Compression: Enabled
14:22
Generated in 22.4091010 seconds (0.67% PHP / 99.33% MySQL)
SQL Queries: 60 / Global Parsing Time: 10.0592830 / Memory Usage: 3.5 MB
PHP version: 5.2.5 / Server Load: / GZip Compression: Enabled
14:38
Generated in 58.4403992 seconds (0.18% PHP / 99.82% MySQL)
SQL Queries: 22 / Global Parsing Time: 48.6668451 / Memory Usage: 2.75 MB
PHP version: 5.2.5 / Server Load: / GZip Compression: Enabled
At this point I don't know what to do. Is this something with MyBB or is it just the fact that their SQL servers are probably over taxed? Our contract expires very soon and I'm not adverse to moving it someone has a US based suggestion.
Thank you!
Our hosting is godaddy and they swear up and down it isn't on their end and that they cannot replicate the issue which I find hard to believe. Everyone else can!
I've been watching the messages at the bottom of the forum to track "times when it is slow" for them.
14:21
Generated in 36.0449769 seconds (0.42% PHP / 99.58% MySQL)
SQL Queries: 24 / Global Parsing Time: 24.0214128 / Memory Usage: 3 MB
PHP version: 5.2.5 / Server Load: / GZip Compression: Enabled
14:22
Generated in 22.4091010 seconds (0.67% PHP / 99.33% MySQL)
SQL Queries: 60 / Global Parsing Time: 10.0592830 / Memory Usage: 3.5 MB
PHP version: 5.2.5 / Server Load: / GZip Compression: Enabled
14:38
Generated in 58.4403992 seconds (0.18% PHP / 99.82% MySQL)
SQL Queries: 22 / Global Parsing Time: 48.6668451 / Memory Usage: 2.75 MB
PHP version: 5.2.5 / Server Load: / GZip Compression: Enabled
At this point I don't know what to do. Is this something with MyBB or is it just the fact that their SQL servers are probably over taxed? Our contract expires very soon and I'm not adverse to moving it someone has a US based suggestion.
Thank you!