> > 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
Oracle's Global Temporary Tables don't write to redo or rollback, and on normal tables you can "alter table tablename nologging" to shut transaction logging off. Dave > 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 --------------------------------------------------------------------- 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