Where can I get a "tuning guide" for MySQL (MyISAM and InnoDB)... memory-wise and son on?

At 11:11 13/11/02 -0800, you wrote:
On Tue, Nov 12, 2002 at 11:22:11PM -0800, Devore, Jacob wrote:
>
> Can any of you point me to documentation or have a quick summary of
> how beefy to make a mysql server. Basically we probably won't have
> more than 50 connections at one time and we will be pushing packets
> of 2Mb at times. I'm curious if I should go with tons of ram,
> faster cpu's, a gig nic, or is it even worth it to upgrade our
> server. I believe right now it's on a dual 400 p2 with 512Mb of ram
> and 100Mb connection.

Do some benchmarking. I suspect you'll find that your current
hardware is adaquate, assuming that MySQL and your operating system
are well tuned.

Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/

MySQL 3.23.51: up 99 days, processed 2,102,130,626 queries (244/sec. avg)

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

Reply via email to