List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:October 15 2003 3:13pm
Subject:Re: Queries per second unjustifyingly increases over time
View as plain text  
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 server.  There are no other
> processes running that should using the mysql server.
> 
> On the master - initially after restarting mysql it shows the correct
> number of queries per second (I use myTop but also confirm this
> myself by looking at the questions value).  But interspersed within
> are sudden bursts of queries being executed, say 64 queries in one
> second.  Over time this increases, 45 mins ago the average shown by
> myTop was 15 qps, now it is 23 qps.  This increase seems to slow in
> an exponential fashion, so that next month it will be around 40 to 50
> qps.
> 
> What might be causing this 'background' level of queries?
> 
> Is there some way I can view the queries that mysql is counting in
> it's 'questions' figure - seeing as my binlogging doesnt verify it?

The binary log only logs queries that change the table, not selects. 
Try turning regular logging on for a while (Add "log" to the [mysqld]
section in your my.cnf).  That will log every command sent to mysql.

-- 
	Dan Nelson
	dnelson@stripped
Thread
Queries per second unjustifyingly increases over timeGavin Foster IFP15 Oct
  • Re: Queries per second unjustifyingly increases over timeDan Nelson15 Oct
  • Re: Queries per second unjustifyingly increases over timeJeremy Zawodny15 Oct
    • Re: Queries per second unjustifyingly increases over timeGavin Foster IFP15 Oct