Sirisha,
you cannot remove just a single ibdata file:
http://dev.mysql.com/doc/mysql/en/Adding_and_removing.html
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php
----- Original Message ----- From: "sirisha gnvg" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, January 21, 2005 7:40 PM
Subject: innodb tablespaces
--0-1651880585-1106329175=:61237 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
We are working with mysql 4.1.8 version and windows XP os.
In that version the default amount of tablespace for data files and index files is given as data_file_path=ibdata1:10M .we then executed 'show table status' command and got innodb freespace:4092 KB (in comment column)
We then created another tablespace as data_file_path=ibdata1:10M;ibdata2:5M .
Then we executed the following statements use sample /* user defined database*/ show table status /*we want free space in tablespace and we saw in manual that comment column of of show table status gives that.*/
We got in comment column innodb free space=9212 KB (nearly 9 MB)
Then we removed ibdata2 manually from 'data' directory and also deleted the ibdata2:5M from my.ini file and again created ibdata2 with 7MB size as follows
data_file_path=ibdata1:10M;ibdata2=7M
Again we saw show table status output.
It gave innodb freespace:16380KB (nearly 16MB)
We have done it many times i.e removing ibdata2 and again adding it.
But the comment column gave always the aggregate value as u can see from above output where the freespace is given as 16MB when it should be 11MB(4MB+7MB).
Why did this occur?Should we not remove the ibdata2 file once it is created?If at all if we want to remove it,what are the places from where we have to remove it?
Does show table status always give correct values? Thanking you,
yours sincerely,
sirisha.
Yahoo! India Matrimony: Find your life partneronline.
--0-1651880585-1106329175=:61237--
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
