You can run the following to obatin how many mysql queries a user has open:
mysqladmin pr | awk -F\| {'print $3'} | sort -nk1 | awk -F_ {'print $1'} |uniq -c |sort
Run the following to check the database with the most queries:
mysqladmin pr | awk -F\| {'print $5'} | sort -nk1 |uniq -c |sort
0
Checking Mysql queries User had opened
Checking Mysql queries User had opened
Wednesday, November 7, 2007
Posted in: mysql | 0 Comments | Email This
Subscribe to:
Post Comments (RSS)
0 Responses to "Checking Mysql queries User had opened"
Post a Comment