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
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
Check details here<http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html>
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
> 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
> On Thu, Jun 24, 2010 at 9:13 AM, Sarkis Karayan <skarayan@stripped>
> > 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:
> Jim Lyons
> Web developer / Database administrator
Mobile : 91-9987681929
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat