Thank you for your response (I said right?!? sorry for my little english!)
what you say is very interesting!!!
Where can I read more about RAID_TYPE ecc... (the 3° solution you said?)?
Now I'm writing the program in C and I have not meet this problem but I
will!!!! :-(
Just for curiosity: I have to study the flow of data in a net : I'm working
in a network desing. If somebody is doing that or is interested we can
exchange experiences and suggestions.
Thank you again.
Mario.
Il 16:51, giovedì 15 marzo 2001, scrivesti:
> Hi Mario,
> I think I had the same problem as you, and got som help...
> You have three ways of doing this:
> 1. Switch to a FileSystem that supports bigger Files
>
> 2. Use MERGE, create a lot of small tables and use MERGE
> in you select Querys, The manual is quit god at explaining
> how to do this, but I'll think you will find the limitations
> about INSERT as irritating as I
>
> 3. Use the --with-raid option. This is what I do. You need to
> recompile the mysqld using --with-raid when configuering it.
> This way you can create tables Using: RAID_TYPE=1 RAID_CHUNKS=XX
> RAID_CHUNKSIZE=YY
> The RAID_CHUNKS tells the mysql how many separate files it will
> split the DB into. IE. RAID_CHUNKS=100 will create 100 datafiles,
> wich each can be 2GB = 2 000 GB. More about this in CREATE TABLE.
> The problem with this is the indexfile, wich now is the problem (max 2GB)
> But I'll will reach that in about 2 weeks so ill figure something out by
> then.
>
> /roger
>
> >I have to store data for Internet desining (10-20 Gb at Day)
> >so I have to use a data base very fast: MySql is fast?
> >
> >I have to put 10-20 Gb of data every day: but I can have a table only of
> >2Gb
> >(I know that reading manual of Mysql).
> >How to do a table so big?
> >
> >Thank you in advance, Rino.
> >
> >---------------------------------------------------------------------
> >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
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
