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