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.ran...@stigasoft.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. > >