> Hi all.
>
> Apologies for not lurking long and if this question is answered
> somewhere I
> haven't yet found, but I'm on a timescale here...
>
> My company is looking to use MySQL on free *nix (FreeBSD or
> Linux) to store
> some text data and a *lot* of BLOB data.
>
> I am trying to check that MySQL will cope with the volumes. My longest
> table will be between one and two million records, and I intend to hold
> approaching a terabyte of BLOB data in 45-60kB objects.
>
> Can anyone give me a quick yes/no and a heads up on problems or where to
> find documentation please?
As for max. sizes etc.:
http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_0_0
See also the crash-me pages at the MySQL web site.
A search in the mailing list archives should give
you some hints on how to handle large data sets;
the subject comes up every now and then...
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
---------------------------------------------------------------------
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