a@u:~$ ~/mysql/enterprise/agent2.2.1.1717/etc/init.d/mysql-monitor-agent restart Shutting down MySQL Enterprise agent service... ... * Starting MySQL Enterprise agent service... * a@u:~$ top -b -n 1 |grep monitor-a 2878 a 20 0 49372 1112 396 S 0.0 0.1 0:00.00 mysql-monitor-a 2879 a 20 0 116m 6280 2864 S 0.0 0.3 0:00.40 mysql-monitor-a a@u:~$ mysql -h127.0.0.1 -P6446 -uservice_manager -p1 test --max_allowed_packet=100000000 < ~/o.sql & [1] 2905 a@u:~$ top -b -n 1 |grep monitor-a 2879 a 20 0 335m 200m 3044 R 95.7 10.0 0:02.02 mysql-monitor-a 2878 a 20 0 49372 1112 396 S 0.0 0.1 0:00.00 mysql-monitor-a a@u:~$ top -b -n 1 |grep monitor-a 2879 a 20 0 1430m 1.2g 3044 R 97.1 58.9 0:19.88 mysql-monitor-a 2878 a 20 0 49372 1112 396 S 0.0 0.1 0:00.00 mysql-monitor-a a@u:~$ top -b -n 1 |grep monitor-a 2879 a 20 0 1427m 1.2g 3044 R 89.0 58.8 0:34.65 mysql-monitor-a 2878 a 20 0 49372 1112 396 S 0.0 0.1 0:00.00 mysql-monitor-a a@u:~$ ERROR 1153 (08S01) at line 2: Got a packet bigger than 'max_allowed_packet' bytes [1]+ Exit 1 mysql -h127.0.0.1 -P6446 -uservice_manager -p1 test --max_allowed_packet=100000000 < ~/o.sql a@u:~$ top -b -n 1 |grep monitor-a 2878 a 20 0 49372 1112 396 S 0.0 0.1 0:00.00 mysql-monitor-a 2879 a 20 0 1395m 1.1g 3044 S 0.0 58.0 0:51.41 mysql-monitor-a a@u:~$ ~/mysql/enterprise/agent2.2.1.1717/etc/init.d/mysql-monitor-agent restart Shutting down MySQL Enterprise agent service... .. * Starting MySQL Enterprise agent service... * a@u:~$ mysql -h127.0.0.1 -P6446 -uservice_manager -p1 test --max_allowed_packet=100000000 -e "set global max_allowed_packet=1024*1024*1024" a@u:~$ mysql -h127.0.0.1 -P6446 -uservice_manager -p1 test --max_allowed_packet=100000000 < ~/o.sql & [1] 3019 a@u:~$ top -b -n 1 |grep monitor-a 3002 a 20 0 765m 569m 3044 R 92.8 28.3 0:05.37 mysql-monitor-a 3001 a 20 0 49372 1108 396 S 0.0 0.1 0:00.00 mysql-monitor-a a@u:~$ top -b -n 1 |grep monitor-a 3002 a 20 0 1432m 1.2g 3048 R 93.6 59.0 0:17.86 mysql-monitor-a 3001 a 20 0 49372 1108 396 S 0.0 0.1 0:00.00 mysql-monitor-a a@u:~$ top -b -n 1 |grep monitor-a 3001 a 20 0 49372 956 244 S 0.0 0.0 0:00.00 mysql-monitor-a 3002 a 20 0 1427m 1.2g 1700 S 0.0 58.9 0:52.33 mysql-monitor-a [1]+ Done mysql -h127.0.0.1 -P6446 -uservice_manager -p1 test --max_allowed_packet=100000000 < ~/o.sql a@u:~$ ls -la o.sql -rw-r--r-- 1 a a 21747175 2010-05-28 13:31 o.sql a@u:~$ vim test.sh a@u:~$ ./test.sh a@u:~$ ls -la o.sql -rw-r--r-- 1 a a 8284687 2010-06-07 18:19 o.sql a@u:~$ ~/mysql/enterprise/agent2.2.1.1717/etc/init.d/mysql-monitor-agent restart Shutting down MySQL Enterprise agent service... ..... * Starting MySQL Enterprise agent service... * a@u:~$ top -b -n 1 |grep monitor-a 3183 a 20 0 49372 1108 396 S 0.0 0.1 0:00.01 mysql-monitor-a 3184 a 20 0 116m 5656 2844 S 0.0 0.3 0:00.14 mysql-monitor-a a@u:~$ mysql -h127.0.0.1 -P6446 -uservice_manager -p1 test --max_allowed_packet=100000000 < ~/o.sql & [1] 3202 a@u:~$ top -b -n 1 |grep monitor-a 3184 a 20 0 448m 323m 3044 R 97.4 16.1 0:03.05 mysql-monitor-a 3183 a 20 0 49372 1108 396 S 0.0 0.1 0:00.01 mysql-monitor-a a@u:~$ top -b -n 1 |grep monitor-a 3184 a 20 0 636m 457m 3044 R 98.0 22.8 0:05.95 mysql-monitor-a 3183 a 20 0 49372 1108 396 S 0.0 0.1 0:00.01 mysql-monitor-a a@u:~$ top -b -n 1 |grep monitor-a 3183 a 20 0 49372 1108 396 S 0.0 0.1 0:00.01 mysql-monitor-a 3184 a 20 0 625m 445m 3044 S 0.0 22.2 0:19.99 mysql-monitor-a [1]+ Done mysql -h127.0.0.1 -P6446 -uservice_manager -p1 test --max_allowed_packet=100000000 < ~/o.sql a@u:~$ ~/mysql/enterprise/agent2.2.1.1717/etc/init.d/mysql-monitor-agent restart Shutting down MySQL Enterprise agent service... ... * Starting MySQL Enterprise agent service... * a@u:~$ vim test.sh a@u:~$ ./test.sh a@u:~$ ls -lha o.sql -rw-r--r-- 1 a a 55M 2010-06-07 19:17 o.sql a@u:~$ top -b -n 1 |grep monitor-a 3772 a 20 0 49372 1112 396 S 0.0 0.1 0:00.01 mysql-monitor-a 3773 a 20 0 116m 6276 2864 S 0.0 0.3 0:00.34 mysql-monitor-a a@u:~$ mysql -h127.0.0.1 -P6446 -uservice_manager -p1 test --max_allowed_packet=100000000 < ~/o.sql & [1] 3820 a@u:~$ top -b -n 1 |grep monitor-a 3773 a 20 0 301m 94m 1960 R 43.8 4.7 0:04.15 mysql-monitor-a 3772 a 20 0 49372 196 164 S 0.0 0.0 0:00.01 mysql-monitor-a a@u:~$ top -b -n 1 |grep monitor-a 3773 a 20 0 655m 429m 1960 R 97.7 21.4 0:07.41 mysql-monitor-a 3772 a 20 0 49372 196 164 S 0.0 0.0 0:00.01 mysql-monitor-a a@u:~$ top -b -n 1 |grep monitor-a 3773 a 20 0 884m 649m 1960 R 91.6 32.3 0:09.24 mysql-monitor-a 3772 a 20 0 49372 196 164 S 0.0 0.0 0:00.01 mysql-monitor-a a@u:~$ top -b -n 1 |grep monitor-a 3773 a 20 0 1348m 1.1g 1960 R 99.1 55.5 0:13.05 mysql-monitor-a 3772 a 20 0 49372 196 164 S 0.0 0.0 0:00.01 mysql-monitor-a a@u:~$ top -b -n 1 |grep monitor-a 3773 a 20 0 1814m 1.5g 1416 D 36.1 77.1 0:17.40 mysql-monitor-a 3772 a 20 0 49372 188 156 S 0.0 0.0 0:00.01 mysql-monitor-a a@u:~$ top -b -n 1 |grep monitor-a 3773 a 20 0 1850m 1.6g 1488 R 13.7 79.0 0:18.03 mysql-monitor-a 3772 a 20 0 49372 188 156 S 0.0 0.0 0:00.01 mysql-monitor-a a@u:~$ top -b -n 1 |grep monitor-a 3773 a 20 0 2018m 1.7g 1256 R 42.7 84.4 0:20.28 mysql-monitor-a 3772 a 20 0 49372 184 156 S 0.0 0.0 0:00.01 mysql-monitor-a a@u:~$ top -b -n 1 |grep monitor-a 100607 19:21:20 mysqld_safe Number of processes running now: 0 3773 a 20 0 2115m 1.7g 792 R 24.3 84.7 0:21.30 mysql-monitor-a 3772 a 20 0 49372 64 36 S 0.0 0.0 0:00.01 mysql-monitor-a a@u:~$ 100607 19:21:20 mysqld_safe mysqld restarted ERROR 2013 (HY000) at line 2: Lost connection to MySQL server during query a@u:~$ vim test.sh a@u:~$ ./test.sh a@u:~$ ls -lha o.sql -rw-r--r-- 1 a a 3,0M 2010-06-07 19:50 o.sql a@u:~$ mysql -h127.0.0.1 -P6446 -uservice_manager -p1 test --max_allowed_packet=100000000 < ~/o.sql & [1] 4034 a@u:~$ ls -lha o.sql -rw-r--r-- 1 a a 3,0M 2010-06-07 19:50 o.sql a@u:~$ top -b -n 1 |grep monitor-a 4012 a 20 0 356m 173m 3040 R 95.9 8.6 0:06.57 mysql-monitor-a 3963 a 20 0 49372 784 548 S 0.0 0.0 0:00.01 mysql-monitor-a a@u:~$ ERROR 1153 (08S01) at line 2: Got a packet bigger than 'max_allowed_packet' bytes top -b mysql -h127.0.0.1 -P6446 -uservice_manager -p1 test --max_allowed_packet=100000000 -e "set global max_allowed_packet=1024*1024*1024" [1]+ Exit 1 mysql -h127.0.0.1 -P6446 -uservice_manager -p1 test --max_allowed_packet=100000000 < ~/o.sql a@u:~$ ~/mysql/enterprise/agent2.2.1.1717/etc/init.d/mysql-monitor-agent restart Shutting down MySQL Enterprise agent service... .. * Starting MySQL Enterprise agent service... * a@u:~$ mysql -h127.0.0.1 -P6446 -uservice_manager -p1 test --max_allowed_packet=100000000 < ~/o.sql & [1] 4115 a@u:~$ top -b -n 1 |grep monitor-a 4099 a 20 0 356m 173m 3044 R 87.8 8.6 0:03.97 mysql-monitor-a 4098 a 20 0 49372 1112 396 S 0.0 0.1 0:00.00 mysql-monitor-a a@u:~$ top -b -n 1 |grep monitor-a 4099 a 20 0 356m 173m 3044 R 85.8 8.6 0:06.52 mysql-monitor-a 4098 a 20 0 49372 1112 396 S 0.0 0.1 0:00.00 mysql-monitor-a a@u:~$ top -b -n 1 |grep monitor-a 4099 a 20 0 352m 170m 3044 R 5.6 8.5 0:07.74 mysql-monitor-a 4098 a 20 0 49372 1112 396 S 0.0 0.1 0:00.00 mysql-monitor-a [1]+ Done mysql -h127.0.0.1 -P6446 -uservice_manager -p1 test --max_allowed_packet=100000000 < ~/o.sql a@u:~$ uname -a Linux u 2.6.31-21-generic #59-Ubuntu SMP Wed Mar 24 07:28:27 UTC 2010 x86_64 GNU/Linux