In order to choose a DBMS, i've to check to MySQL is able to support our
requirements.
I've got to manage one database.
This database is made of one table.
This table will grow very quickly (we evaluate that we'll have to make
arround 1.000.000.000 inserts per day).
I want to be sure that MySQL is able to manage table bigger than 1 Tera
Octet.
Does anyone have already use in similar condition ?
I read that innobase table allows to store a table on several oracle-like
"tablespace" that can be created on several disks. I think we can put the
indexes on other disk too (using symbolic links).
I would like to know what are the requirement to store so much records.
Does anyome have reference of site that manage a table bigger than 1 tera ?
Did someone try that ?
I hope it's possible.
Otherwise, i'll to choose Oracle :( and Oracle is not cheap.
Regards,
--
Pascal Thivent
Groupe SQLI
Web : <http://www.sqli.com/> http://www.sqli.com
Mail : <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
Tel : +33 (0)1 55 93 25 39
---------------------------------------------------------------------
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