If you dealt with MySQL at an intermediate or advanced level, you know about max_user_connections variable. Where it limits concurrent connections per account. However, I was surprised today to find out that MySQL (enterprise-level DB) doesn’t have a variable to limit the number of transactions per account – until after I read this Facebook Engineer post.
The patch adds the columns max_concurrent_queries and max_concurrent_transactions to the mysql.user table. The GRANT command also supports with max_concurrent_transactions X and with max_concurrent_queries X.
Though I probably never would have the need to use this variable. However, it is nice to know it’s there. I hope the patches Facebook implemented makes its way into the official MySQL stream.