MySql calculate number of connections needed
- by Udi I
I am trying to figure my needs regarding web service hosting.
After trying Azure I have realized that the default MySql they provide (through a third party) limits the account to 4 connections. You can then upgrade the account to 15, 30 or 40 connections (which is quite expensive). Their 15 connections plan is descirbed as:
"Excellent choice for light test and staging apps that need a reliable
MySQL database".
I have 2 questions:
if my application is a web service which needs to preform ~120k Queries a day (Normal/BELL distribution) and each query is ~150ms(duration)/~400ms(fetch), how many connection do I need?
If instead of using cloud computing, I will choose a VPS, how many connections will I be able to handle on a 1GB 2 cores VPS?
Thank you!
