List:General Discussion« Previous MessageNext Message »
From:Eduardo D Piovesam Date:October 23 2003 10:41pm
Subject:Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1
View as plain text  
(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


----- Original Message -----
From: "Heikki Tuuri" <Heikki.Tuuri@stripped>
To: <mysql@stripped>; <win32@stripped>
Sent: Wednesday, October 22, 2003 12:00 PM
Subject: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1


> Hi!
>
> InnoDB is a MySQL table type which provides transactions, row-level
locking,
> non-locking consistent SELECT (multiversioned concurrency control),
foreign
> key constraints, and a non-free hot backup tool for backing up InnoDB
> tables.
>
> InnoDB is included in all MySQL-4.0 and 4.1 downloads, and also in the
MySQL
> Pro commercial, non-GPL MySQL license.
>
> Release 4.0.16 is a bugfix release of the stable 4.0 branch. There are a
few
> known outstanding bugs in InnoDB-4.0.16, but their fixing has been
delayed,
> because we are allocating all free resources to preparing the upcoming
> MySQL-4.1.1 release.
>
> ---
>
> A sneak peek of MySQL-4.1.1:
>
> NOTE: if you upgrade to InnoDB-4.1.1, you cannot downgrade any more! That
is
> because earlier versions of InnoDB are not aware of multiple tablespaces.
>
> The public BitKeeper source tree of 4.1 now supports multiple tablespaces
> for InnoDB. You can enable them with the line
>
> innodb_file_per_table
>
> in the [mysqld] section of my.cnf. Then InnoDB stores each table into its
> own file
>
> tablename.ibd
>
> in the database directory where the table belongs. This is like MyISAM
does,
> but MyISAM divides the table to a data file tablename.MYD and the index
file
> tablename.MYI. For InnoDB, both the data and the indexes are in the .ibd
> file.
>
> If you remove the line, then InnoDB creates tables in the ibdata files
> again.
>
> InnoDB always needs the 'system tablespace', .ibd files are not enough.
The
> system tablespace consists of the familiar ibdata files. InnoDB puts there
> its internal data dictionary and undo logs.
>
> You CANNOT FREELY MOVE .ibd files around, like you can MyISAM tables. This
> is because the table definition is stored in the InnoDB system tablespace,
> and also because InnoDB must preserve the consistency of transaction id's
> and log sequence numbers.
>
> You can move an .ibd file and the associated table from a database to
> another (within the same MySQL/InnoDB installation) with the familiar
RENAME
> trick:
>
> RENAME TABLE olddatabasename.tablename TO newdatabasename.tablename;
>
> If you have a 'clean' backup of an .ibd file taken from the SAME
> MySQL/InnoDB installation, you can restore it to an InnoDB database with
the
> commands:
>
> ALTER TABLE tablename DISCARD TABLESPACE; /* CAUTION: deletes the current
> .ibd file! */
> <put the backup .ibd file to the proper place>
> ALTER TABLE tablename IMPORT TABLESPACE;
>
> 'Clean' in this context means:
>
> 1) There are no uncommitted modifications by transactions in the .ibd
file.
> 2) There are no unmerged insert buffer entries to the .ibd file.
> 3) Purge has removed all delete-marked index records from the .ibd file.
> 4) mysqld has flushed all modified pages of the .ibd file from the buffer
> pool to the file.
>
> You can make such a clean backup .ibd file with the following method.
>
> 1) Stop all activity from the mysqld server and commit all transactions.
> 2) Wait that SHOW INNODB STATUS\G shows that there are no active
> transactions in the database, and the 'main thread' of InnoDB is 'Waiting
> for server activity'. Then you can take a copy of the .ibd file.
>
> Another (non-free) method to make such a clean .ibd file is to
> 1) Use InnoDB Hot Backup to backup the InnoDB installation.
> 2) Start a second mysqld server on the backup and let it clean up the .ibd
> files.
>
> It is in the TODO to allow moving clean .ibd files also to another
> MySQL/InnoDB installation. That requires resetting of trx id's and log
> sequence numbers in the .ibd file.
>
> ---
>
> InnoDB changelog for 4.0.16:
>
> * Fixed a bug: contrary to what was said in the manual, in a locking read
> InnoDB set two record locks if a unique exact match search condition was
> used on a multi-column unique key. For a single column unique key it
worked
> right.
>
> * Fixed a bug: if one used the rename trick #sql... -> rsql... described
in
> section 15.1 of http://www.innodb.com/ibman.html to recover a temporary
> table, InnoDB asserted in row_mysql_lock_data_dictionary().
>
> * There are several outstanding non-critical bugs reported in the MySQL
bugs
> database. Their fixing has been delayed, because resources are allocated
to
> the upcoming 4.1.1 release.
>
> Best regards,
>
> Heikki Tuuri
> Innobase Oy
> http://www.innodb.com
>
>
>
> --
> 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