why sql queries take time to execute ??

[systemali]

Thank you so very much for the clarification Scott

Well in that case, I have gone ahead and come up with a refined my script further, and this will run every 30 seconds as i have used the “sleep 30” in it.

#!/bin/bash
while true
do
count=netstat -an | grep :3306 | wc -l;
if [ $count -gt 300 ]; then
echo “” >> /home/output
echo date >> /home/output
mysql -uroot -pActualPassword -e"show engine innodb status \G" >> /home/output
fi
sleep 30
done

exit 0

I have executed this script using "nohup ./count.sh &" and now it is running at the moment even if i exit my session.

Comments would help me further …

Pheww…i guess my first script

Thank you for your time!!!