Our production databases here are really growing and getting to be rather big. The question on our minds is; when is a database or table just too big? Our InnoDB datafile was 116GB last I checked, and I know we've got a few 20GB+ databases on there, but my real concern is over the table sizes. I have 2 or 3 tables that the MySQL Administrator can't even get a size on. It reports it as 0Bytes, but the little picture bar shows that these tables take up almost 1/3 of the database size. I think these tables could be as big as 8GB, but we have quite a few above 1GB.
Does anyone know the point that the MySQL Administrator can't report on table sizes? Also, does anyone know any of the magic numbers where things get difficult for databases and tables and even the main server when it gets too big? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
