0

Checking Mysql queries User had opened

Wednesday, November 7, 2007

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 Responses to "Checking Mysql queries User had opened"