Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » Slow one-row INSERTs
Slow one-row INSERTs [message #1533] Thu, 12 July 2007 13:50 Go to previous 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?
Report message to a moderator
[Message index]

Read Message
Read Message
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:

  

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

Current Time: Fri Jul 10 01:45:38 EDT 2009

Total time taken to generate the page: 0.03897 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.