re: Re: mysql server hardware
Maximo, Wednesday, November 13, 2002, 10:09:07 PM, you wrote: MM> Where can I get a "tuning guide" for MySQL (MyISAM and InnoDB)... MM> memory-wise and son on? Some notes you can find in the MySQL and InnoDB manuals: http://www.innodb.com/ibman.html#InnoDB_tuning http://www.mysql.com/doc/en/System.html http://www.mysql.com/doc/en/Server_parameters.html http://www.mysql.com/doc/en/Memory_use.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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
Re: mysql server hardware
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
RE: mysql server hardware
If you ran into any problems it would probably be RAM. RAM is cheap so if you have trouble...just pop a couple of 512MB chips in it. ~KB -Original Message- From: Jeremy Zawodny [mailto:Jeremy@;Zawodny.com] Sent: Wednesday, November 13, 2002 11:12 AM To: Devore, Jacob Cc: '[EMAIL PROTECTED]' Subject: Re: mysql server hardware 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
Re: mysql server hardware
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
mysql server hardware
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. Thanks, jake - 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