Archive for July, 2011

Facebook – Max concurrent connections, queries and transactions

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.

Irrelevant user base benchmark

I don’t know what is the exact point of CloudFlare posting this. “Fastest Growing Startups”? Personally I see some fails here.

The business models of all compared – is different. All products caters different crowd. It’s like I can try sell mango to someone that’s allergic to mangos… I’ll never make that sale.

I guess they failed to realize the number of (Inter)netizens within the last 10 years. Simple point here.

How many of those companies CloudFlare directly/indirectly utilized as a medium to promote their services? Almost all. Also, fans that does non-paid, free advertising.

 

Not bashing CloudFlare here. I’ve used their service. It’s great. I read almost all their Facebook postings (as I read this one from). But this one really threw me off…..

DNS problems

I guess I left lingering *dead* load balancers in DNS. Causing some problems with not displaying the site.

It’s fixed now. :)