<div>
You probably are using the default storage engine type MyISAM which tends to do a poor job with locking tables from other users. Turn your tables into InnoDB which ensures much better locking management (e.g. lock only rows being updated, don't lock entire table when doing a query on it, etc.)<br />
<br />
Say your table is called &quot;fubar&quot;, here is a simple command to turn it into InnoDB (assuming you have InnoDB configured for your MySQL server):<br />
<br />
&nbsp; alter table fubar engine=innodb
</div>


You probably are using the default storage engine type MyISAM which tends to do a poor job with locking tables from other users. Turn your tables into InnoDB which ensures much better locking management (e.g. lock only rows being updated, don't lock entire table when doing a query on it, etc.)

Say your table is called "fubar", here is a simple command to turn it into InnoDB (assuming you have InnoDB configured for your MySQL server):

  alter table fubar engine=innodb

<div>
Can you have mixed table types like MyISAM and InnoDB?<br />
The majority of my tables are MyISAM.
</div>


Can you have mixed table types like MyISAM and InnoDB?
The majority of my tables are MyISAM.

<div>
<div class="content wysiwyg-content">
For some reason all the time when on my processes send selects and updates to a mysql table I see a lot of &nbsp;inserts to the same table in the locked sate.<br />
<br />
That makes the initial selects and updates very slow like 40 seconds to a minute for every select or update.<br />
<br />
How can I fix this?
</div>
</div>


For some reason all the time when on my processes send selects and updates to a mysql table I see a lot of  inserts to the same table in the locked sate.

That makes the initial selects and updates very slow like 40 seconds to a minute for every select or update.

How can I fix this?

Lots of locked state mysql inserts - slow updates and selects

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.