Take the 2-minute tour ×  Recently I migrated all my MySQL
database tables from MyISAM engine to InnoDB. I'm using the
DotCloud MySQL service as my server
(http://docs.dotcloud.com/services/mysql/).  After the
migration, everything went fine for the first two weeks, but for
a couple days I've been experiencing some problems.  At first,
all my queries would lock under an update or insert at certain
tables. With a SHOW PROCESSLIST; I could see that the locking
queries had the state of "freeing items". I started to research
and found this:  Why do MySQL threads often show "freeing items"
status when the query cache is disabled?  I've changed the
innodb_thread_concurrency to 32 as suggested, and that really
did help in order to keep the website running well, which means
that I'm not experiencing application locks any more.  The
problem is that inserts and updates are still slow, some of them
taking more than 60 seconds to happen and that is terrible. I'll
try to put my database under maintenance and optimize or r