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
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)
- 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?
----- Original Message -----
From: "Heikki Tuuri" <Heikki.Tuuri@stripped>
Sent: Friday, October 24, 2003 10:55 AM
Subject: Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1
> 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
> would be nice for current MySQL users.
> In Oracle, one can store several tables into a single named tablespace,
> can also split indexes and data of a single table to separate tablespaces.
> Nothing prevents adding those features to InnoDB, too. It just requires
> syntax in CREATE TABLE to specify these options.
> Best regards,
> Innobase Oy
> InnoDB - transactions, row level locking, and foreign keys for MySQL
> InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM
> 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
> 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.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: