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