mysqlbinary-log

What is "table_id" in MySQL binary log events?


Is there any description for table_id in MySQL binary log events? Is it a unique value?


Solution

  • Found the answer in this post

    This value comes from an incrementing global counter in sql/sql_base.cc. It increments every time a table is added to the cache of open tables that is limited in size by the global variable open_table_cache... so if that value is smaller than the number of tables being periodically accessed, you should see it increment more frequently. All of the tables will have a new id on the next generated binlog event after a FLUSH TABLES.