What is "table_id" in MySQL binary log events?

930 Views Asked by At

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

1

There are 1 best solutions below

1
Hendrik Prinsloo On BEST ANSWER

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.