Linux.com

markseger

markseger

  • Linux.com Member
  • Posts: 3
  • Member Since: 10 Jan 11
  • Last Logged In: 11 Jan 11

Latest Posts

Posted by
Topic
Post Preview
Posted
  • markseger
    RE: Help with colletcl tool
    why didn't you say excel? ;) excel can read collectl's space-separated format with no problems, you just need to open as you would any file and tell excel the fields are space-separated when it asks. Anyhow if you want to capture disk writes/sec, -sd will show the total writes on all your disks. If all but one are idle, this should work fine, but if you have multiple disks active, -sD will get you exact numbers for each. I don't know where -p in your command above is coming from. You need -f/temp if you want to write the output to the directory /temp. By default, if you have the compression library installed, collectl will write its output in a compressed 'gz' file, which you can always manually uncompress. Alternatively you can add the switch -oz which will tell it not to compress. So, the command I'd consider using is: collectl -sD -P -f/temp -oZ then try importing the /temp/*dsk into excel without around with --sep. It's really not hard... of you use -sd you'll have a file named *.tab instead. if you use -sdD you'll get both! -mark
    Link to this post 12 Jan 11

    why didn't you say excel? ;)
    excel can read collectl's space-separated format with no problems, you just need to open as you would any file and tell excel the fields are space-separated when it asks.

    Anyhow if you want to capture disk writes/sec, -sd will show the total writes on all your disks. If all but one are idle, this should work fine, but if you have multiple disks active, -sD will get you exact numbers for each.

    I don't know where -p in your command above is coming from. You need -f/temp if you want to write the output to the directory /temp. By default, if you have the compression library installed, collectl will write its output in a compressed 'gz' file, which you can always manually uncompress. Alternatively you can add the switch -oz which will tell it not to compress.

    So, the command I'd consider using is:

    collectl -sD -P -f/temp -oZ

    then try importing the /temp/*dsk into excel without around with --sep. It's really not hard...
    of you use -sd you'll have a file named *.tab instead. if you use -sdD you'll get both!

    -mark

  • markseger
    RE: Help with colletcl tool
    If you really only care about disk data and nothing more - it's not that expensive to grab more - the question is do you just want summaries of totals across ALL disks or would you prefer data on individual ones? -sd will get you the summary, -sD the details and -sdD both. Anyhow assuming you really want summary as you've indicated above AND if you want it for 5 days, run collectl as a daemon. just edit the line DaemonCommands in /etc/collectl.conf from: DaemonCommands = -f /var/log/collectl -r00:00,7 -m -F60 -s+YZ to DaemonCommands = -f /var/log/collectl -r00:00,7 -sd -P --sep ',' that will write the csv data to a file in /var/log/collectl, creating a new one each midnight. To start it just do /etc/init.d/collectl start and after 5 days /etc/init.d/collectl stop. The default collection interval is 10 seconds. The output, which you can generate interactively to look at would be from the command: "collectl -sd -P --sep ','" and look like the following, noting the interactive default interval is 1 sec: [root@poker collectl]# collectl -sd -P --sep ',' waiting for 1 second sample... #Date,Time,[DSK]ReadTot,[DSK]WriteTot,[DSK]OpsTot,[DSK]ReadKBTot,[DSK]WriteKBTot,[DSK]KbTot,[DSK]ReadMrgTot,[DSK]WriteMrgTot,[DSK]MrgTot 20110111,08:04:36,0,0,0,0,0,0,0,0,0 20110111,08:04:37,0,2,2,0,264,264,0,64,64 20110111,08:04:38,0,0,0,0,0,0,0,0,0 this should be enough to get you going... -mark
    Link to this post 11 Jan 11

    If you really only care about disk data and nothing more - it's not that expensive to grab more - the question is do you just want summaries of totals across ALL disks or would you prefer data on individual ones? -sd will get you the summary, -sD the details and -sdD both. Anyhow assuming you really want summary as you've indicated above AND if you want it for 5 days, run collectl as a daemon. just edit the line DaemonCommands in /etc/collectl.conf from:

    DaemonCommands = -f /var/log/collectl -r00:00,7 -m -F60 -s+YZ

    to

    DaemonCommands = -f /var/log/collectl -r00:00,7 -sd -P --sep ','

    that will write the csv data to a file in /var/log/collectl, creating a new one each midnight. To start it just do /etc/init.d/collectl start and after 5 days /etc/init.d/collectl stop. The default collection interval is 10 seconds.

    The output, which you can generate interactively to look at would be from the command:

    "collectl -sd -P --sep ','" and look like the following, noting the interactive default interval is 1 sec:

    [root@poker collectl]# collectl -sd -P --sep ','
    waiting for 1 second sample...
    #Date,Time,[DSK]ReadTot,[DSK]WriteTot,[DSK]OpsTot,[DSK]ReadKBTot,[DSK]WriteKBTot,[DSK]KbTot,[DSK]ReadMrgTot,[DSK]WriteMrgTot,[DSK]MrgTot
    20110111,08:04:36,0,0,0,0,0,0,0,0,0
    20110111,08:04:37,0,2,2,0,264,264,0,64,64
    20110111,08:04:38,0,0,0,0,0,0,0,0,0

    this should be enough to get you going...
    -mark

  • markseger
    RE: Help with colletcl tool
    I'm actually the author of collectl! Personally I don't like csv formatted data because I find it a pain to parse and most utilities that read CSV also read space separated data so that's the default when you with with -P. If if you include -f it ill write to a file in that directory. BUT if you really want csv data ;), you can use "--sep ','" to tell it to use a comma as the separator instead. Does that answer your question or are you looking for more details? -mark
    Link to this post 11 Jan 11

    I'm actually the author of collectl! Personally I don't like csv formatted data because I find it a pain to parse and most utilities that read CSV also read space separated data so that's the default when you with with -P. If if you include -f it ill write to a file in that directory. BUT if you really want csv data ;), you can use "--sep ','" to tell it to use a comma as the separator instead. Does that answer your question or are you looking for more details?
    -mark

Who we are ?

The Linux Foundation is a non-profit consortium dedicated to the growth of Linux.

More About the foundation...

Frequent Questions

Join / Linux Training / Board