Jon, FULLTEXT is far away, unless we find a corporate sponsor. Could your company sponsor the porting?
Journaled file systems are just extra overhead for InnoDB, though the overhead seems to be small. Regards, Heikki > > ----- Alkuperäinen viesti ----- > > Lähettäjä: "Jon Hancock" <[EMAIL PROTECTED]> > > Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> > > Lähetetty: Monday, October 27, 2003 10:42 AM > > Aihe: Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1 > > > > > > > Heikki, > > > I have two questions in regards to the tablespace changes: > > > > > > 1 - You mention being able to store indexes in a seperate tablespace. > How > > > far off is this for MySQL to implement? I would like to see FULLTEXT > > > indexes stored in seperate tablspace (seperate RAID channel) so the two > > > features (InnoDB FULLTEXT) would both need to be available. > > > 2 - Is there any value to using Journaled file systems with the InnoDB > > > tablespaces? A new system I'm putting together will have seperate > drives > > > for only InnoDB data. Is a Journaled file system extra overhead? If > so, > > is > > > Raw significantly more efficient? How does this choice effect backup > > > soultion? > > > > > > thanks, Jon > > > > > > ----- Original Message ----- > > > From: "Heikki Tuuri" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Friday, October 24, 2003 9:55 PM > > > Subject: Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1 > > > > > > > > > > Eduardo, > > > > > > > > to make the user interface simple, I decided to take the table per > file > > > > approach. Each .ibd file is internally a 'tablespace'. > > > > > > > > The simple approach I chose is similar to how MyISAM now works. I > > thought > > > it > > > > would be nice for current MySQL users. > > > > > > > > In Oracle, one can store several tables into a single named > tablespace, > > > and > > > > can also split indexes and data of a single table to separate > > tablespaces. > > > > Nothing prevents adding those features to InnoDB, too. It just > requires > > > new > > > > syntax in CREATE TABLE to specify these options. > > > > > > > > Best regards, > > > > > > > > Heikki > > > > Innobase Oy > > > > http://www.innodb.com > > > > InnoDB - transactions, row level locking, and foreign keys for MySQL > > > > InnoDB Hot Backup - hot backup tool for InnoDB which also backs up > > MyISAM > > > > tables > > > > > > > > .......................... > > > > From: "Eduardo D Piovesam" ([EMAIL PROTECTED]) > > > > Subject: Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1 > > > > > > > > > > > > View this article only > > > > Newsgroups: mailing.database.myodbc > > > > Date: 2003-10-23 14:43:28 PST > > > > > > > > (Sorry for the last email, it's not complete). > > > > > > > > Hello Heikki, > > > > > > > > Sorry, but I didn't understand the concept of tablespace applied. It's > > > > different from Oracle, right? > > > > > > > > AFAIK, tablespace is utilized to logically group "tables" into one (or > > > > more) > > > > files. > > > > > > > > And to group "indexes" into another files... > > > > > > > > But you said that the each table (with its indexes) will be in one > > file... > > > > is there an reason? Is it better than "split" tables and indexes? > > > > > > > > Thank you. > > > > > > > > Eduardo > > > > > > > > > > > > -- > > > > MySQL General Mailing List > > > > For list archives: http://lists.mysql.com/mysql > > > > To unsubscribe: > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]