Re: database size
Dear Friends First thanx for all of to ans me but I feel that i put the question in wrong way. Actually i created 5 databases other than default one that is mysql and test I created the 5 different database for my client and i want to resitrct them for particulary size limt. So is this possible? Can anybody guide me regarding this? Thanx in advance. Zak Greant [EMAIL PROTECTED] wrote: On Thu, Mar 27, 2003 at 02:35:18PM -0600, Jeff Kilpatrick wrote: 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. The theoritical maximum table size for the various storage engines is: BDB : 32 TB InnoDB: 64 TB MyISAM: 8 x 10^6 TB With BDB and InnoDB, you can actually have a maximum table size of 256 TB - however, you have to increase the page size when MySQL is compiled. Cheers! --zak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
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 and Backup
Dear Friends I am new in this list I am using mysql on linux My problem is about the backup of mysql database We are having 50 Databases and each database is of minimum of 300 MB in size and maximum of 2 G.B size I am planning to take incremental backup of the database For that i am planning to use mysqldump,But i m bit doughtful about the mysqldump because the size of the database is very huge I tried but it's taking a lot of time So can anybody guide me regarding the mysql backup policies? or can anybody suggest me the url from where i can get the information? Thanx in advance __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql And Backup
Dear Friends I am new in this list I am using mysql on linux My problem is about the backup of mysql database We are having 50 Databases and each database is of minimum of 300 MB in size and maximum of 2 G.B size I am planning to take incremental backup of the database For that i am planning to use mysqldump,But i m bit doughtful about the mysqldump because the size of the database is very huge I tried but it's taking a lot of time So can anybody guide me regarding the mysql backup policies? or can anybody suggest me the url from where i can get the information? Thanx in advance __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php