Hi, We are about to build some new database servers and I have some questions which I'd like some advice on.
The machines we are building have 4 Xeon 2GHz CPU's, 4 x 32GB SCSI disk using RAID 1+0 (so thats 64GB of storage) and 4 Gig of RAM. The OS will be Redhat 7.3. Other than the mysql database all other tables will be InnoDB, there are only 8 tables with a few of them having millions of records. The data stored will be a cache of third party information for my application to use so there will be many read/writes. Now my questions are : Which file system would you recommend for this ? I've seen many recommendations for ReiserFS but have no experience of it. Should I use a pre-compiled binary or should I compile one myself ? Should the 2 disks for storage be split up into partitions or just 1 large partition per disk ? Is there anything else I should consider when configuring the machines that affect the performance ? I'm quite happy with configuration of the my.cnf for an InnoDB setup and also taking into account of the Linux GLIBC 2GB memory bug. Many Thanks. Marvin ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
