On Tue, Dec 1, 2009 at 12:16 AM, Mike Gerdts <mger...@gmail.com> wrote: ... >> What if we just scrapped the current sar collector (sadc) and just saved >> kstat -p output (or something like it) instead? >>
> > I like the general idea, but I wonder if there are enough > kstat-as-text consumers out there to make that an important target. Note that kstat-as-text is just an example; a real implementation may well be some (yet to be defined) dedicated format. The important point is that you just dump kstats, and leave the processing/analysis until later. (Although the ability to slurp the text through the standard grep/awk/whatever set of tools does have its attractions. But you could easily generate the textual form from any stable representation.) > How about instead have a target of an SQLite database? The really > nifty things about this approach could be: > > - sqlite is already used in many places in OpenSolaris (SMF, firefox, ...) > - accessible to real languages through JDBC or ODBC > - accessible to shell scripts via sqlite command line > (/lib/svc/bin/sqlite today) > - easy to prune old data by deleting old rows > - easy to aggregate old data (prior to deletion) through SQL query > - could open up the doors to analysis of data leveraging the power of > SQL rather than complex application code. > - data already organized in a nice way for importing into an > enterprise performance analysis system. > - extensible beyond kstat data (dtrace aggregation written to DB?) I'm investigating that too (of course), but I'm not sure it's necessarily an obvious win. For one thing, you really want to squeeze the data size, whereas a db tends to enlarge it. I also want to be able to stage this off easily - although I guess one database per day would work, but then you lose some of the advantages of aggregating the data into a database in the first place. -- -Peter Tribble http://www.petertribble.co.uk/ - http://ptribble.blogspot.com/ _______________________________________________ sysadmin-discuss mailing list sysadmin-discuss@opensolaris.org http://mail.opensolaris.org/mailman/listinfo/sysadmin-discuss
