log analysis

[Robert Blackwell]

I have log files in the form of .txt and I'm wondering if there's something
I can use to see what kind of usage my dbase is getting. I'm interestedin
mainly in bandwidth use and that kind of stuff. It would be nice to see it
in the form of bargraphs.

Anything like that available?

[Bill Karwin]

Re: log analysis

Robert Blackwell wrote:[color=blue]
> I have log files in the form of .txt and I'm wondering if there's something
> I can use to see what kind of usage my dbase is getting. I'm interestedin
> mainly in bandwidth use and that kind of stuff. It would be nice to see it
> in the form of bargraphs.[/color]

MySQL has several logging capabilities, and also capabilities to track
bandwidth and such stats since the server was restarted.

SHOW STATUS is a statement that will display several stats about the
MySQL server, including bytes sent and received since the last server
restart.

You can read about log options at

http://dev.mysql.com/doc/mysql/en/log-files.html

As far as I know, there's no bar graph output, or automatic timeslicing,
e.g. bandwidth used per hour, etc. You could write a script to collect
the values with SHOW STATUS and load the cumulative numbers into some
table or spreadsheet, and then generate a bar graph yourself based on this.

Regards,
Bill K.