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:gleb.paharenko@stripped]
Sent: Tuesday, September 20, 2005 3:27 PM
To: mysql@stripped
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
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ 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/mysql?unsub=1
