Olaf,
That's a very broad question depending upon your exact requirements
to be honest. So long as you've considered file size limitations and
you've opted for a decent RAID system there's not too much more to worry
about, try and buy the fastest disks possible obviously i.e. 15,000 RPM
one
Olaf,
Thanks for the detailed answer.
So basically the limitations come from the OS and the file system used.
What is the best file system to use for mysql (not considering the filesize
limitations)?
Thanks
Olaf
The "best" is probably ZFS if you really are intent on make things huge,
http:/
Thanks for the detailed answer.
So basically the limitations come from the OS and the file system used.
What is the best file system to use for mysql (not considering the filesize
limitations)?
Thanks
Olaf
On 12/29/06 2:25 AM, "ViSolve DB Team" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> The maxim
Hi,
The maximum effective table size for MySQL databases is usually determined by
operating system constraints on file sizes, not by MySQL internal limits.
If you need a MyISAM table that is larger than 4GB in size (and your operating
system supports large files), the CREATE TABLE statement all
FWIW, IMO LOB handling is really where MySQL lags behind all other
enterprise database solutions. Firebird, DB2, Oracle, et al all are able
to stream LOB data to and from disk so that it does not all need to be
loaded in memory (multiple times for a single LOB). I would call this a
bug but others w
At 17:06 +0200 5/29/06, schlubediwup wrote:
2. problem
according do the mysql docu TEXT/BLOB fields depend solely on the db
environment and can grow to any length:
11.4.3. The |BLOB| and |TEXT| Types
The maximum size of a |BLOB| or |TEXT| object is determined by its type, but
"d
[EMAIL PROTECTED]
Subject: Re: Max size
Date: Mon, 18 Aug 2003 23:43:19 -0700
On Mon, Aug 18, 2003 at 02:33:04PM -0500, Miguel Perez wrote:
>
> I have an ibdata file that its size is 4.5GB, and it will increase
> every day the max size of the hard disk is about 330GB, the question
> is shoul
On Mon, Aug 18, 2003 at 02:33:04PM -0500, Miguel Perez wrote:
>
> I have an ibdata file that its size is 4.5GB, and it will increase
> every day the max size of the hard disk is about 330GB, the question
> is should I split this ibdata file in several files in a way that I
> can reach this size?
D
