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

Reply via email to