On Tue, Sep 28, 2010 at 10:23 AM, Vokern <vok...@gmail.com> wrote: > 2010/9/28 Jangita <jang...@jangita.com>: > > > > > 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
