I agree with those thoughts, but maybe my professional experience in dealing with a similar situation will provide you a little insight.
>From experience, if the boxes are not true server motherboards, you may not get the desired results using the 750MHz and 3GB of RAM. This being that even though the motherboard can handle the size capacity, it may not utilize the processing capacity. I would stick with the other choice. With my systems, I have heavy traffic loads that peak betweek 3-5pm and the monitoring revealed that the faster processor with the lower RAM would keep things running smoothly. Bruce ----- Original Message ----- From: "Benjamin Pflugmann" <[EMAIL PROTECTED]> To: "David Jourard" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 3:54 PM Subject: Re: Whats better increase RAM or CPU for a mysql/perl app. > Hi David. > > On Wed 2002-10-30 at 14:56:38 -0600, [EMAIL PROTECTED] wrote: > > > > I have a word search application using mysql and (perl or mod_perl). > > After all the optimization of code I now want to get a faster box. > > > [...] > > I have 2 choices: > > a. box with 1.3 GHZ with 1.5 GIG of RAM > > b. 750 MHZ with 3 GIG of RAM > > > > These 2 choices are limited by cost. > > > > What would be better for a mysql/(perl or mod_perl) application the CPU > > speed or the need for RAM. > > The answer is: it depends. > > It depends on a lot of underlying variables of which you provided only > a handful (e.g. the database sizes and usage patterns are missing). > Even if you had provided more information, it is always a hard guess > what will become the next bottleneck without intimate knowledge of the > application. > > You should try to find out which will become your next bottleneck by > writing some tests scripts and running them against your current > hardware. While doing so, observe the system stats, e.g. with vmstat > or alike. > > Regards, > > Benjamin. > > -- > [EMAIL PROTECTED] > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
