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 space avaliable.
regards anandkl On Thu, Jun 24, 2010 at 7:43 PM, Sarkis Karayan <skara...@gmail.com> 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. > > SELECT > table_schema AS 'Db Name', > Round( Sum( data_length + index_length ) / 1024 / 1024, 3) AS 'Db Size > (MB)', > 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=anan...@gmail.com > >
