max_connections and connection queuing

[Peter Bui]

Heya!

I'm trying to understand what does proxysql do when all available backend connections are used. 

For example, say I have a backend server with a max_connection of 1 to simplify the example. 

I create connections A, B, and C to proxysql. 

On connection A, I run "select sleep(100)" so that the backend connection is in use. 

On connection B, I run "select now()"

On Connection C, I run "select now()"

I see that B and C are waiting. Now a few questions:

* Is there a queue for B and C queries and is it ordered? i.e., if B runs before C, it should execute B and then C. 

* Does proxysql timeout either B or C queries if A runs too long? 

Cheers,

Peter