Hello, I have looked at the two supplied links and still have some more questions
These errors I get about every 4 to 10 minutes. I get them from 3 different application servers. If I do this mysqld --debug=d,info,error,query,general,where:O,/tmp/mysqld.trace What kind of info can I expect to see ? In the mysql variables. In 5 days I have 11885 aborted_clients. I assume this is probably pretty high? Thanks for any more help Randy -----Original Message----- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 20, 2005 3:27 PM To: mysql@lists.mysql.com Subject: Re: looking for direction on how to debug this message See: http://dev.mysql.com/doc/mysql/en/communication-errors.html http://dev.mysql.com/doc/mysql/en/making-trace-files.html Randy Paries wrote: >Info: > >DB Server >Mysql 4.0.20 >Mandrakelinux release 10.1 (Official) for i586 - 2.6.8.1-12mdksmp > >Application Servers >Red Hat Linux release 9 >Tomcat 5.0.24 > >These application servers connect to the DB via Tomcat or by perl scripts > >In my data directory I have a file called millhouse.unitnet.com.err > >My main db is unitnet >Hello, >My log file is getting filled with these. How do i start debugging this? >Thanks >Randy >//-------------------------snip-----------------------------// >050122 20:28:00 Aborted connection 53561 to db: 'unitnet' user: 'paries' >host: `local.flanders' (Got an error reading communication packets) >050122 20:28:49 Aborted connection 53612 to db: 'unitnet' user: 'paries' >host: `local.krusty' (Got an error reading communication packets) >050122 20:29:20 Aborted connection 53671 to db: 'unitnet' user: 'paries' >host: `local.flanders' (Got an error reading communication packets) >050122 20:32:14 Aborted connection 53910 to db: 'unitnet' user: 'paries' >host: `local.flanders' (Got an error reading communication packets) >050122 20:34:47 Aborted connection 54111 to db: 'unitnet' user: 'paries' >host: `local.flanders' (Got an error reading communication packets) >050122 20:34:48 Aborted connection 54116 to db: 'unitnet' user: 'paries' >host: `local.flanders' (Got an error reading communication packets) >050122 20:35:11 Aborted connection 54142 to db: 'unitnet' user: 'paries' >host: `local.krusty' (Got an error reading communication packets) >050122 20:38:45 Aborted connection 54468 to db: 'unitnet' user: 'paries' >host: `local.flanders' (Got an error reading communication packets) >050122 20:39:46 Aborted connection 54572 to db: 'unitnet' user: 'paries' >host: `local.krusty' (Got an error reading communication packets) >050122 20:40:54 Aborted connection 54584 to db: 'unitnet' user: 'paries' >host: `local.flanders' (Got an error reading communication packets) >050122 20:42:09 Aborted connection 54794 to db: 'unitnet' user: 'paries' >host: `local.krusty' (Got an error reading communication packets) >050122 20:43:33 Aborted connection 54936 to db: 'unitnet' user: 'paries' >host: `local.krusty' (Got an error reading communication packets) >050122 20:44:40 Aborted connection 55004 to db: 'unitnet' user: 'paries' >host: `local.krusty' (Got an error reading communication packets) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
