Previous Thread
Next Thread
Print Thread
Hop To
Joined: Aug 2006
Posts: 1,649
Likes: 1
Pooh-Bah
Pooh-Bah
Joined: Aug 2006
Posts: 1,649
Likes: 1

Had no idea where to post this.

My BB lags now and then and I assume it's the shared server I'm on. I turned debugging on and during the last lag it said:

Generated in 16.865 seconds in which 16.847 seconds were spent on a total of 23 queries. Zlib compression enabled.

A few seconds later it was back to normal:

Generated in 0.016 seconds in which 0 seconds were spent on a total of 23 queries. Zlib compression enabled.

Does this tell me anything about the cause of lag?


GangsterBB.NET (Ver. 7.6.1.1)
PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Joined: Aug 2006
Posts: 1,649
Likes: 1
Pooh-Bah
Pooh-Bah
Joined: Aug 2006
Posts: 1,649
Likes: 1

Ouch, I just got a bad one:

Generated in 32.469 seconds in which 32.449 seconds were spent on a total of 24 queries. Zlib compression enabled.

I've been doing many tracerts lately and none seem terrible. I rarely get any hops in 3-digits ms. I guess it's gotta be the server....



GangsterBB.NET (Ver. 7.6.1.1)
PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
It's definitely on the server end it appears. Specifically MySQL. For example, the last one. Out of the 32.469 seconds it took for the page to load, 32.449 of that was spent on database queries.

Since you're on a shared server, you can definitely have up and downs on mysql query time depending on how busy it is, 30+ seconds is definitely bad however.

You might put in a question to your host to see how many people are actually on the specific mysql server you are using.

Joined: Aug 2006
Posts: 1,649
Likes: 1
Pooh-Bah
Pooh-Bah
Joined: Aug 2006
Posts: 1,649
Likes: 1

Thanks, Boss -- I'll ask them to check it out.


GangsterBB.NET (Ver. 7.6.1.1)
PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Post Counts zeroed out
by Baldeagle - 11/03/2024 3:05 PM
Upgraded to ver8 - now can't login
by phoenix011235 - 10/24/2024 7:50 AM
Very weird error this morning.
by Baldeagle - 10/23/2024 4:35 PM
Help error and stop forum spam
by ehill - 10/23/2024 11:13 AM
Very slow web server response times
by Baldeagle - 10/18/2024 3:22 PM
Who's Online Now
1 members (Ruben), 170 guests, and 52 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.1
(Snapshot build 20240918)