Credit Report - Debt Consolidation - Debt Consolidation - Debt Consolidation - Justin Gatlin Doping

PDA

View Full Version : Increased querries in server????


greatestmj
Mar 25th 2006, 7:10 am
i have seen a sudden rise in the number of querries

i use smf forum... and 2000 querries per second is reported by my forum

OMG

wt to do?

digitalpoint
Mar 25th 2006, 11:28 am
First thing to do would be to figure out why... Go through your web logs for example. If you can't find it in your web logs, start logging SQL queries to get a sampling of the queries being run.

zlos
Mar 26th 2006, 12:48 pm
What kind of traffic do you get? Unical Users / Page Impressions? How much queries averagely it takes to produce one page?

Any robots visiting your page?
All the software working properly? No hangs?
Maybe you got listed on main page of cnn.com? ;)

sacx13
Mar 30th 2006, 2:55 am
Try a: show processlist. Is possible to have a locked database and querys to stay in queue without doing anything ... what Load average do you have on that server?

Regards