# # Show name of tables whose name starts with "t_special" in NDB # and all the MySQL Servers # # Show name of table in NDB --disable_query_log ONCE SELECT CONCAT("'", fq_name, "'") as Name_in_NDB FROM ndbinfo.dict_obj_info WHERE type = 2 AND fq_name LIKE "%/def/t_special%"; # Show name of table and its engine in DD on all MySQL Servers let $i = $NUM_MYSQLDS; while($i) { --connection mysqld$i --disable_query_log ONCE eval SELECT CONCAT("'", TABLE_SCHEMA, ".", TABLE_NAME, "' - ", ENGINE) AS Name_in_mysqld$i FROM information_schema.tables WHERE TABLE_NAME LIKE 't_special%'; dec $i; } connection default;