Get databse file size

https://tableplus.com/blog/2018/08/mysql-how-to-get-the-size-of-mysql-database.html

SELECT
    table_schema AS 'DB Name',
    ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) AS 'DB Size in MB'
FROM
    information_schema.tables
WHERE
    table_schema = 'db_name'
GROUP BY
    table_schema;