> > > Hi,
> > >
> > > I have a problem, my database has reached Linux Redhat 7.1
> > > max file size. (2147483647 Bytes). Does eny one know what i
> > > can do to make a lager database. (lager
> > > filesystem)
> > >
> > > Thanks
> > > Erik Dhiin
I myself run a 300Gb database on a Linux redhat 6.0 Machine.
And it works fine.
What you do is to read the manual about the CREATE TABLE .... RAIDTYPE =
.......
But before you do that you need to recompile using --with-raid, or download
the -max version wich I think has the raid option.
What the raid option do is to split the data files up into alot of smaller
files (RAIDCHUNKS=XX) But only the datafile. Not the indexfile, with is my
problem. So What I have done is to create my own indexfiles (its about 170
tables) and agve a realy simple key column (that isn't space comsuming in
the index)
I loose alot of performance in many of the serahces, but the searching in
the indexfiles of my own I Can make a query over the 300Gb (about 4 500 000
000 rows) in about 2 sec, wich is ok for now.
/roger
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
