The lmtsh head and tail commands fail on the OSS_DATA table. They succeed on the OST_DATA and MDS_DATA tables, and I see no reason why they should be unsupported on the OSS_DATA table.
Here is the output from executing tail on OSS_DATA:
test> tail -10 OSS_DATA
Sorry. Can't perform the tail operation on this table.
Executing "tail -10 MDS_DATA" and "tail -10 OST_DATA" both succeed and print the last 10 rows of data from the table.
Here are the MySQL descriptions of OSS_DATA and MDS_DATA:
mysql> describe OSS_DATA;
+------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+-------+
| OSS_ID | int(11) | NO | PRI | NULL | |
| TS_ID | int(10) unsigned | NO | PRI | NULL | |
| PCT_CPU | float | YES | | NULL | |
| PCT_MEMORY | float | YES | | NULL | |
+------------+------------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> describe MDS_DATA;
+-------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------------+------+-----+---------+-------+
| MDS_ID | int(11) | NO | PRI | NULL | |
| TS_ID | int(10) unsigned | NO | PRI | NULL | |
| PCT_CPU | float | YES | | NULL | |
| KBYTES_FREE | bigint(20) | YES | | NULL | |
| KBYTES_USED | bigint(20) | YES | | NULL | |
| INODES_FREE | bigint(20) | YES | | NULL | |
| INODES_USED | bigint(20) | YES | | NULL | |
+-------------+------------------+------+-----+---------+-------+
7 rows in set (0.00 sec)
OSS_DATA has a TS_ID field just like MDS_DATA, so lmtsh should be able to print out the first n or last n records from that table using head or tail.
The lmtsh head and tail commands fail on the OSS_DATA table. They succeed on the OST_DATA and MDS_DATA tables, and I see no reason why they should be unsupported on the OSS_DATA table.
Here is the output from executing tail on OSS_DATA:
Executing "tail -10 MDS_DATA" and "tail -10 OST_DATA" both succeed and print the last 10 rows of data from the table.
Here are the MySQL descriptions of OSS_DATA and MDS_DATA:
OSS_DATA has a TS_ID field just like MDS_DATA, so lmtsh should be able to print out the first n or last n records from that table using head or tail.