Dobrý den,
quarta-feira, 18 de dezembro de 2002, 13:10:07, napsal jste:
MTB> Qunfeng Dong wrote:
>>Another thing, with some linux system, there is a size
>>limit for file. MySQL seems to store each of its table
>>as single file. You need to choose a file system
>>without that limit.
>>
MTB> Just use InnoDB tables for these files and you won't have a problem
MTB> AFAIK; you can have multiple 2G files that are used to create one big
MTB> table if you like (any InnoDB people want to comment on actual limits?)
Use the InnoDB tables with the raw devices ( ex: allow innodb use a
/dev/sdxx or /dev/hdxx to write tablespace ), the speed is better,
MySQL don't loses time with the filesystem.
In my production database , i have a tablespace with 130G ( with raw
diveces on SCSI disks) and the performance is good :)
ps: i'm using MySQL 4.0.5
sql,query
-------------------------------------------------------------------------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-------------------------------------------------------------------------
E S C R I B A I N F O R M A T I C A
-------------------------------------------------------------------------
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
--
$ look into "my eyes"
look: cannot open my eyes
-------------------------------------------------------------------------
Reply: [EMAIL PROTECTED]
---------------------------------------------------------------------
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
