Is there any data loss by deleting version list?

4

I have switch off versioning using customise form. However it take much time to find out which table is using large size in database.

untrackchanges
untrackchanges2442×1194 200 KB

I am sharing query for those who want to check each table size in database.

SELECT TABLE_NAME AS "Table Name",

table_rows AS "Quant of Rows", ROUND( (

data_length + index_length

) /1024, 2 ) AS "Total Size Kb"

FROM information_schema.TABLES

WHERE information_schema.TABLES.table_schema = '4c4d239fbd480c8d'
order by ROUND( (

data_length + index_length

) /1024, 2 ) desc

LIMIT 0 , 300;

55 PM
55 PM1192×1246 123 KB

For non technical person we can have page in ERPNext which can show each table size, file size, database backup size etc.

Thanks,
Sam

1 Like