Queries per second unjustifyingly increases over time

2003-10-15 Thread Gavin Foster IFP
I have two servers - one serving a live site and once acting as a backup via replication. From our calculations site usage should be generating around 6 queries per second. This is confirmed by the frequency of queries appearing in the master binlog, and by increases in the 'questions' value

Re: Queries per second unjustifyingly increases over time

2003-10-15 Thread Dan Nelson
In the last episode (Oct 15), Gavin Foster IFP said: From our calculations site usage should be generating around 6 queries per second. This is confirmed by the frequency of queries appearing in the master binlog, and by increases in the 'questions' value of 'show variables' on the backup

Re: Queries per second unjustifyingly increases over time

2003-10-15 Thread Jeremy Zawodny
On Wed, Oct 15, 2003 at 09:37:29AM +0100, Gavin Foster IFP wrote: An example from just after restart (using myTop in 'm' mode showing number of queries executed each 1 second interval): Dan has your answer on this. I'm just amazed that anyone uses the 'm' feature. I added it mostly as a

Re: Queries per second unjustifyingly increases over time

2003-10-15 Thread Gavin Foster IFP
Quoting Jeremy Zawodny [EMAIL PROTECTED]: On Wed, Oct 15, 2003 at 09:37:29AM +0100, Gavin Foster IFP wrote: An example from just after restart (using myTop in 'm' mode showing number of queries executed each 1 second interval): Dan has your answer on this. I'm just amazed that anyone