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, 2010 at 4:13 AM, Johan De Meersman <vegiv...@tuxera.be>wrote: > On Fri, Jun 25, 2010 at 7:11 AM, Prabhat Kumar <aim.prab...@gmail.com>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 ago. > > You shouldn't be encountering it, in most circumstances, but that's what > the max_data_length column in *show table status* is about. > > Before 5.0.6, the default max datafile size was 4G, but that's been upped > to 256T now. > > If you're really running in to this have a look at the various advanced > options for create/alter table, like avg_row_length and max_rows; as well as > the variable myisam_data_pointer_size. > > Now what Sarkis is running into, is more of a logical error: data_free does > not tell you how much free space there is *for data*, but how much free > space there is *in the existing datafile*. That is, it really tells you how > much space in your file has become free by deleting rows et al. This also > explains why it's always 0 for InnoDB tables :-) > > > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
