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]
