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