Re: diagnosing sql connections spike
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