Tons of handles at startup

------_=_NextPart_001_01C79E29.F0F915EC
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I recently noticed that MySQL 5.0.30 starts up with over 50,000 win32
handles when it starts up on several machines in my organization, most
of which are Event objects. MySQL 5.0.27 (on my personal machine)
starts up with only about 4,000 handles. A colleague of mine recently
installed 5.0.41 on his machine, and that starts up with about 40,000
handles.

=20

I presume that something fundamental changed between 5.0.27 and 5.0.30
to cause this. I noticed this in the first place because TaskInfo on one
of our servers complained that apps on the system were using over
100,000 handles in total. One of the causes was a handle leak in some
of our own software, which I fixed. But the other culprit was MySQL.

=20

Has anyone else seen this? Was this intentional, or is this a bug in
newer versions of MySQL? We bundle MySQL with our product, so if our
customers notice this, what should I tell them?

=20

Thanks for any info.

=20

-Sandeep


------_=_NextPart_001_01C79E29.F0F915EC--

Re: Tons of handles at startup

wow. even a few thousand handles is a lot. -- Jan

On Thu, 24 May 2007 10:35:37 -0700, "Sandeep Tamhankar"
said:
> I recently noticed that MySQL 5.0.30 starts up with over 50,000 win32
> handles when it starts up on several machines in my organization, most
> of which are Event objects. MySQL 5.0.27 (on my personal machine)
> starts up with only about 4,000 handles. A colleague of mine recently
> installed 5.0.41 on his machine, and that starts up with about 40,000
> handles.
>
>
>
> I presume that something fundamental changed between 5.0.27 and 5.0.30
> to cause this. I noticed this in the first place because TaskInfo on one
> of our servers complained that apps on the system were using over
> 100,000 handles in total. One of the causes was a handle leak in some
> of our own software, which I fixed. But the other culprit was MySQL.
>
>
>
> Has anyone else seen this? Was this intentional, or is this a bug in
> newer versions of MySQL? We bundle MySQL with our product, so if our
> customers notice this, what should I tell them?
>
>
>
> Thanks for any info.
>
>
>
> -Sandeep
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org