Home » Performance » MySQL » Slow one-row INSERTs
Slow one-row INSERTs [message #1533] Thu, 12 July 2007 13:50 Go to next message
aschwa  is currently offline aschwa
Messages: 2
Registered: July 2007
Junior Member
I've started using the slow query log analyzer at:
http://www.mysqlperformanceblog.com/2006/09/06/slow-query-lo g-analyzes-tools/

It seems that a fair number of slow queries are one-row INSERTs into InnoDB tables. By slow, I mean that they take 100-200 milliseconds.

I already have innodb_flush_log_at_trx_commit set to 2.

In some of the cases, there is one UNIQUE index in the table in question (in addition to other INDEXes), but I don't think this should matter, unless the index is being pulled from disk.

Any thoughts on where I can look to bring these times down?
Re: Slow one-row INSERTs [message #1550 is a reply to message #1533 ] Tue, 24 July 2007 23:20 Go to previous message
aschwa  is currently offline aschwa
Messages: 2
Registered: July 2007
Junior Member
Any thoughts? Perhaps I should be using some other DBMS, which perhaps has worse average case performance, but better worst case performance?
Previous Topic:Is there a better way to page data than using LIMIT ?
Next Topic:Script to analyze all entries in a table and suggest optimal column data types.
Goto Forum:
  



Current Time: Thu Jan 8 21:04:06 EST 2009

Total time taken to generate the page: 0.03153 seconds
.:: Contact :: Home :: MySQL Support by Percona.com ::.

Powered by: FUDforum 2.7.5.
Copyright ©2001-2006 FUD Forum Bulletin Board Software

MySQL Performance | Forum authority Badge