On Fri, 2001-10-05 at 12:13, Carl Troein wrote: > It seems to be pretty popular to have a large number of databases, > but I guess it's mostly due to having a large number of users. > In pthe project I'm working on now we have 3 databases, 2 of which > are mysql and test. However, some of our tables will grow quite > big (several gigabytes). Will MyISAM be the best table type for > those, or under what circumstances will/won't it be? Also, what > file system (for linux) do you recommend? ReiserFS or ext3 or > something else?
There is no universal solution. HEAP tables are fast as they are only in memory, MyISAM tables are fast when used for reading, InnoDB is best on heavy use with concurrent writes. InnoDB and DBD are different in locking scheme, so depending on context DBD can beat InnoDB. Anyway usually we suggest to make decision between MySQL and InnoDB. BTW, this is unique in MySQL - you can have tables mixed to be transactional (InnoDB) and nontransactional (MyISAM) and use them mixed in same query. All other SQL-s (as much I know) have transactions on every table even if user don't need this. But usually tables contain different information, they have different usage and this affects things :) I do not know about ext3 much but rumours talk that it is just some kind of add-on on top of ext2. We have compared ext2 and ReiserFS when latter came out and ReiserFS was in some tests 30% faster in writes. Also ReiserFS can handle issues with directories containing 10000 files much faster. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia <___/ www.mysql.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
