> The db directory is 80mb total > handling 14 requests/s with all queries being simple INSERT or SELECT's.
1GB ram should be more than enough for your needs. If you are doing lots of the same kind of selects, I would dedicate a good chunk of that memory to MySQL query caching (maybe 64MB ish). If it's quite insert heavy then I would put some more emphesis on disk speed (get scsi 10,000 rpm disk). If, as you say, your queries are simple then that configuration should give you plenty of capacity to expand to hundreds of queries per second. Another good thing to do if you go for a 1GB solution would be to make sure that the server has 2 x 512MB sticks of ram (or even 1 x 1GB) so that there are slots free for future expansion in that area (in other words don't let them fill all the slots with 256MB sticks). > Dell salesmen started pushing 3-4Gb of ram, i'm not sure if this is excessive though. This is excessive indeed! (disclaimer: I think Dell are an excellent company and I respect what they do.) Hope this helps, Andrew -----Original Message----- From: Brad Brad [mailto:[EMAIL PROTECTED] Sent: Thursday 10 July 2003 21:15 To: [EMAIL PROTECTED] Subject: Recomended RAM for production server. 3Gb overboard? Hi, I'm looking at buying a new production server, as soon as i mentioned mysql the Dell salesmen started pushing 3-4Gb of ram, i'm not sure if this is excessive though. The OpenBSD server is 2.8Ghz and may have as many as 230 mysql sessions with 14 queries a second, the rest will be sleeping (ftp sessions maintain connection). The db directory is 80mb total, and the server is currently handling 14 requests/s with all queries being simple INSERT or SELECT's. The server also does low levels of firewall/ftp/http-perl/email. The old server is seems quite happy with 512mb. Do you guys think 3-4Gb is fair or excessive for this workload? Of course i wouldn't mind some headspace to grow. Unfortunatly i don't expect 6x increase any time soon though :) Thanks :) Brad. _________________________________________________________________ Få gode tilbud direkte i din mailbox http://jatak.msn.dk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
