SELECT FILE_ID, FILE_NAME, FILE_TYPE, TABLESPACE_NAME, FREE_EXTENTS,
       TOTAL_EXTENTS,  EXTENT_SIZE, INITIAL_SIZE, MAXIMUM_SIZE, AUTOEXTEND_SIZE, DATA_FREE, STATUS ENGINE
       FROM INFORMATION_SCHEMA.FILES WHERE TABLESPACE_NAME LIKE '%innodb%' and FILE_NAME LIKE '%51%';

SELECT FILE_ID, FILE_NAME FROM INFORMATION_SCHEMA.FILES
       WHERE FILE_NAME LIKE '%.ibd%' ORDER BY FILE_ID;

SHOW table status from sample51;

optimize table sample51.book;
optimize table sample51.book_copies;
optimize table sample51.book_loans;
optimize table sample51.bookauthors;
optimize table sample51.borrower;
optimize table sample51.library_branch;
optimize table sample51.publisher;

select * from INFORMATION_SCHEMA.FILES;