InnoDB ANALYZE and locks
This is a discussion on InnoDB ANALYZE and locks within the MySQL General forum forums, part of the MySQL category; --> Hi all, just a simple question : Does the query ANALYZE position reads and/or writes locks ? I read ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 07:02 AM
| ||||
| ||||
 InnoDB ANALYZE and locks 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...000000155.html http://dev.mysql.com/doc/refman/5.0/...trictions.html Thanks all      |
|
02-28-2008, 07:02 AM
| ||||
| ||||
| Re: InnoDB ANALYZE and locks It locks the table for both. regards anandkl On 11/20/07, Thomas Raso <thomas.raso@gmail.com> 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...000000155.html > http://dev.mysql.com/doc/refman/5.0/...trictions.html > > Thanks all > |
Linear Mode
