If Linux works the same way as HP-UX (and it should), anything you do to an open file (including deleting it) has no effect until the file is closed. The MySQL server is still using the "old" file. The next time it stops and restarts, it will follow the symlink. I don't know what the effect of accessing a "stale" copy of the file will do.
Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com >-----Original Message----- >From: Sebastian Mendel [mailto:[EMAIL PROTECTED] >Sent: Wednesday, April 23, 2008 9:27 AM >To: Dobromir Velev >Cc: mysql@lists.mysql.com >Subject: Re: Symlink InnoDB tables without stoping MySQL > >Dobromir Velev schrieb: >> Hi, >> What I'm trying to do is to create a new InnoDB table on a different >disk and >> symlink it to an existing database. >> I have innodb_file_per_table turned on and here is how I tried to do >it >> >> >> mysql> \u test >> mysql> create table test (...) ENGINE = 'InnoDB'; >> mysql>\q >> >> move the test.ibd file to the other disk >> create a simlink in the database directory >> flush tables; >> >> >> This works as expected but there is something that bothers me - I >inserted >> about 60K rows in the new table and all queries I tried are working >> including selects, inserts and updates. The "SHOW TABLE STATUS" >command >> displays relevant results and still the test.ibd file to which the >symlink >> points hasn't been changed or accessed at all. >> >> Any ideas are welcome > >you need to setup per-table tablespace, did you? > >Section 13.2.3.1, "Using Per-Table Tablespaces". > >http://dev.mysql.com/doc/refman/5.0/en/innodb-init.html > >-- >Sebastian Mendel > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
