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:
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
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
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 point
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
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
Content
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
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 a
[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 large (~100GB)
of data for retrieval. Essentially, I'm storing 9 variables
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:06Nicholas Elliott :
Hey all,
I've been experimenting with the best way to store a large (~100GB) of data
for retrieval. Essentially, I'm storing 9
10 matches
Mail list logo
