information_schema refresh
Hi,
I have 5.6.20 running in centos vm.
I tried to truncate a MyISAM table to reclaim space and checked the data_length column in information_schema.tables. In the session I have just truncated I can see that data_length is reduced. But in another session using mysql workbench the data length is still the old value. Value is not updated even after analyze.
Can you please let me know when will the information_schema values will be updated/refreshed across all sessions? I do not have access to db directory to see the table files.
Output in the session where truncate executed.
Table_name engine table_rows data_length index_length
contexts MyISAM 0 0 2048
events MyISAM 0 0 1024
output from workbench session
# table_name, engine, table_rows, data_length, index_length
contexts, MyISAM, 351521, 142650716, 37650432
events, MyISAM, 77317519, 3214007628, 1895477248
Subject
Views
Written By
Posted
information_schema refresh
4693
December 22, 2015 05:28PM
1979
December 23, 2015 09:50PM
1886
January 29, 2016 04:29PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.