List:General Discussion« Previous MessageNext Message »
From:Manish Ranjan \(Stigasoft\) Date:November 24 2009 4:39pm
Subject:RE: MySQL Performance with large data
View as plain text  
Thank you Johan.

 

The table will be read only. There will be two steps - first to get the
count using search conditions and then to get data from some columns based
on those search conditions. The fields will be indexed as per search
requirements.

 

  _____  

From: vegivamp@stripped [mailto:vegivamp@stripped] On Behalf Of Johan De
Meersman
Sent: Tuesday, November 24, 2009 9:56 PM
To: Manish Ranjan (Stigasoft)
Cc: mysql@stripped
Subject: Re: MySQL Performance with large data

 

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.ranjan@stripped> 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.

 



Thread
MySQL Performance with large dataManish Ranjan \(Stigasoft\)24 Nov
  • Re: MySQL Performance with large dataJohan De Meersman24 Nov
    • RE: MySQL Performance with large dataManish Ranjan \(Stigasoft\)24 Nov
      • Re: MySQL Performance with large dataJohan De Meersman24 Nov
        • Re: MySQL Performance with large dataMichael Dykman24 Nov