Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions

  




 

 

23.21. The INFORMATION_SCHEMA FILES Table

The FILES table provides information about the files in which MySQL NDB tables are stored.

INFORMATION_SCHEMA Name SHOW Name Remarks
FILE_ID   MySQL extension
FILE_NAME   MySQL extension
FILE_TYPE   MySQL extension
TABLESPACE_NAME   MySQL extension
TABLE_CATALOG   MySQL extension
TABLE_SCHEMA   MySQL extension
TABLE_NAME   MySQL extension
LOGFILE_GROUP_NAME   MySQL extension
LOGFILE_GROUP_NUMBER   MySQL extension
ENGINE   MySQL extension
FULLTEXT_KEYS   MySQL extension
DELETED_ROWS   MySQL extension
UPDATE_COUNT   MySQL extension
FREE_EXTENTS   MySQL extension
TOTAL_EXTENTS   MySQL extension
EXTENT_SIZE   MySQL extension
INITIAL_SIZE   MySQL extension
MAXIMUM_SIZE   MySQL extension
AUTOEXTEND_SIZE   MySQL extension
CREATION_TIME   MySQL extension
LAST_UPDATE_TIME   MySQL extension
LAST_ACCESS_TIME   MySQL extension
RECOVER_TIME   MySQL extension
TRANSACTION_COUNTER   MySQL extension
VERSION   MySQL extension
ROW_FORMAT   MySQL extension
TABLE_ROWS   MySQL extension
AVG_ROW_LENGTH   MySQL extension
DATA_LENGTH   MySQL extension
MAX_DATA_LENGTH   MySQL extension
INDEX_LENGTH   MySQL extension
DATA_FREE   MySQL extension
CREATE_TIME   MySQL extension
UPDATE_TIME   MySQL extension
CHECK_TIME   MySQL extension
CHECKSUM   MySQL extension
STATUS   MySQL extension
EXTRA   MySQL extension

Notes:

  • The FILES table is a non-standard table. It was added in MySQL 5.1.6.


 
 
  Published under the terms of the GNU General Public License Design by Interspire