• Marko Mäkelä's avatar
    Disable more threads on innodb_force_recovery=3 or more · a133b05c
    Marko Mäkelä authored
    The original intention of the setting innodb_force_recovery=3 was to
    disable background activity that could create trouble, most notably,
    the rollback of incomplete transactions, and the purge of transaction
    history.
    
    MySQL 5.6 introduced more background threads, it is creating
    dict_stats_thread and fts_optimize_thread even though these threads
    are at least as non-essential as the rollback and purge. These
    threads are in fact worse, because they can create new transactions
    on their own.
    
    innobase_start_or_create_for_mysql(): Do not create any internal
    undo log sources unless innodb_force_recovery<3.
    a133b05c
trx0purge.cc 47.7 KB