Tag Info

New answers tagged

0

I assume it is the .ibd file that is 20GB, not the .frm? If you want two physically separate tables you could copy tab1-1 into tab1-2 (so you have two copies) then Delete half the data from each. You'd still need to Optimize both tables afterwards to shrink them. Using the MySQL partition option you would have one table tab1, which you would partition by ...


1

Frankly, I wouldn't use either. You can find your biggest tables immediately - with more flexibility - and not worry about where @updateusage has been set. CREATE PROCEDURE dbo.TopTables @NumberOfObjects INT = 100, @MinimumSizeInMB INT = 10 AS BEGIN SET NOCOUNT ON; SELECT TOP (@NumberOfObjects) [object] = QUOTENAME(s.name) + N'.' + ...


0

This post might give you an alternative approach. I have found sys.database_files is pretty much reliable. http://stackoverflow.com/questions/9630279/listing-information-about-all-database-files-in-sql-server Select DB_NAME() AS [DatabaseName], Name, physical_name, Cast(Cast(Round(cast(size as decimal) * 8.0/1024.0,2) as ...


0

I wanted to do a backup of all data before trying anything but had repeated problems because of the mysql and performance_schema databases - Dump All Databases in MySQL - Fails on mysql and performance_schema . In the end I decided to back up my data and try something different with the option of reinstalling everything if it all went wrong. This is what I ...



Top 50 recent answers are included