Cisco Cisco ASR 5000
MURAL Software Standard Installation Guide
Validating Bulk Stats Data on the Insta Blade
1.
Use SSH to log in to the master Insta node and check the name of the
database configured for EDR:
>
en
#
_shell
#
cli -t "en" "conf t" "show runn full" |
grep "insta instance 1 cubes-database" | awk -F ' ' '{print $5}
'bulkstats
2.
Open the
idbmysql
user interface and select
bulkStats
as the database.
#
idbmysql
Welcome to the MySQL monitor.
Commands end with ; or \g.
...
mysql>
use bulkStats;
Database changed
3.
Display the values in the
mints
and
maxts
columns for the 900
aggregation interval (shown in the second row in the example).
mysql>
select * from bin_metatable;
+----------+---------------------+------------+------------+---------+
| binclass | aggregationinterval | mints
| maxts
| binType |
+----------+---------------------+------------+------------+---------+
| 5min
|
-1 |
0 |
0 | NULL
|
| 5min
|
900 | 1406713500 | 1409301900 | NULL
|
| 5min
|
3600 |
0 |
0 | NULL
|
| 5min
|
86400 |
0 |
0 | NULL
|
| 5min
|
604800 |
0 |
0 | NULL
|
| 5min
|
2419200 |
0 |
0 | NULL
|
+----------+---------------------+------------+------------+---------+
6 rows in set (12.18 sec)
mysql>
quit
mysql>
select * from bin_metatable;
+----------+---------------------+------------+------------+---------+
| binclass | aggregationinterval | mints
| maxts
| binType |
+----------+---------------------+------------+------------+---------+
| 5min
|
-1 |
0 |
0 | NULL
|
Copyright © 2016, Cisco Systems, Inc.
62