Re: How to extend innodb files?

[Johan De Meersman]

On Tue, Sep 28, 2010 at 10:23 AM, Vokern <vokern@stripped> wrote:

> 2010/9/28 Jangita <jangita@stripped>:
>
> >
> > I do not think there is anything wrong with having one huge file is
> there?
> > We have one innodb file of 85GB on ext3.
>

In and of itself, there is no problem with that. You may, however, prefer
multiple smaller files for managability, when doing file-level backups, to
put files on different disks, ...

It works just as well, but there can be reasons to split, too.


> but how about the problem on the file has been increasing continuously?
>

The file size increases as you add data to InnoDB tables. This is nothing to
worry about - unless you *aren't* actually adding data :-)


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel