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
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