Hi!
At 02:59 PM 8/7/01 +0300, you wrote:
>Grigory Bakunov writes:
>> Date |Fri, 3 Aug 2001 17:21 +0200
>> >From |TIGNAC BRUNO <[EMAIL PROTECTED]>
>>
>> Hello!
>>
>> TB> --- Reçu de CMB.TIGNABR 0298426574 03-08-01
17.21
>>
>> TB> Hello,
>>
>> TB> I plan to use MySQL/InnoDB to store about 13 GB of data, into 40
tables. One
>> TB> of the tables is over 5 GB, and a second over 1,5 GB. Do you think I
can use
>> TB> MySQL/InnoDB ?
>>
>> In short words: YES.
>> ___________________________________________________________________
>> For technical support contracts, visit https://order.mysql.com/
>> This email is sponsored by SWSoft, http://www.asplinux.ru/
>> __ ___ ___ ____ __
>> / |/ /_ __/ __/ __ \/ / Grigory Bakunov <[EMAIL PROTECTED]>
>> / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft
>> /_/ /_/\_, /___/\___\_\___/
>> <___/ www.mysql.com
>>
>
>
>Next time provide more info.
>
>Actually largest tablespace in InnoDB is 4 Gb, but a single table can be
>spanned over as many tablespaces as you wish.
>
>Heikki, am I right ?
The totality of your data files is called the 'tablespace'.
The tablespace can be 4 billion database pages (page == 16 kB)
in size. A single table is allowed to extend to the whole tablespace.
A data file should be < 4 GB, or < 2 GB if your file system only
supports < 2 GB files.
Regards,
Heikki
>--
>Regards,
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
>/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
> <___/ www.mysql.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