what is the innodb file size that u have specified in my.cnf.
If the last file is autoextend, that this will grow to the size of the disk
On Thu, Jun 24, 2010 at 7:43 PM, Sarkis Karayan <skarayan@stripped> wrote:
> I feel like I am missing something, because I am not able to find the
> answer to this simple question.
> How can I increase the size of a database?
> I am using the following query to check the available space and notice
> that it is time to increase.
> table_schema AS 'Db Name',
> Round( Sum( data_length + index_length ) / 1024 / 1024, 3) AS 'Db Size
> Round( Sum( data_free ) / 1024 / 1024, 3 ) AS 'Free Space (MB)'
> FROM information_schema.tables
> GROUP BY table_schema ;
> Thank you.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1