title: How does connectionLimit work in node mysql?
body: <p>I quite don't understand how <code>connectionLimit</code> in <a href="https://github.com/mysqljs/mysql" rel="noreferrer">mysql</a> module works.</p>
  <p>I have created a connectionPool in following way:</p>
  <pre><code>  var connPool = mysql.createPool({
          host: config.get('database.host'),
          user: config.get('database.user'),
          password: config.get('database.password'),
          database: config.get('database.dbname'),
          connectionLimit: 5
    });
  </code></pre>
  <p>Now, what does limit 5 do here?</p>
  <p>Here's what I think:</p>
  <p>Suppose there are 5 users using my REST API for selecting some data from a table. Now in my API, I get a connection from <strong>pool</strong>, do stuff and then <strong>release</strong> the connection.</p>
  <p>So now, suppose there are <strong>12 users</strong> who send request to this API concurrently. So first <strong>5</strong> of them should get access to the data and other <strong>7</strong> will get error / no response. They will have to request again to get the data.</p>
  <p>Is this like so or something else?</p>