Change in vdsm[master]: contrib: Add logdb tool for importing logs to a database

danken at redhat.com danken at redhat.com
Mon Mar 23 14:23:27 UTC 2015


Dan Kenigsberg has submitted this change and it was merged.

Change subject: contrib: Add logdb tool for importing logs to a database
......................................................................


contrib: Add logdb tool for importing logs to a database

Using a database we have more power to dissect big amount of logs and
extract useful statistics.

Examples:

  Breakdown of vgs calls every 10 minutes interval:

    $ logdb vdsm-all.db vdsm.log.*
    $ sqlite3 vdsm-all.db "
        select
          datetime(strftime('%s',timestamp)/600*600,'unixepoch')
          as interval,count()
        from messages
        where
            func = 'cmd' and
            text glob '*/sbin/lvm vgs*' and
            timestamp > '2015-03-11 05:30:00'
        group by interval
        "
    2015-03-11 05:30:00|2
    2015-03-11 05:40:00|5
    2015-03-11 05:50:00|8
    2015-03-11 06:00:00|16
    2015-03-11 06:10:00|2
    2015-03-11 06:20:00|2
    2015-03-11 06:30:00|2
    2015-03-11 06:40:00|2
    2015-03-11 06:50:00|2

  Show vm xml for vms started on 2015-03-11:

    $ sqlite3 vdsm-all.db "
        select timestamp,text from messages
        where
            text glob '*<domain *' and
            date(timestamp) = '2015-03-11'
        "

Change-Id: If60fc70ff5d76d783da776a9c7941fcdf2309eaa
Signed-off-by: Nir Soffer <nsoffer at redhat.com>
Reviewed-on: https://gerrit.ovirt.org/38746
Reviewed-by: Fred Rolland <frolland at redhat.com>
Reviewed-by: Adam Litke <alitke at redhat.com>
Reviewed-by: Dan Kenigsberg <danken at redhat.com>
---
M Makefile.am
A contrib/logdb
2 files changed, 112 insertions(+), 0 deletions(-)

Approvals:
  Adam Litke: Looks good to me, but someone else must approve
  Nir Soffer: Verified
  Fred Rolland: Looks good to me, but someone else must approve
  Dan Kenigsberg: Looks good to me, approved



-- 
To view, visit https://gerrit.ovirt.org/38746
To unsubscribe, visit https://gerrit.ovirt.org/settings

Gerrit-MessageType: merged
Gerrit-Change-Id: If60fc70ff5d76d783da776a9c7941fcdf2309eaa
Gerrit-PatchSet: 3
Gerrit-Project: vdsm
Gerrit-Branch: master
Gerrit-Owner: Nir Soffer <nsoffer at redhat.com>
Gerrit-Reviewer: Adam Litke <alitke at redhat.com>
Gerrit-Reviewer: Ala Hino <ahino at redhat.com>
Gerrit-Reviewer: Allon Mureinik <amureini at redhat.com>
Gerrit-Reviewer: Dan Kenigsberg <danken at redhat.com>
Gerrit-Reviewer: Fred Rolland <frolland at redhat.com>
Gerrit-Reviewer: Freddy Rolland <frolland at redhat.com>
Gerrit-Reviewer: Ido Barkan <ibarkan at redhat.com>
Gerrit-Reviewer: Martin Sivák <msivak at redhat.com>
Gerrit-Reviewer: Nir Soffer <nsoffer at redhat.com>
Gerrit-Reviewer: Yaniv Bronhaim <ybronhei at redhat.com>
Gerrit-Reviewer: automation at ovirt.org
Gerrit-Reviewer: oVirt Jenkins CI Server


More information about the vdsm-patches mailing list