root@cumin1001:~/software/dbtools$ ./section m5 | while read host; do mysql.py -h $host -e "SELECT @@hostname; SHOW GLOBAL VARIABLES like 'max_allowed_packet'"; done
@@hostname
db2078
Variable_name Value
max_allowed_packet 67108864
@@hostname
db1117
Variable_name Value
max_allowed_packet 67108864
@@hostname
db2135
Variable_name Value
max_allowed_packet 67108864
@@hostname
db1128
Variable_name Value
max_allowed_packet 67108864
root@cumin1001:~/software/dbtools$ ./section m3 | while read host; do mysql.py -h $host -e "SELECT @@hostname; SHOW GLOBAL VARIABLES like 'max_allowed_packet'"; done
@@hostname
db2078
Variable_name Value
max_allowed_packet 33554432
@@hostname
db1117
Variable_name Value
max_allowed_packet 33554432
@@hostname
db2134
Variable_name Value
max_allowed_packet 33554432
@@hostname
db1132
Variable_name Value
max_allowed_packet 33554432
root@cumin1001:~/software/dbtools$ ./section m2 | while read host; do mysql.py -h $host -e "SELECT @@hostname; SHOW GLOBAL VARIABLES like 'max_allowed_packet'"; done
@@hostname
db2078
Variable_name Value
max_allowed_packet 67108864
@@hostname
db1117
Variable_name Value
max_allowed_packet 67108864
@@hostname
db2133
Variable_name Value
max_allowed_packet 67108864
@@hostname
db1107
Variable_name Value
max_allowed_packet 67108864
root@cumin1001:~/software/dbtools$ ./section m1 | while read host; do mysql.py -h $host -e "SELECT @@hostname; SHOW GLOBAL VARIABLES like 'max_allowed_packet'"; done