Re: Altering database size to add more space

On Fri, 25 Jun 2010 06:31:11 -0500, Jim Lyons wrote: > I think you're confusing table size with data base size. The original post > grouped by schema so it appears the question concerns database size. I > don't believe mysql imposes any limits on that. Is there a limit on the > number of

Re: Altering database size to add more space

I think you're confusing table size with data base size. The original post grouped by schema so it appears the question concerns database size. I don't believe mysql imposes any limits on that. Is there a limit on the number of tables you can have in a schema imposed by mysql? On Fri, Jun 25,

Re: Altering database size to add more space

On Fri, Jun 25, 2010 at 7:11 AM, Prabhat Kumar wrote: > In case MyISAM it will grow up to space on your data drive or the Max size > of file limited by OS.. > Not entirely correct. There is some kind of limit to a MyISAM file that has to do with pointer size - I've encountered it several years a

Re: Altering database size to add more space

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

Re: Altering database size to add more space

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 a

Re: Altering database size to add more space

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 wrote: > I feel like I am missing something, because I am not able to find t

Altering database size to add more space

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( d