Corrupted tables now no notifications

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
tcanthonyii
Posts: 88
Joined: Thu Jan 21, 2016 10:45 am

Re: Corrupted tables now no notifications

Post by tcanthonyii »

Here are the results:

Code: Select all

SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' engine=MyISAM;') FROM information_schema.TABLES WHERE ENGINE = 'MEMORY';
+-------------------------------------------------------------------------------------+
| CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' engine=MyISAM;')            |
+-------------------------------------------------------------------------------------+
| ALTER TABLE information_schema.CHARACTER_SETS engine=MyISAM;                        |
| ALTER TABLE information_schema.COLLATIONS engine=MyISAM;                            |
| ALTER TABLE information_schema.COLLATION_CHARACTER_SET_APPLICABILITY engine=MyISAM; |
| ALTER TABLE information_schema.COLUMN_PRIVILEGES engine=MyISAM;                     |
| ALTER TABLE information_schema.ENGINES engine=MyISAM;                               |
| ALTER TABLE information_schema.FILES engine=MyISAM;                                 |
| ALTER TABLE information_schema.GLOBAL_STATUS engine=MyISAM;                         |
| ALTER TABLE information_schema.GLOBAL_VARIABLES engine=MyISAM;                      |
| ALTER TABLE information_schema.KEY_COLUMN_USAGE engine=MyISAM;                      |
| ALTER TABLE information_schema.PROFILING engine=MyISAM;                             |
| ALTER TABLE information_schema.REFERENTIAL_CONSTRAINTS engine=MyISAM;               |
| ALTER TABLE information_schema.SCHEMATA engine=MyISAM;                              |
| ALTER TABLE information_schema.SCHEMA_PRIVILEGES engine=MyISAM;                     |
| ALTER TABLE information_schema.SESSION_STATUS engine=MyISAM;                        |
| ALTER TABLE information_schema.SESSION_VARIABLES engine=MyISAM;                     |
| ALTER TABLE information_schema.STATISTICS engine=MyISAM;                            |
| ALTER TABLE information_schema.TABLES engine=MyISAM;                                |
| ALTER TABLE information_schema.TABLE_CONSTRAINTS engine=MyISAM;                     |
| ALTER TABLE information_schema.TABLE_PRIVILEGES engine=MyISAM;                      |
| ALTER TABLE information_schema.USER_PRIVILEGES engine=MyISAM;                       |
+-------------------------------------------------------------------------------------+
20 rows in set (0.00 sec)

Code: Select all

SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' engine=MyISAM;') FROM information_schema.TABLES WHERE ENGINE = 'CSV';
+--------------------------------------------------------------------------+
| CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' engine=MyISAM;') |
+--------------------------------------------------------------------------+
| ALTER TABLE mysql.general_log engine=MyISAM;                             |
| ALTER TABLE mysql.slow_log engine=MyISAM;                                |
+--------------------------------------------------------------------------+
2 rows in set (0.01 sec)

Code: Select all

mysql> SELECT ENGINE FROM information_schema.TABLES;
+--------+
| ENGINE |
+--------+
| MEMORY |
| MEMORY |
| MEMORY |
| MyISAM |
| MEMORY |
| MEMORY |
| MyISAM |
| MEMORY |
| MEMORY |
| MEMORY |
| MEMORY |
| MyISAM |
| MyISAM |
| MyISAM |
| MEMORY |
| MEMORY |
| MyISAM |
| MEMORY |
| MEMORY |
| MEMORY |
| MEMORY |
| MEMORY |
| MEMORY |
| MEMORY |
| MEMORY |
| MyISAM |
| MEMORY |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| CSV    |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| CSV    |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
+--------+
208 rows in set (0.00 sec)
Top
tcanthonyii
Posts: 88
Joined: Thu Jan 21, 2016 10:45 am

Re: Corrupted tables now no notifications

Post by tcanthonyii »

still no notifications, still no host group summary.
Top
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: Corrupted tables now no notifications

Post by rkennedy »

Closing this out as a ticket has been received for it.
Former Nagios Employee
Top
Locked

Return to “Nagios XI”