Report a paste

Please put a quick comment for the admin.

If it looks like spam, the admin will mark it as spam so that the spam filter picks it up in the future.

If the paste contains something private or offensive, it'll probably just be deleted.

No title

#!/bin/bash

rm -f kill_sleeps.sql

## SELECT ID FROM information_schema.processlist WHERE Command='Sleep' AND TIME > 200;

echo "SELECT concat('KILL', ' ', q.ID, ';') FROM information_schema.processlist q WHERE q.Command='Sleep' AND q.Time > 60" | mysql > kill_sleeps.sql

sed -i '/concat/d' kill_sleeps.sql
echo $(md5sum kill_sleeps.sql ; wc -l kill_sleeps.sql)

mysql < kill_sleeps.sql