I'm investigating the big switch from MySQL to a NoSQL DBaaS and I've run into an issue trying to forecast expenses. Essentially, I can't figure out how many queries my current MySQL server handles per day to try and estimate the number of requests I'll be using with Cloudant, which charges $0.015 per 100 PUTs, POSTs, and DELETEs and $0.015 per 500 GETs and HEADs.
I've found a lot of information about using SHOW STATUS and SHOW GLOBAL STATUS to get the stats that MySQL collects on itself, but there's no timeframe reference.
For instance, SHOW GLOBAL STATUS returns the following:
Queries | 13576675
Which is great, except I have no idea the timeframe that wraps that number. 13 million queries when? Per month? Year? Since the beginning of time?
The MySQL docs don't really elaborate too much:
Queries
The number of statements executed by the server. This variable includes statements executed within stored programs, unlike the Questions variable. It does not count COM_PING or COM_STATISTICS commands. This variable was added in MySQL 5.0.76.
Thanks in advance for any help.
Queries
global status variable is counting everything since the server was last started... which wasSHOW STATUS LIKE 'Uptime';
seconds ago. Many status variables are cleared withFLUSH STATUS;
butQueries
is not, at least in the test servers I confirmed it on just now, which were MySQL 5.5.19 and 5.6.14.