How is the work with transactions on one connection to the DBMS for all users?

Question

MySQL

Hey!
I want to use one database connection for all connected clients to my application. But I'm not sure how transactions work in this situation.
If one client opens a transaction and hangs for a while, will other clients work within this open transaction? Those. Is the scope of a transaction bound to and delimited by a connection? I do not really understand how this could be solved at the level of the DBMS kernel.

Answer 1

Have you turned them on?
Transactions? https://habrahabr.ru/post/238119/
It will be blocked if you use them.
MySQL is a blocking server, not versioned, unlike PostgreSQL