List:General Discussion« Previous MessageNext Message »
From:Heikki Tuuri Date:October 27 2003 12:42pm
Subject:Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1
View as plain text  
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" <jhancock@stripped>
> > Vastaanottaja: "Heikki Tuuri" <Heikki.Tuuri@stripped>
> > 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" <Heikki.Tuuri@stripped>
> > > To: <mysql@stripped>
> > > 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" (eduardo@stripped)
> > > > 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/mysql?unsub=1
> > > >
> > > >
> > >
> >
> >
>

Thread
MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Heikki Tuuri22 Oct
  • Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Chris Nolan22 Oct
  • 2 Query with same criteria giving different number of rowsHector Del Curto22 Oct
    • Re: 2 Query with same criteria giving different number of rowsChris Tucker22 Oct
    • Re: 2 Query with same criteria giving different number of rowsIllyes Laszlo23 Oct
  • Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Eduardo D Piovesam23 Oct
  • Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Eduardo D Piovesam23 Oct
Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Heikki Tuuri24 Oct
Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Heikki Tuuri24 Oct
  • Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Martijn Tonies24 Oct
    • Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Chris Nolan24 Oct
  • Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Eduardo D Piovesam24 Oct
    • MySQL/InnoDB-4.0.16 +Optimizer behaviourSergey S. Kostyliov29 Oct
  • Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Heikki Tuuri24 Oct
  • Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Eduardo D Piovesam24 Oct
  • Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Martijn Tonies24 Oct
  • Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Heikki Tuuri27 Oct
Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Heikki Tuuri26 Oct
Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Martijn Tonies26 Oct
Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Jon Hancock27 Oct
  • Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Chris Nolan27 Oct
    • InnoDB on Raw partitions in OSX (was Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1)Gabriel Ricard27 Oct
  • Partial replicate InnoDB -> MyISAMJon Hancock28 Oct
    • Re: Partial replicate InnoDB -> MyISAMChris Nolan28 Oct
  • Re: Partial replicate InnoDB -> MyISAMJon Hancock28 Oct
Re: InnoDB on Raw partitions in OSX (was Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1)Heikki Tuuri27 Oct