why sql queries take time to execute ??

[systemali]

Hello Scott,

I have tried my best to write a bash script that will count the number of concurrent connections and if it is higher than 300 it should execute the said command.

Can you please look into this script and comment ?

#!/bin/bash
count=netstat -an | grep :3306 | wc -l;
if [ $count -gt 300 ]; then
mysql -uroot -pActualPassword -e"show engine innodb status \G" > /home/output
else
echo “count is less than 300”;
fi

Since cron does not support executing scheduled jobs in seconds, I have set the cron to execute this script every minute.

I would appreciate if you could let me know how do i execute it every 30 seconds ?

Thank you a ton