[rt-users] Size of ibdata tablespaces

[Jonathan Chen]

Speaking of ibdata... what's the best size of innodb?  I have the setting below in "my.cnf" file for innodb...

innodb_data_file_path= ibdata1:25M:autoextend
set-variable = innodb_buffer_pool_size=128M
set-variable = innodb_additional_mem_pool_size=64M
set-variable = innodb_log_file_size=64M
set-variable = innodb_log_buffer_size=32M
innodb_flush_log_at_trx_commit=1


If you guys got more recommended settings, please feel free....I sure do not mind the education. =)

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Asif Iqbal
Sent: Wednesday, July 14, 2004 7:50 AM
To: rt-users at lists.fsck.com
Subject: Re: [rt-users] Size of ibdata tablespaces

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
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT wiki at http://wiki.bestpractical.com