Number of connection running within certain period of time? Is there any way to capture number of connections or processes which is running on the prod server each 10 mins of interval? And MySQL version is 5.1.47.
Something like this might do the trick, assuming your mysqld is listening on port 3306:

$ netstat -ant | grep ":3306" | grep ESTABLISHED | wc -l
50


You can put this in a script and execute every 10 minutes through cron.