List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:June 24 2010 3:18pm
Subject:Re: Altering database size to add more space
View as plain text  
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 <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.
>
> 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=1
>
>

Thread
Altering database size to add more spaceSarkis Karayan24 Jun
  • Re: Altering database size to add more spaceAnanda Kumar24 Jun
  • Re: Altering database size to add more spaceJim Lyons24 Jun
    • Re: Altering database size to add more spacePrabhat Kumar25 Jun
      • Re: Altering database size to add more spaceJohan De Meersman25 Jun
        • Re: Altering database size to add more spaceJim Lyons25 Jun
          • Re: Altering database size to add more spaceCarsten Pedersen25 Jun