- DDL or dict_mem_table_free() or dict_load_tables() should avoid the
unnecessary wait for fts_optimize_remove_table()
- Use OPEN_ONLY_IF_CACHED for fts_optimize_thread. fts_optimize_thread() should
remove it from the slot if it doesn't able to open it.
- Remove the dead code of waiting for fts_syncing from DDL, Truncate code
- Have some protection for fts_need_sync variable or remove it.
- Remove FTS_MSG_STOP and make use of srv_shutdown_state
- Have proper mutex for adding the table to fts_optimize_queue (don't use dict_sys->mutex always)
- Write test cases to check fts_sync_rollback(), fts_sync + DDL
- Remove fts_sync() directly from copy alter code. (write_row does it)
- Try to have worker thread for fts_optimize_thread.
|