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
> 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.