List:General Discussion« Previous MessageNext Message »
From:Eduardo D Piovesam Date:October 24 2003 3:37pm
Subject:Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1
View as plain text  
Heikki,

Thanks for clarifying, and as you see, I'm new to MySQL (came from Oracle).

I'll read all the docs first (I'm doing it right now). ;)

We're evaluating MySQL (InnoDB) on NetWare65, we'll move all our Oracle
servers (also, on NetWare) to it, and then start testing.

Currently we have only 2 problems : view + stored procedures, but we can do
some "workaround" because we have only a few of them.

Regards,
Eduardo

----- Original Message -----
From: "Heikki Tuuri" <Heikki.Tuuri@stripped>
To: "Eduardo D Piovesam" <eduardo@stripped>; <mysql@stripped>
Sent: Friday, October 24, 2003 11:23 AM
Subject: Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1


> Eduardo,
>
> ----- Alkuperäinen viesti -----
> Lähettäjä: "Eduardo D Piovesam" <eduardo@stripped>
> Vastaanottaja: "Heikki Tuuri" <Heikki.Tuuri@stripped>;
> <mysql@stripped>
> Lähetetty: Friday, October 24, 2003 6:17 PM
> Aihe: Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1
>
>
> > Hello Heikki, thanks for your reply.
> >
> > It was just my curiosity, with the MyISAM concept it's good for the OS,
> > because it'll cache only the tables most useds, and not "all" the
> tablespace
> > file.
>
> but InnoDB only caches the most used 16 kB pages in the tablespaces to the
> buffer pool. MyISAM does not cache .MYD file contents at all, but relies
on
> the OS file cache for them. The MyISAM key_buffer caches .MYI contents.
>
> > And how to administer the multiple tablespace support? I'm worried in
the
> > space unused by some tables, example:
> > - Multiple tablespace support active
> > - Minium tablespace size is 500MB (in the my.cnf)
>
> The minimum size for an .ibd file is 64 kB. It grows page by page to 1 MB,
> up to 32 MB in 1 MB chunks, and after that in 8 MB chunks. .ibd files are
> always 'auto-extending' tablespaces. You do not specify their size in
> my.cnf.
>
> > - 2 tables in the InnoDB database, table1 have only 10kb (few rows), and
> > table2 have 600MB
> >
> > Then you'll have:
> > - table1.ibd with 10kb or 500MB?
> > - 2 x table2.ibd files with 500MB each or
> > - Just one table2.ibd with 600MB or 1GB?
> >
> > Thanks again,
> > Eduardo
>
> 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
>
>
> > ----- Original Message -----
> > From: "Heikki Tuuri" <Heikki.Tuuri@stripped>
> > To: <mysql@stripped>
> > Sent: Friday, October 24, 2003 10:55 AM
> > 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