The maximum single file size of a system is as follows, *Operating System* *File-size Limit* Linux 2.2-Intel 32-bit 2GB (LFS: 4GB) Linux 2.4 (using ext3 filesystem) 4TB Solaris 9/10 16TB NetWare w/NSS filesystem 8TB win32 w/ FAT/FAT32 2GB/4GB win32 w/ NTFS 2TB (possibly larger) MacOS X w/ HFS+ 2TB
(cut and pasted from mysql.com per table size)
and heres a nice tutorial on how to figure out your database size via php http://www.webmasterworld.com/forum88/2069.htm if you dont do php, its basicaly a script that says,
SHOW TABLE STATUS;
and then adds up the data_lenght & index_lenght of each table within a database.
Regards, Marcus Joyce
Jan Kirchhoff wrote:
Misao schrieb:
Our production databases here are really growing and getting to be ratherWe have a few 20-30GB-InnoDB-Tables (growing) without any problems (mysql 4.1.5gamma).
big. The question on our minds is; when is a database or table just too big?
The limits of mysql are somewhere in the terabyte-area I think, there is information on that in the manual.
I assume your problem would probably be hardware/performance at some point.
The machine that we are running that big database on is a dual-Opteron, 8gigs of RAM, 750GB RAID 1+0 SATA-Hotswap.
no problems so far... nice piece of hardware ;)
I have 2 or 3 tables that the MySQL Administrator can't even get a size on. ItSeems like a problem of MySQL Administrator. Check if you use the newest version, else change your frontend or make a bug-report.
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.
Jan
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]