Re: Maximize mysql ini for 4gig big query win 2003 box

2005-04-28 Thread matt_lists
.com Subject: Re: Maximize mysql ini for 4gig big query win 2003 box I'm more concerned with mysql only using 1.5 gig, wouldnt it be faster to maximize memory usage? The only thing these box's do is mysql I do have slow queries, but they are big joins across all the big tables, and use

RE: Maximize mysql ini for 4gig big query win 2003 box

2005-04-28 Thread Mark Leith
s UK Limited http://www.cool-tools.co.uk -Original Message- From: matt_lists [mailto:[EMAIL PROTECTED] Sent: 28 April 2005 13:57 To: Gleb Paharenko Cc: mysql@lists.mysql.com Subject: Re: Maximize mysql ini for 4gig big query win 2003 box I'm more concerned with mysql only using 1.5

Re: Maximize mysql ini for 4gig big query win 2003 box

2005-04-28 Thread matt_lists
I'm more concerned with mysql only using 1.5 gig, wouldnt it be faster to maximize memory usage? The only thing these box's do is mysql I do have slow queries, but they are big joins across all the big tables, and users doing querys on tables without using a key, the contract requires dynamic

Re: Maximize mysql ini for 4gig big query win 2003 box

2005-04-28 Thread Gleb Paharenko
Hello. SHOW STATUS and a piece of SHOW PROCESSLIST with slow queries could give additional information, so the probability of the helpful answer grows. matt_lists <[EMAIL PROTECTED]> wrote: > Anybody have any suggested settings for our my.ini ? > > 4 gig box, running windows 2003 > >