• Thirunarayanan Balathandayuthapani's avatar
    MDEV-18867 Long Time to Stop and Start · 75e82f71
    Thirunarayanan Balathandayuthapani authored
    fts_drop_orphaned_tables() takes long time to remove the orphaned
    FTS tables. In order to reduce the time, do the following:
    
    - Traverse fil_system.space_list and construct a set of
    table_id,index_id of all FTS_*.ibd tablespaces.
    - Traverse the sys_indexes table and ignore the entry
    from the above collection if it exist.
    - Existing elements in the collection can be considered as
    orphaned fts tables. construct the table name from
    (table_id,index_id) and invoke fts_drop_tables().
    - Removed DICT_TF2_FTS_AUX_HEX_NAME flag usage from upgrade.
    - is_aux_table() in dict_table_t to check whether the given name
    is fts auxiliary table
    fts_space_set_t is a structure to store set of parent table id
    and index id
    - Remove unused FTS function in fts0fts.cc
    - Remove the fulltext index in row_format_redundant test case.
    Because it deals with the condition that SYS_TABLES does have
    corrupted entry and valid entry exist in SYS_INDEXES.
    75e82f71
row0mysql.cc 130 KB