Ok, here's another question. Given effective external locking by the OS, could MyISAM tables achieve this? If so, do you know any operating systems that would have reliable external locking?
Mike Quoting Jeremy Zawodny <[EMAIL PROTECTED]>: > On Wed, Sep 10, 2003 at 06:00:55PM -0600, Mike Hillyer wrote: > > Hi All; > > > > First of all, I think this will probably be a question for Heikki. > > > > If I remember correctly, InnoDB and the MySQL external locking flag are > > unrelated as InnoDB tables are unaffected by external locks. > > > > Now the question: is it possible for two MySQL servers to access the same > > tablespace in a shared disk cluster? > > I'm not Heikki, but I'm also pretty sure you can't do that today with > InnoDB tables. Not only would performance suffer, I don't believe > there's a mechanism in place for a shared transaction log... > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 4.0.15-Yahoo-SMP: up 4 days, processed 165,040,351 queries (451/sec. > avg) > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
