.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
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
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
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
>
>
Anybody have any suggested settings for our my.ini ?
4 gig box, running windows 2003
peak memory usage for mysql is 1.4 gig currently
using myisam files, lots of little index querys, and some very large
queries at night
615 tables, 88.3 gb of myd, 45.2 gb of myi, 33 of the tables/indexes
break
