the leased mysql database of Tencent Cloud has more and more data every day, and almost no deletion has been done.
Tencent Cloud displays about 1200 gigabytes, but I use the following sql statement to query the size of each table. With the index, it is only about 600g. (only 3 GB for binlog)
select table_schema, sum(data_length+index_length)/1024/1024 as total_mb, sum(data_length)/1024/1024 as data_mb, sum(index_length)/1024/1024 as index_mb, count(*) as tables, curdate() as today from information_schema.tables group by table_schema order by 2 desc what does half the capacity do? Is there an optimization plan? Or is there something missing in my calculation?
