Top "Table-locking" questions

MySQL 5.6 - table locks even when ALGORITHM=inplace is used

I'm running the following ALTER command on a MySQL 5.6 database on a large table with 60 million rows: ALTER TABLE `large_…

mysql table-locking
Locking a table with a select in Entity Framework

I need to do something like this select * from myTable with (xlock,holdlock) using Entity Framework. Is this possible? I've …

entity-framework transactionscope table-locking
How innodb tables are locked when ON INSERT trigger is processed?

I have two innodb tables: articles id | title | sum_votes ------------------------------ 1 | art 1 | 5 2 | art 2 | 8 3 | art 3 | 35 votes id | article_id | vote ------------------------------ 1 | 1 | 1 2 | 1 | 2 3 | 1 | 2 4 | 2 | 10 5 | 2 | …

mysql sql triggers innodb table-locking