Hello Scott,
I think i have finally done it
Pheww…
Since cron does not support seconds i used another command called “sleep” and using this sleep i called my script every 30 seconds to check the number of concurrent connections, Once the connections match the condition the “show engine innodb status\G” is executed.
To get my previous script working, I had to write another one called “every-30seconds.sh”
This in turn will call my count.sh.
To get this every-30seconds.sh running i have used the “nohup” command like this :- nohup ./every-30seconds.sh &
I think i have manged to do it, But i am sure this can still be done in a much efficient way.
Please let me know if you know of any ?
Thank you so very much.