2

The output of show table status for my MySQL database has many rows in the engine column with values of InnoDB and many rows with values of NULL.

Why are some rows NULL? Shouldn't that be impossible? It is a very old database, perhaps the engine was not properly set when InnoDB was released?

Is this a problem I should try to fix?

Related: How do I know if a mysql table is using myISAM or InnoDB Engine?

tjb
  • 11,480
  • 9
  • 70
  • 91
  • 1
    Can we see the output result of `show table status`? – FanoFN Oct 02 '19 at 05:35
  • 1
    Thank you for your comment...I went back to look at the table again to see what I could post and noticed that it was not tables but VIEWS that were null, the reason must be that.... – tjb Oct 02 '19 at 05:45

1 Answers1

2

The show table status command shows both tables and views. The views are marked null across the engine column and across most other columns.

tjb
  • 11,480
  • 9
  • 70
  • 91