I've always figured that if your tablespaces are tight enough to
autoextend, you're going to take a performance hit. InnoDB uses the
tablespace for some transaction/rolebacks -- if you have a large
transaction going through it will be slowed down by an autoextend
operation. Plus, once you're there, you're probably going to be always
autoextending. I can't find anything 'official' that says this, so I
could be talking straight out of butt.
If you're talking about autoextending files on a 1.5TB database,
you're going to have 50GB files anyway. I'd sooner control it than let
it grow wildly.
On Wed, 16 Feb 2005 19:44:56 +0800, proace <proace@stripped> wrote:
> I expect the data size is no more then 1.5TB.
> Why don't you like to let tablespace auto grow?
> Is it performace issue or not?
> If I create ten innodb_data_file and each size of innodb_data_file is 50G,
> dose some issues must be take care?
> Because the 50G is really very big for a file, I never do it.
> On Tue, 15 Feb 2005 07:27:42 -0800, Gary Richardson
> <gary.richardson@stripped> wrote:
> > My preference is to use innodb_data_file. If everything is InnoDB, I
> > would probably create 25G or 50G files until you've created enough to
> > hold all the data plus enough for growth. Do you know specifically how
> > big the data is?
> > I don't like to let my table space autogrow, so I have monitors
> > watching the free innodb space. If it gets tight, I manually add more
> > space.
> > On Tue, 15 Feb 2005 20:25:36 +0800, proace Tsai <proace@stripped> wrote:
> > > Hello:
> > >
> > > The mysql server is estimated to be as follows,
> > > 1. two servers, one is master and the other is slaves (replication)
> > > 2. two databases in mysql
> > > 3. 513 tables in each database
> > > 4. about 3000000 rows in each table
> > > 5. about 2T disk space for each server using SAN Storage
> > > 6. backup database periodically
> > >
> > > The running environment is follows,
> > > Server: Dual Intel Xeon 3.2G with 4G DDR2 Memory.
> > > OS: FreeBSD 5.3-RELEASE
> > > MySQL: 4.1 branch
> > > Operation: 70 ~ 80% operation is query (select statement)
> > >
> > > According to the above terms,
> > > how to plan the Tablespace in the mysql server?
> > > Using raw devices for the tablespace or innodb_data_file?
> > > ( How many Tablespace do I create? )
> > > or using innodb_data_file with innodb_file_per_table?
> > >
> > > Regards,
> > > proace.
> > >