[rt-users] Size of ibdata tablespaces

[Ruslan U. Zakirov]

Asif, did you read MySQL manual? I sent you link. There is answer on the 
page. Read 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;

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.

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