Hi!

sangprabv wrote:
> Hi,
> Is that true that MySQL lock table on each query? Does it means will
> cause slow speed? Then how to avoid table lock and speed up MySQL? TIA.

You need to read up about the different table handlers available.

They have different properties, including the locking behavior.

Check the manual for the version you are using.


Jörg

-- 
Joerg Bruehe,  MySQL Build Team,   joerg.bru...@sun.com
Sun Microsystems GmbH,   Sonnenallee 1,   D-85551 Kirchheim-Heimstetten
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering     Muenchen: HRB161028


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

  • Table Lock sangprabv
    • Re: Table Lock Joerg Bruehe

Reply via email to