Cisco Cisco ASR 5000
MURAL Software Standard Installation Guide
...
mysql>
use DATABASE_MURAL;
Database changed
3.
Display the values in the
mints
and
maxts
columns for the 60-minute bin
class and -1 aggregation level (shown in the first row of the following
example).
mysql>
select * from bin_metatable;
+----------+---------------------+------------+------------+---------+
| binclass | aggregationinterval | mints
| maxts
| bintype |
+----------+---------------------+------------+------------+---------+
| 60min
|
-1| 1406710800 | 1409295600 | NULL
|
| 60min
|
86400|
0 |
0 | NULL
|
| 60min
|
604800|
0 |
0 | NULL
|
| 60min
|
2419200|
0 |
0 | NULL
|
+----------+---------------------+------------+------------+---------+
4 rows in set (1.14 sec)
Press Ctrl+D to exit
mysql> Bye
4.
Run the
date
command to convert the values from the
mints
and
maxts
columns to human-readable format.
The following example indicates that data was processed between 09:00 on
July 30 and 07:00 on August 29.
#
date -d @1406710800
Wed Jul 30 09:00:00 UTC 2014
#
date -d @1409295600
Fri Aug 29 07:00:00 UTC 2014
The following example indicates that data was processed between 11:00 on
October 13 and 21:00 on October 18.
#
date -d @1350126000
Sat Oct 13 11:00:00 UTC 2012
#
date -d @1350594000
Thu Oct 18 21:00:00 UTC 2012
61
Copyright © 2016, Cisco Systems, Inc.