# Slow one-row INSERTs

**URL:** <https://forums.percona.com/t/slow-one-row-inserts/381>\
**Category:** Other MySQL® Questions\
**Created:** [July 12, 2007, 12:20pm UTC](https://forums.percona.com/t/slow-one-row-inserts/381 "2007-07-12T12:20:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![aschwa](https://avatars.discourse-cdn.com/v4/letter/a/aeb1de/32.png) [@aschwa](https://forums.percona.com/u/aschwa)\
**Post date:** [July 12, 2007, 12:20pm UTC](https://forums.percona.com/t/slow-one-row-inserts/381/1 "2007-07-12T12:20:17Z")

</div>

I’ve started using the slow query log analyzer at:  
[http://www.mysqlperformanceblog.com/2006/09/06/slow-query-lo](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?

---

<div class="post-metadata">

**Author:** ![aschwa](https://avatars.discourse-cdn.com/v4/letter/a/aeb1de/32.png) [@aschwa](https://forums.percona.com/u/aschwa)\
**Post date:** [July 24, 2007, 9:50pm UTC](https://forums.percona.com/t/slow-one-row-inserts/381/2 "2007-07-24T21:50:31Z")

</div>

Any thoughts? Perhaps I should be using some other DBMS, which perhaps has worse average case performance, but better worst case performance?