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 allocates way to much memory to the MyISAM engine. All the
innodb stuff is commented out.
If you want help, you'll need to post your my.cnf file, the full table
definition (try SHOW CREATE TABLE tblSoppingCart; and pasting the
results in here).
You'll need to also post the queries that are hitting the database while
you're having these issues.
David
tony wrote:
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 is below 0.1 and everythings fine, I have a
process that runs occasionally that pushes the load up to 1.5, when this
happens inserts into the table seem to get blocked, ie taking up to 20
seconds, as soon as the load drops the inserts are fine again.
Interestingly, if I convert the table to myisam I don't get this
problem. However I really want to keep the table innodb as I use it in
transactions latter.
My my.cnf file is coppied from the default huge.cnf file, i have duel
xeons with 4gb of ram and i'm running mysql 4.1.1 on red hat linux.
Any pointers on where i can look further appreciated.
Tony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
