[rt-users] Size of ibdata tablespaces

[Asif Iqbal]

Ruslan U. Zakirov wrote:
> Asif, did you read MySQL manual? I sent you link. There is answer on the 
> page. Read it.

Oops!! I just saw it

> 
> Did you try an expirement:
> mysql -u root -p test
> CREATE TABLE ibdata_size_test(...) TYPE=InnoDB;
> INSERT INTO ibdata_size_test VALUES(...);
> FLUSH TABLES;

I will give these tests a shot tonight

> 
> ensure that ibdata growing after several inserts
> then do
> DELETE FROM ibdata_size_test;
> FLUSH TABLE;
> check size
> !!! First result here !!!
> 
> then try the same INSERTs again and FLUSH
> does the size grows? !!! Second experiment results !!!
> 
> 			Ruslan.

Thanks a lot

> 
> Asif Iqbal wrote:
> >Hi All
> >
> >I am planning to use RTx::Shredder to delete old tickets. I wanted to
> >know if that will help reduce the size of my ibdata tablespaces. I 
> >currently
> >have two ibdata tablespaces. The total size of them is 5gig, which is
> >taking about 80% of my disk partition and growing. I have no other disk
> >at this point to extend the ibdata tablespaces
> >
> >I am currently using RT 3.2.0 with MySQL 4.0.13/ModPerl1/Apache 1.3.x on
> >Solaris 8/4x400Mhz/4G ram/E 420R
> >
> >Thanks
> 

-- 
Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
There's no place like 127.0.0.1