On Thursday 10 July 2003 22:15, Brad Brad wrote: > 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 :)
I'd say 3-4 Gigabyte was rather excessive, seems like the salesman is trying to increase his own provision of the sale... But with RAM being cheap, and you do have quite a few sessions going there, I'd probably go for something in the area of 1-2 gigabytes... Too much ram doesn't hurt either ;-) -- Andreas D. Landmark / noXtension -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]