I have a fairly small table WRT the data size. Its about 300M of
data. Right now it has about 6M rows.
The schema is pretty simple. It has one 64bit ID column. Basically
its for checking the existence of an object in our DB and is designed
to work very fast.
One the table was FIRST created I could do inserts very fast. Now
that its grown in size inserts are taking a LOT longer. Sometimes 60
seconds to 2-3 minutes.
I've migrated to using bulk inserts of 1k rows or more but in
production this might be a bit difficult.
Is there anyway I can tune MySQL to improve this operation?
Kevin
Kevin A. Burton, Location - San Francisco, CA
AIM/YIM - sfburtonator, Web - http://www.feedblog.org/
GPG fingerprint: 5FB2 F3E2 760E 70A8 6174 D393 E84D 8D04
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]