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
Hi,
A few days ago i posted a quaestion about performace, I now have a
little more info, hopefully someone can help.
I have a table, tblShoppingCart with 3 fields,
cartUid (int 11 auto increment)
userUid (int 11, indexed)
strCartHash (varchar 32)
The table is innodb
Nomally my server load i
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: t
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
Hey all,
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 a day - but
not all variables are always presen
10 matches
Mail list logo
