"howa" <com> wrote:
Regarding MyISAM there are three groups of statements:
1. SELECT
2. INSERT at end of table (append)
3. DELETE, UPDATE, INSERT not at end of table
At a given point in time and for a given table there can be multiple
statements from group 1 and up to one statement from group 2
*or* one statement from group 3.
In other words:
- reads are done concurrently
- all writes (also append) are serialized
- reads mix with append
The tion SQL thread is not different from any other client
thread in that respect.
XL
--
Axel Schwenke, Senior Software Developer, MySQL AB
Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/
Bookmarks