Hi.
On Thu, Feb 01, 2001 at 08:18:45PM +0200, [EMAIL PROTECTED] wrote:
> Would you please offer me something please ?
>
> > From: [EMAIL PROTECTED]
> > To: [EMAIL PROTECTED]
> > Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2
> (10055))
> >
> >
> > Description:
> > I am connecting from Visual Basic 6 to Mysql via
> > ODBC DSN. When i made 94 sleeped connection after 94 can't connect to a
> > server. It says : [TCX][MYODBC]Can't Connect to Mysql Server on
> 192.9.200.2
> > (10055)
> Is it fault of myodbc or mysql server?
> > Is it normal. If there a maximum connection limit for process ?
No. Your process is only limited by your OS. E.g. Linux defaults to a
limit of 256 sockets per process. I don't know about Windows.
> > I think it is abnormal cause everyone is talking about
> > 10.000 Web Hit.
Sorry? You can handle 10.000 web hits with only one connection.
> Is it cause from sleeped process list ?
Quite probably. Why do you need so much sleeping processes? Maybe
there is a misconception about the need of them?
> > I increased maximum connection to 200 but it not works. I think
> > it is not related with maximum connection. It is related with
> > maximum process number.
Why do you get so much processes? Do you really get so much hits? If
so, maybe someone else can help (I have no clue about tuning Windows
systems).
> > How-To-Repeat:
> > Run this code on Microsoft Visual Basic 6 ENT Edition.
> >
> > For i = 1 To 200
> > Set Temp_Bag(i) = New ADODB.Connection
> > Temp_Bag(i).Open "DSN=Avukatpro;UID=avukatpro;PWD=avukatpro"
> > Next i
> > It hangs 94 on Winnt. It hangs 60 on Win 95. It hangs 50 on Win98 SE.
Well, do you have a production situation that hits the wall? If not, I
wouldn't care about it. One of my servers delivers about 5.000.000
queries (300.000 web hits) a day with only 10-20 concurrent
connections. (Not, that there is no need for hundreds of connections
in some applications, but most time you don't need so much).
[...]
> > Release: mysql-3.23.26-beta
> >
> > Exectutable: mysqld-nt and mysqld-opt
> > Environment: PIII 700 MHZ Intel,256 MB RAM with WinNT4 ,
> > Same Problem on PIII MHZ Intel with 128 MB Ram
> > System: WinNT4 with Service Pack 6a, Internet Explorer 5
> > Same problem on Windows 95 Osr 2
> > Same Problem on Windows 98 SE
[...]
Bye,
Benjamin.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
