List:General Discussion« Previous MessageNext Message »
From:mos Date:May 22 2009 2:32pm
Subject:Question about Maria readers/writers
View as plain text  
 From the MySQL v6 manual:

When using transactional tables, Maria supports a single writer and 
multiple readers. The single writer supports both 
<>INSERT and 
<>UPDATE operations.


All issued SELECT's are running concurrently. While a SELECT is running, 
all writers (INSERT, DELETE, UPDATE) are blocked from using any of the used 
tables (ie, they wait for the table to be free before continuing).

If it does support a single writer and multiple readers, why are the 
writers blocked when a Select is running? Shouldn't a single writer be able 
to run with concurrent Selects?


Question about Maria readers/writersmos22 May
  • RE: Question about Maria readers/writersMartin Gainty22 May