basza.blogg.se - Mysql shrink database

This resets the minimum file size to the new value.Ĭlick the Next button to proceed to the Setting schedule options step of the wizard. In such a case, it would be unproductive to shrink the database repeatedly.

If you notice that the size of a database grows again after you have shrunk it, it means that the database needs this space for its regular operations. Note that y ou can shrink a file to a size that is less than the size specified when it was created. Do you need to shrink a database All databases need some free space to execute the necessary operations. You can set a file size after shrinking by choosing a file from the list and clicking the corresponding cell. Migrates all data from the specified file to other files in the same filegroup. Empty the file by moving data to the other file.Releases all free space at the end of the file to the operating system but does not perform any page movement inside the file.

Truncate free space at the end of the file only.

Moves allocated pages from the end of a data file to unallocated pages in the front of the file.

Move free space to the end of the file and truncate.

You can set a shrink operation to perform for every file by choosing a file from the list and clicking the corresponding cell. This step is available only if you have selected Shrink database files on the second step. This step of the wizard provides you with information on the allocated and used space by files, and allows you to specify the shrink action for each of the database files.

Advanced Query Builder for RAD Studio VCL.

Advanced Data Import for RAD Studio VCL.Advanced Data Export for RAD Studio VCL.SQL Management Studio for InterBase/Firebird.