----- Original Message ----- From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Jeff Kilbride" <[EMAIL PROTECTED]> Cc: "Lopez David E-r9374c" <[EMAIL PROTECTED]>; "'DeepBlue'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, March 28, 2003 10:05 PM Subject: Re: Memory Leak
> On Fri, Mar 28, 2003 at 10:46:52AM -0800, Jeff Kilbride wrote: > > I've heard some bad things about turning off swap on Linux. I think it was > > on Jeremy Z.'s Blogger page. If he sees this maybe he can comment. > > It really depends on the kernel too. Newer (2.4.19+) kernel are much > better than those after 2.4.9. > > The great VM swap was a bad, bad idea. > > > I agree with David, though, in that your key_buffer size is way too > > low. > > Did he ever say how large his indexes are? If not, how can you be > sure of that? I can't be, other than making inferences from his original posting. He's trying to support 1000 connections on a box with 512MB of RAM and only giving 32MB to his key_buffer. If I was having problems in that situation, the key_buffer would be the first thing I would tune -- unless I had a *tiny* database. --jeff > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 4.0.8: up 53 days, processed 1,833,401,792 queries (394/sec. avg) > > -- > 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]
