1RASQLTIMEINDEX(1) General Commands Manual RASQLTIMEINDEX(1)
2
3
4
6 rasqltimeindex - read argus(8) data from mysql database.
7
9 rasqltimeindex -r argus.data.file -w mysql://user@host/db
10
12 Rasqltimeindex index argus data files by time.
13
14 The principal function of rasqltimeindex is to provide fast access to
15 indexed argus data files based on time.
16
17 Rasqltimeindex, like all ra based clients, supports a number of ra
18 options rasqltimeindex(1) specific options are:
19
20
22 -w <mysql://[user[:pass]@]host[:port]/db>
23 Specify the mysql database to use in maintaining the 'Seconds',
24 'Probe', and 'Filename' database index tables.
25
26
27
29 This invocation reads argus(8) data from the file argus.file and cre‐
30 ates an index of every second in the file in the db database, using the
31 user database account.
32
33 rasqltimeindex -r argus.file -w mysql://user@localhost/db
34
35
36 To take advantage of the speedup provided by the time indexing, use
37 rasql to read the mysql database, with a time filter. This example
38 will read from the database that contains the 'Seconds', 'Probe', and
39 'Filename' database index tables, and search for all flow records from
40 00:00:00 - 00:00:25, 20 days ago.
41
42 rasql -r mysql://user@localhost/db -t -20d+25s
43
44
45
46
48 Copyright (c) 2000-2016 QoSient. All rights reserved.
49
50
52 ra(1), rasql(1), rarc(5), argus(8),
53
54
56 Carter Bullard (carter@qosient.com).
57
58
59
60rasqltimeindex 3.0.8 12 August 2009 RASQLTIMEINDEX(1)