From: Johan De Meersman (vegivamptuxera.be)
Date: Tue Nov 24 2009 - 10:26:12 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

The amount and type of data is less the issue than the amount and type of
queries is :-) The machine you've described should be able to handle quite a
bit of load, though, if well-tuned.

On Tue, Nov 24, 2009 at 4:45 PM, Manish Ranjan (Stigasoft) <
manish.ranjanstigasoft.com> wrote:

> Hi,
>
>
>
> I am using MySQL 5.0.45 in production environment. One of my tables (using
> MyISAM Engine) is expected to have around 4 billion records and each record
> will have 1867 bytes of data. All fields in this table are of character
> data
> type. I have 8 GB RAM on the server, RAID 5 with 750 GB storage space
> available and quad core processor.
>
> My question is whether MySQL will be able to handle queries on this amount
> of data? What all things I need to consider here?
>
> Thank you.
>
>

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]