Information_schema out of sync

Help
1

Hey,

I’m using MemSQL Kubernetes operator and I’m connecting as root.
when I’m running “select * from information_schema.tables;” I’m getting the most of the columns as “0”.

Do you think that I need to turn on any flags, looks like that the information schema DB is not syncing with the actual data on the physical tables.(attached)

Please advise,

Thanks,
Sasi

2

I don’t see any attachment. What columns are mostly 0? Can you paste some of it?

3

Some of the columns in information_schema we include only for compatibility with MySQL, but they don’t really apply to MemSQL or are not yet implemented so the data is often NULL, 0 or empty string. We do this so MySQL tools that query those info schema tables can continue to function vs MemSQL.