Rock, >Hi, >Does MySql support Synchronous or asynchronous I/O or >both? >What do they mean when they ask me if- > copy Db is supported by mysql? I am not sure what this means. MySQL has replication capability yes. > version db is supported by mysql? The meaning is not clear. The InnoDB table handler in MySQL has multiversioned concurrency control. > Sync/Async write strategies? MyISAM always does kind of async write because it writes to the file cache and does not call fsync to flush to disk. The InnoDB table handler does also async write batch of about 100 database pages at a time, and after that calls fsync to flush to disk. >Currently I have been asked to evaluate mysql against >TimesTen. Is there such an comparision available? I have not seen any. The main difference is that TimesTen is a main memory database: when your data grows bigger that the RAM in your computer you are in trouble. MySQL is a disk-based database. Main memory databases are used for their speed. But I once measured a main memory database against InnoDB and the speeds were roughly equal. >As you can see I'm new to this, request ur patience > >thanks >rock >===== Regards, Heikki Tuuri Innobase Oy http://www.innodb.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
