Answer the question
In order to leave comments, you need to log in
MySQL query execution order within one connection?
Hello!
A certain php-shellscript is running on the server, working as a daemon, which is waiting for users to connect for further work with them. This demon is launched by a single process and does not produce its own kind in any way. It turns out that an unlimited number of users can access this daemon.
This script maintains a permanent connection to the MySQL database, which is opened when the script is run from the shell.
Actually, the question itself is how the MySQL server will behave when N-th number of completely different requests arrive within the same connection? Will it execute them sequentially or in parallel, how will this affect the speed of processing user requests? Or all the same to adhere to the scheme: 1 user = 1 connection to a DB?
Thank you.
Answer the question
In order to leave comments, you need to log in
If the question is whether the server will be confused about what to answer to whom, then no, it will not.
In all other senses - at this level of understanding of the processes, you do not really need an answer to this question. Don't beat yourself up.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question