MySQL Forums
Forum List  »  MyISAM

information_schema refresh
Posted by: Thol Chidambaram
Date: December 22, 2015 05:28PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
information_schema refresh
4490
December 22, 2015 05:28PM
1890
December 23, 2015 09:50PM
1783
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.