#!/bin/bash

AURORA_USERNAME=
AURORA_PASS=
MYSQL_HOST=

mycli --host=$MYSQL_HOST -u $AURORA_USERNAME --password=$AURORA_PASS --database=session -e "SHOW processlist" | awk '$2 == "tpt3_app" {print $1}' > /tmp/process_ids

while read id; do
    mycli --host=$MYSQL_HOST -u $AURORA_USERNAME --password=$AURORA_PASS --database=session -e "CALL mysql.rds_kill($id)"
done < /tmp/process_ids