Hi Sean, Try http://goo.gl/JML3s for some tips on fixing mysql databases.
hth paul -----Original message----- To: [email protected]; From: Sean R. Kirkpatrick <[email protected]> Sent: Wed 09-02-2011 17:23 Subject: [opsview-users] is this a problem? Attachment: inline.txt > I received the following from one of my two Opsview servers this morning. I > have never seen this before and Google is surprisingly unhelpful. > > > > Do I have a serious problem? > > > > Sean > > > > runtime.opsview_performance_metrics_tmp > > Error : Table 'runtime.opsview_performance_metrics_tmp' doesn't exist > > error : Corrupt > > > > Improperly closed tables are also reported if clients are accessing the > tables > *now*. A list of current connections is below. > > > > +----+------------------+-----------+---------+---------+------+-------+-------- > ----------+ > > | Id | User | Host | db | Command | Time | State | > Info > | > > +----+------------------+-----------+---------+---------+------+-------+-------- > ----------+ > > | 8 | opsview | localhost | opsview | Sleep | 35 | > | > | > > | 17 | debian-sys-maint | localhost | | Query | 0 | | show > processlist | > > +----+------------------+-----------+---------+---------+------+-------+-------- > ----------+ > > Uptime: 49 Threads: 2 Questions: 1451 Slow queries: 0 Opens: 248 Flush > tables: 1 Open tables: 212 Queries per second avg: 29.612 > > > > > > > > Sean R. Kirkpatrick > > Engineering Manager > > Moosepoint Technology, Inc. > > [email protected] > > 707.566.6720 x117 > > > > _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
