It's also interesting to note that it's possible to split innodb data between multiple files to have databases larger than the OS's max file size. -jeff
On Thu, 2003-03-27 at 14:17, Dathan Vance Pattishall wrote: > ISAM tables are cut off at 4gb of data > MYISAM / INNODB /BDB have a filesystem limit. > I suggest to limit the maximum size of data file: find out if reiserfs > can set a limit on files sizes. I know that EXT3 a few revisions ago > could not go past 2GB per file. Or prune your data so it doesn't get to > big, Or create a HEAP table (in memory table and specify the memory max > footprint). > > Check this document out > http://www.mysql.com/doc/en/Table_types.html > > > > -----Original Message----- > From: sunil sharma [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 27, 2003 3:56 AM > To: [EMAIL PROTECTED] > Subject: database size > > Hello friends > > I am using mysql on Suse linux 7.1 > my mysql data partition is of on reiserfs filesystem. > > Can anybody tell me, How i can resitrict database > size? > Is their any possibility that i can specify the > maximum size of database. > > Thanx in advance > > > __________________________________________________ > Do you Yahoo!? > Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! > http://platinum.yahoo.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
