Re: How to get growth rate used space of a table by month ?

[Peter Brawley]

Decide how you wish to measure the table's growth rate how, rowcount, or data size, or size of data+index size. Create a table growth(date date, size bigint). Schedule a query that runs the first of every month inserting into the fgrowth table the date and the reelevant statistic from information_schema.tables for that db and table.