Skip to:
Content
Pages
Categories
Search
Top
Bottom

Re: diagnosing sql connections spike


josh_
Member

@josh_

well, i installed bb-benchmark but i’m not sure how that can help. when my connections spike i can’t access the database so….

there’s definitely a pattern here though. the spikes usually occur in the early morning at the same time.

here’s the benchmark info from when the spike was coming down:

08:01:47 up 71 days, 5:08, 0 users, load average: 1.47, 1.43, 1.39

total page time: 5.009 seconds.

time to reach each section:

bb_underscore_plugins_loaded = 0.170

bb_plugins_loaded = 0.178

bb_init = 0.178

bb_index.php_pre_db = 4.966

front-page.php = 4.967

header.php = 4.968

logged-in.php = 4.971

footer.php = 5.008

total query count: 10

Skip to toolbar