Aborted clients - Got an error reading communication packets

[Database Administrator]

Hello,

I get pages of error logs with this message -
"Got an error reading communication packets". And the aborted clients
are easily in hundreds.

Here is my set of configurations:
I am running Microsoft .Net 2.0 on Windows 2003 Server using IIS 6.0.
I am using Mysql 5.0 with Mysql/.Net Connector 1.0.

Some of the settings on my.ini -
Connection timeout - 180
Wait timeout - 360
Max packet size - 10 M
Max connections - 5000 (pretty high, but set to be on a safer side)

When a perform a netstat -ao - I have lot many sockets open with
TIME_WAIT status. On the MySql Command client - the Aborted clients
average around 100's

The connection string from ,Net application has pooling=false with no
help.

The webserver does not have a heavy load and has less than 5 users at
any point in time.

On the registry settings, I have the max ports > 60000 and the
time_wait setting changed to 30.

My application is opens a connection, performs a query and closes the
connection and this is the fashion followed for all DB operations.

Been hunting around for a solution and it has been driving me crazy.
Any suggestions will be highly appreciated.

Thanks,
Narmatha

[Database Administrator]

On Jun 26, 8:43 pm, narmathab...@gmail.com wrote:
> .....
> Here is my set of configurations:
> I am running Microsoft .Net 2.0 on Windows 2003 Server using IIS 6.0.
> I am using Mysql 5.0 with Mysql/.Net Connector 1.0.
>
> .....
I think that you can get more quickly and exact answer in MySQL forum
than in these general comp.database forum.

comp.databases.mysql
http://groups.google.com/group/comp....nk=gschg&hl=en