What is "table_id" in MySQL binary log events?

Question

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

score 3 · Accepted Answer · answered Oct 25 '18 at 08:16

3

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.

answered Oct 25 '18 at 08:16

Hendrik Prinsloo

179
10

Thanks Hendrik..!! I searched this a lot and couldn't find an informatic answer like the post that you shared. (y) – Udara Gunathilake Oct 25 '18 at 08:27

What is "table_id" in MySQL binary log events?

1 Answers1