Nagios Support Forum

Posted: **Tue Jan 10, 2017 3:32 pm**

Here are the results:

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)

Posted: **Tue Jan 10, 2017 3:38 pm**

still no notifications, still no host group summary.

Posted: **Tue Jan 10, 2017 4:24 pm**

Closing this out as a ticket has been received for it.

Nagios Support Forum

Corrupted tables now no notifications

Re: Corrupted tables now no notifications

Re: Corrupted tables now no notifications

Re: Corrupted tables now no notifications