On Fri, 2005-07-15 at 13:28 -0700, David Griffiths wrote:
>
David,
Thanks for your suggestions, i'll give them a try.
> There are other tuning choices (including the thread-pool-cache). The
> best resource is the page on innodb performance tuning, and it can be
> found here:
>
> http://dev
Tony,
Your my.cnf file is set up for MyISAM, not InnoDB. MySQL allows you to
allocate memory and resources to any and all storage engines. Yours is
set up to give lots of resources to MyISAM, and none to InnoDB.
Reducing MyISAM
key_buffer = 384M - this is way too much - I'd set to to 2-16 meg
Hi David,
On Fri, 2005-07-15 at 10:25 -0700, David Griffiths wrote:
> Tony,
>
> " - not sure what version you are using
4.1.11. Server is a duel xeon machine with 4gb or ram running mysql and
apache webserver and not much else.
You should have used
> my-innodb-heavy-4G.cnf as the starting p
Tony,
You said that you copied the my.cnf file from "huge.cnf" - not sure what
version you are using (I missed your original post), but the my-huge.cnf
in mysql 4.0.24 is for MyISAM. You should have used
my-innodb-heavy-4G.cnf as the starting point for an InnoDB system. The
my-huge.cnf alloc
Nicholas,
- Original Message -
From: ""Nicholas Elliott"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, July 11, 2003 6:04 PM
Subject: InnoDB Performance issues
> --=_NextPart_000_003B_01C3479C.77A1AB60
> Content-Type: text/plain;
> charset="iso-8859-1"
> Cont
Hi Nicholas,
How about storing the BLOBS outside of the DB and refering to them ?
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 12日 土曜日 00:06、Nicholas Elliott さんは書きました:
> Hey all,
>
> I've been experimenting with the best way to store a large (~100GB) of data
> for retrieval. Essentially, I'
ED]>
To: "Nicholas Elliott" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 11, 2003 11:29 AM
Subject: Re: InnoDB Performance issues
> In the last episode (Jul 11), Nicholas Elliott said:
> > I've been experimenting with the best way to store a l
In the last episode (Jul 11), Nicholas Elliott said:
> I've been experimenting with the best way to store a large (~100GB)
> of data for retrieval. Essentially, I'm storing 9 variables for
> approximately 1,000,000 locations a day for the last ten years. This
> can work out at around 4MB a variable
