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 <jlyons4...@gmail.com> 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 <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=jlyons4...@gmail.com > > > > > > > -- > 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
