List:General Discussion« Previous MessageNext Message »
From:Prabhat Kumar Date:June 25 2010 5:11am
Subject:Re: Altering database size to add more space
View as plain text  
There is 2 way to check databases size :

A. OS level, you can do *#du -hs  *of data dir , it will show current usages
of you database size at File system level.

B. You can also check on Database level check details
here<http://adminlinux.blogspot.com/2009/12/mysql-tips-calculate-database-and-table.html>

How can I increase the size of a database?
>

Its depend upon the how have you configured my.cnf and the type of engine
you are using.
In case MyISAM it will grow up to space on your data drive or the Max size
of file limited by OS..
and In case of Innodb it will also grow up to space on you drive same as for
MyISAM,  since its default configuration
is *autoextend*
innodb_data_file_path=ibdata1:50M;ibdata2:50M:*autoextend*

Check details here<http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html>

--Prabhat


On Thu, Jun 24, 2010 at 9:00 PM, Jim Lyons <jlyons4435@stripped> wrote:

> What do you mean "time to increase"?  What tells you that?
>
> A database's size is determined by the amount of available diskspace.  If
> you need more than the filesystem that it is currently on has, then you can
> either move the entire schema (which is synonymous to "database") to
> another
> filesystem and symlink it.  You can also store individual tables and table
> files on other file systems and symlink those.  Either way, you have the
> total collection of disk space available to you.  This assumes a Linux OS.
>
> If your innodb tables are being restricted, you need to see if you have a
> max size defined for the table space and if that is what you're bumping
> into.
>
>
>
> On Thu, Jun 24, 2010 at 9:13 AM, 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
> >
> >
>
>
> --
> Jim Lyons
> Web developer / Database administrator
> http://www.weblyons.com
>



-- 
Best Regards,

Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile     : 91-9987681929
www.datavail.com

My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat

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