OST_OPS_DATA table is empty in MySQL database

[Ryan Haasken]

Hello,

The OST_OPS_DATA table does not get populated with any data.  Is this normal?  It appears that it is not used because when I looked at the source code, I see the following functions defined in liblmtdb/lmtmysql.c:

int lmt_db_insert_mds_data (lmt_db_t db, char *mdsname, char *mdtname,
                        float pct_cpu, uint64_t kbytes_free,
                        uint64_t kbytes_used, uint64_t inodes_free,
                        uint64_t inodes_used);
int lmt_db_insert_mds_ops_data (lmt_db_t db, char *mdtname, char *opname,
                        uint64_t samples, uint64_t sum, uint64_t sumsquares);
int lmt_db_insert_oss_data (lmt_db_t db, int quiet_noexist, char *name,
                        float pctcpu, float pctmem);
int lmt_db_insert_ost_data (lmt_db_t db, char *ossname, char *ostname,
                        uint64_t read_bytes, uint64_t write_bytes,
                        uint64_t kbytes_free, uint64_t kbytes_used,
                        uint64_t inodes_free, uint64_t inodes_used);
int lmt_db_insert_router_data (lmt_db_t db, char *name,
                        uint64_t bytes, float pct_cpu);

There is no function to insert data into OST_OPS_DATA.  Is there some reason this unused table is created by LMT?  Am I missing something?

Here is the output from listing tables within lmtsh:

scratch> t
Available tables for scratch:
                        Table Name   Row Count
                        EVENT_DATA   0
                        EVENT_INFO   0
          FILESYSTEM_AGGREGATE_DAY   9
         FILESYSTEM_AGGREGATE_HOUR   27
        FILESYSTEM_AGGREGATE_MONTH   9
         FILESYSTEM_AGGREGATE_WEEK   9
         FILESYSTEM_AGGREGATE_YEAR   9
                   FILESYSTEM_INFO   1
                 MDS_AGGREGATE_DAY   5
                MDS_AGGREGATE_HOUR   15
               MDS_AGGREGATE_MONTH   5
                MDS_AGGREGATE_WEEK   5
                MDS_AGGREGATE_YEAR   5
                          MDS_DATA   1870
                          MDS_INFO   1
                      MDS_OPS_DATA   37149
                 MDS_VARIABLE_INFO   7
                    OPERATION_INFO   81
                          OSS_DATA   3740
                          OSS_INFO   2
                OSS_INTERFACE_DATA   0
                OSS_INTERFACE_INFO   0
                 OSS_VARIABLE_INFO   7
                 OST_AGGREGATE_DAY   54
                OST_AGGREGATE_HOUR   162
               OST_AGGREGATE_MONTH   54
                OST_AGGREGATE_WEEK   54
                OST_AGGREGATE_YEAR   54
                          OST_DATA   11217
                          OST_INFO   6
                      OST_OPS_DATA   0
                 OST_VARIABLE_INFO   11
              ROUTER_AGGREGATE_DAY   0
             ROUTER_AGGREGATE_HOUR   0
            ROUTER_AGGREGATE_MONTH   0
             ROUTER_AGGREGATE_WEEK   0
             ROUTER_AGGREGATE_YEAR   0
                       ROUTER_DATA   0
                       ROUTER_INFO   0
              ROUTER_VARIABLE_INFO   4
                    TIMESTAMP_INFO   70209
                           VERSION   0

Thanks,

Ryan

[Andrew Uselton]

You are correct. That table is not used and there's no functionality associated with it.  I think there are others like that.

-A

--
You received this message because you are subscribed to the Google Groups "lmt-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lmt-discuss...@googlegroups.com.
To post to this group, send email to lmt-d...@googlegroups.com.
Visit this group at http://groups.google.com/group/lmt-discuss.
For more options, visit https://groups.google.com/groups/opt_out.