Skip to content
  • Martin Sköld's avatar
    bfa51d3a
    WL#7162 Move ndb_binlog_index table from MyISAM to transactional storage · bfa51d3a
    Martin Sköld authored
    Changing storage engine of ndb_binlog_index to use InnoDB.
    This gives better behavior when purging logs where large parts of
    the table can be deleted. Avoiding MyISAM table locking as well
    as using InnoDB lock-free reads will give better availability.
    
    Installation scripts mysql_system_tables.sql and mysql_system_tables_fix.sql
    are updated to define/alter the ndb_binlog_index table to use InnoDB.
    
    A new testcase ndb_binlog_purge_lock tests concurrent inserts
    during purging of the binary logs (which deletes rows in ndb_binlog_index).
    A new testcase ndb_binlog_purge_upgrade that first uses the mysql_upgrade
    script and then checks ndb_binlog_purge_lock.
    Updated ndb_rpl_circular to make scan order predictable.
    Updated ndb_binlog_index.result since it checks table engine.
    bfa51d3a
    WL#7162 Move ndb_binlog_index table from MyISAM to transactional storage
    Martin Sköld authored
    Changing storage engine of ndb_binlog_index to use InnoDB.
    This gives better behavior when purging logs where large parts of
    the table can be deleted. Avoiding MyISAM table locking as well
    as using InnoDB lock-free reads will give better availability.
    
    Installation scripts mysql_system_tables.sql and mysql_system_tables_fix.sql
    are updated to define/alter the ndb_binlog_index table to use InnoDB.
    
    A new testcase ndb_binlog_purge_lock tests concurrent inserts
    during purging of the binary logs (which deletes rows in ndb_binlog_index).
    A new testcase ndb_binlog_purge_upgrade that first uses the mysql_upgrade
    script and then checks ndb_binlog_purge_lock.
    Updated ndb_rpl_circular to make scan order predictable.
    Updated ndb_binlog_index.result since it checks table engine.
Loading