Sorry for the double-post, but another thought if it's not obvious already:
with such a large dataset, making sure to employ striping and high-RPM disks
will be important for speed. I'd recommend looking at RAID 1+0 with dual
SCSI channels and 15K RPM disks if you're looking in the Dell PowerEdge
Rich, one consideration is of course disk space - you'll want to make sure
that 2.5 billion * row length will fit on your disks.
Offhand, you've got (referencing
http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html)
78 bytes in 3 varchars (50 + 10 + 15, + 3 for internal use)
16 bytes
Hi,
I have a table (structure below) which will hold 2.5 billion rows. I'm
currently choosing the hardware i'll need. Does anybody know what the
minimum spec of machine is likely to be that I comfortably use? I
imagine the table will have to be Innodb split across a number of files.
It will
day and only
5 days a week. Very different software and hardware requirements and
probably traffic patterns. Amazon and eBay would both require
clustering and load balancing, Woot would probably only require
automatic failover.
Many is a relative term and so is high performance and high
av
to find as much information as possible about the hardware
requirements like number of processors, necessary memory, cache, HD... to
use in a high performance MySQL server
With an open-ended question like yours, your going to get open-ended answers.
I am running MySQL on several machines. One of tho
Hello,
I'm doing an University project and I need to "buy" a server for a business.
I have to simulate an enterprise that sells by Internet. There are many
clients and products in the Data Base and we use MySQL in a Linux OS.
I need to find as much information as possible abo
On Thu, Nov 06, 2003 at 10:44:04AM -0600, Paul Fine wrote:
> Greetings.
>
> Does anyone have any suggestions besides trial and error for determining how
> resource intensive my database is going to be?
>
> Is this just something the a developer just gets a feel for after developing
> a number of
Greetings.
Does anyone have any suggestions besides trial and error for determining how
resource intensive my database is going to be?
Is this just something the a developer just gets a feel for after developing
a number of databases or are there some guidelines I can use?
Thanks for any help!
SQL (E-mail)
Cc: KUMARASAMY,ELANGO (HP-India,ex2); [EMAIL PROTECTED]
Subject: What is the minimum hardware requirements for MySQL?
Hi,
What is the minimum hardware requirements of MySQL Database. Apart from the
size of the database. I am looking for limitations like
- RAM,
-Installation Space (per
Hi,
What is the minimum hardware requirements of MySQL Database. Apart from the
size of the database. I am looking for limitations like
- RAM,
-Installation Space (per instance).
etc.
Please do let me know at the earliest.
Thanks & Regards,
Prashant Kumar Gupta,
HP-High Availability
rrier)
It really depends on what you ware wanting to do.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Kevin Passey [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 04, 2002 5:53 AM
To: Mysql (E-mail)
Subject: What are the hardware requirement
To run mysql
Thanks
Kevin
Kevin Passey
KDP Software Limited
Tel: 01273 712830
Fax: 08700 510103
mailto:[EMAIL PROTECTED]
http://www.kdpsoftware.co.uk
-
Before posting, please check:
http://www.mysql.com/manual.php (the ma
icence, but
we don't know if MySQL can cope with the concurrent connections.
Can MySQL handle this sort of usage? What hardware requirements do we need
so that we can be confident that it won't fall over? Would we need to
separate the PHP server and the SQL server?
Thanks ver
13 matches
Mail list logo
