Tables and views related to datafile _ MySQL

Source: Internet
Author: User
File_name data file name and path
File_id data file ID
Bytes data file size
Number of database blocks corresponding to the bocks data file size
Tablespace_name the tablespace name corresponding to the data file
Can autoextensible database files be automatically expanded?
Maxblocks the maximum number of bytes and the number of data blocks that can be expanded for this file.
User_blocks indicates the size of data files that can be used by the user, which is equal to the space used by datafile size-LMT/DMT.
# Attributes for auto scaling
Alter tablespace...
Datafile '... 'size...
Autoextent on

# LML (local management tablespace)
Alter tablespace...
Datafile '... 'size...
Extent management local autoallocate/uniform size ...;

# DML (dictionary management tablespace)
Create tablespace...
Datafile '... 'size...
Extent management dictionary
Default storage (initial

V $ datafile: describes the synchronization information of data files.

Bytes, blocks indicates the free space size and number of partitions in the tablespace.

V $ filestat:
Phyrds, phywrts indicates the database read and written by the physical disk

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.