# Tables getting locked on one server but working fine on another server

**URL:** <https://forums.percona.com/t/tables-getting-locked-on-one-server-but-working-fine-on-another-server/915>\
**Category:** Other MySQL® Questions\
**Created:** [September 10, 2008, 7:51am UTC](https://forums.percona.com/t/tables-getting-locked-on-one-server-but-working-fine-on-another-server/915 "2008-09-10T07:51:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ratish81](https://avatars.discourse-cdn.com/v4/letter/r/df788c/32.png) [@ratish81](https://forums.percona.com/u/ratish81)\
**Post date:** [September 10, 2008, 7:51am UTC](https://forums.percona.com/t/tables-getting-locked-on-one-server-but-working-fine-on-another-server/915/1 "2008-09-10T07:51:55Z")

</div>

Hi All,

We have two servers: one is a test server and the other a production server. We have load of PERL modules running on both which uses Mysql tables. They are all MyISAM tables. The problem that we get (mentioned below) happens only on the test server (maybe because the hardware is not as good as the production) but I wanted to optimize the tables/queries so that all modules work perfect on both servers.

Now, one of our servers gets really slow because there are loads of queries running and the mysql database just gets locked because of many update queries running. I understand that MYISAM tables lock the entire table during the update operation. But my question is that how does it work perfect on the production server then? Or is it just a calamity waiting to happen on production too?

Apart from changing my tables to INNODB is there any other solution? Please do let me know

---

<div class="post-metadata">

**Author:** ![debug](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/debug/32/772_2.png) [@debug](https://forums.percona.com/u/debug)\
**Post date:** [September 11, 2008, 3:07am UTC](https://forums.percona.com/t/tables-getting-locked-on-one-server-but-working-fine-on-another-server/915/2 "2008-09-11T03:07:09Z")

</div>

Well, it’s probably because production server is faster and queries are taking less time, and you don’t see locks because of it.  
BTW, do you have any difference in mysql configs between production and test servers?