maria-discuss team mailing list archive
Mailing list archive
Aria table with auto increment PK - no concurrent inserts?
Aria FAQ says: "Multiple concurrent inserters into the same table."
However, if I create a table with autoincrement PK, ENGINE=Aria
ROW_FORMAT=PAGE (tried also TRANSACTIONAL=1)
then there is no concurrency - only 1 thread is working, others are stuck
in "Waiting for table level lock".
I couldn't find the exact description of Aria engine behaviour in
docs/faq/discussions - is it the way it's supposed to be?