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:
http://dev.mysql.com/doc/refman/6.0/en/se-maria-concurrency.html

+++++
When using transactional tables, Maria supports a single writer and 
multiple readers. The single writer supports both 
<http://dev.mysql.com/doc/refman/6.0/en/insert.html>INSERT and 
<http://dev.mysql.com/doc/refman/6.0/en/update.html>UPDATE operations.

SELECT

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?

Mike 

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