It locks the table for both. regards anandkl
On 11/20/07, Thomas Raso <[EMAIL PROTECTED]> wrote: > > Hi all, > > just a simple question : > > Does the query ANALYZE position reads and/or writes locks ? > > I read these two pages but I didn't find the answer... > > http://www.mysql.com/news-and-events/newsletter/2003-04/a0000000155.html > http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html > > Thanks all >