/**
* @param int $maxTablesToCheck
*
* @return bool
*/
public static function isDBMyISAM($maxTablesToCheck = 10)
{
return CRM_Core_DAO::singleValueQuery("SELECT count(*)\n FROM information_schema.TABLES\n WHERE ENGINE = 'MyISAM'\n AND TABLE_SCHEMA = '" . CRM_Core_DAO::getDatabaseName() . "'\n AND TABLE_NAME LIKE 'civicrm_%'\n AND TABLE_NAME NOT LIKE 'civicrm_import_job_%'\n AND TABLE_NAME NOT LIKE '%_temp%'\n ");
}