Re: MySQL usage profiling?
it doesn't look like a good solution either.
at an average of 400 tps during daytime, that will be a lot of data to parse.
having studied the sourcecode, i think i found that current facility that accounts for per-hour usage limits is more close to what i need: queries,connects and updates per user per hour are counted, only there is no way to retrieve current values.
so i think i will add a custom command (like SHOW QPHDATA) along with another "time spent per user per hour" counter.
with snapshot taken at an end of each hour, this should allow for a nice per-user usage summary.
Subject
Written By
Posted
November 20, 2004 05:41PM
November 21, 2004 02:35AM
Re: MySQL usage profiling?
November 21, 2004 04:30AM
November 29, 2004 06:36AM
November 21, 2004 02:37AM
November 21, 2004 04:04AM
November 29, 2004 10:27AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.