MySQL Performance: MySQL => Slow one-row INSERTs

Members

Help

Home

Home » Performance » MySQL » Slow one-row INSERTs

Show: Today's Messages :: Show Polls :: Message Navigator

Slow one-row INSERTs [message #1533]

Thu, 12 July 2007 13:50

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?

Report message to a moderator

Re: Slow one-row INSERTs [message #1550 is a reply to message #1533 ]

Tue, 24 July 2007 23:20

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?

Report message to a moderator

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:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

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 ::.