Mark,
Your suggestion certainly sounds plausible. However, I have no control over the
connections with Zeos Database Objects. Even though I open the actual database
connection at the start of the program, it appears that each query forces a new
connect/disconnect. In fact, in perusing through the source code, the first operation
on an OPEN is, if ACTIVE then DISCONNECT.
I will contact the Zeos developers and see if they have a workaround for this.
Thanks,
Dan Cumpian
-------Original Message-------
From: Mark Matthews <[EMAIL PROTECTED]>
Sent: 04/03/03 12:02 PM
To: Dan Cumpian <[EMAIL PROTECTED]>
Subject: Re: Help with 4.0.12 on WinXP
>
> -----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Dan Cumpian wrote:
| Hello,
|
|
|
| I am having the following problem that I've been able to consistently
| replicate:
|
|
|
| I am using code written in Delphi with Zeos Database components and am
| having a problem with a query returning "server connection error". I am
| inserting a row into a table and then immediately selecting a row from a
| table . This error occurs whether I select out of the table I inserted
| the new row into or from any other table. After inserting 3700-3900
| rows, the select will be unable to connect. For at least 10-30 seconds,
| I cannot connect to MySQL, even with MySQL-Front (I get a "Can't connect
| to server" error). There are no errors being logged. After the 10-30
| seconds passes, I can resume the program and it happens again after
| 3700-3900 rows.
|
|
|
| This does not happen on Windows 2000, only Windows XP (both Home and
| Pro). All connection are through Localhost.
|
|
|
| My configuration file is:
|
|
|
| [mysqld]
|
| set-variable=key_buffer_size=18M
|
| set-variable=myisam_sort_buffer_size=8M
|
| set-variable = max_allowed_packet=16M
|
|
|
| Table type is MyISAM.
|
|
|
| Machine is a P4-2.2Ghz with SCSI hard disks.
|
|
|
| Can anyone please suggest what I might be able to do to resolve this
| issue?
My guess is that you are making a new connection every time you do an
operation. Windows XP has a paltry amount of TCP/IP ports that can be
used for outbound connections (around 4000, which should sound
'coincidental' to you, given that your failures happen between 3700 and
3900)...These ports are shared for _all_ outbound TCP/IP from your box,
and can take up to 4 minutes to 'clear' so they can be re-used.
You should consider only opening the MySQL connection _once_ in your
program...Otherwise you need to use a registry hack to change the number
of 'ephemeral' ports that Windows XP will use (search the mailing list,
or the myodbc mailing list for a pointer to that article).
-Mark
- --
MySQL 2003 Users Conference -> <a target=_blank
href="http://www.mysql.com/events/uc2003/";>http://www.mysql.com/events/uc2003/</a>
For technical support contracts, visit https://order.mysql.com/?ref=mmma
~ __ ___ ___ ____ __
~ / |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]>
~ / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
~ /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
~ <___/ <a target=_blank
href="http://www.mysql.com";>www.mysql.com</a>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - <a target=_blank
href="http://enigmail.mozdev.org";>http://enigmail.mozdev.org</a>
iD8DBQE+jGkHtvXNTca6JD8RAu3kAJ41j4ulfljw8150u66inBwKHFTvtwCfYc4G
7ROQnT1NjSPAHMeJgQ1ptpE=
=v7fv
-----END PGP SIGNATURE-----
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
