Handles of MySQL process on startup

[Morrandir]

This is a more general question, not a realley NWNX question, but perhaps you can help me out.

I'm running Wink23 Server Web Edition with SP2 and MySQL as a service.
Wenn starting the service, my mysqld-nt.exe process has more than 90.000 handles... right from the start.

Could this be the cause of some DB problems we seem to have?
And how can it be, that there are that much handles at startup?
_________________
German NWN1/2 Persistent World Hochwaldallianz

[Skywing]

Not too out of line for mysql, I think. I typically see 40-60K handles on my mysqld-nt instances. At least within the same order of magnitude.

[Morrandir]

That may be... but I don't have any application using the DB at startup.
Are the handles somehow cached?

I mean... I wouldn't be suprised if the handles start from 0 and increase to 100k... but 90k without any DB access?
_________________
German NWN1/2 Persistent World Hochwaldallianz

[Skywing]

I haven't dug into what handles it's opening or why. You might try poking at it with Process Explorer if you're truly curious.

I haven't seen evidence of a substantial handle leak, however, so I haven't seen fit to do a whlole lot of research into it.

[Morrandir]

So you don't think, that having that much handles could cause lag on NWN2 server?
_________________
German NWN1/2 Persistent World Hochwaldallianz

[Skywing]

Unlikely. Handle tables are per-process, and 50K entries isn't near enough to cause a problem. Handle lookups are a multi-tiered index scheme (somewhat like page tables) that's going to be fast for referencing/lookup operations regardless of how many handles you have open in a given handle table, anyway.

[Zebranky]

This is apparently by design for the InnoDB storage engine. If you recompile MySQL without InnoDB, it won't use those handles. They are "the event semaphores created for InnoDB wait arrays. There can be a maximum 10 000 threads inside InnoDB waiting in various 'wait arrays', and each slot in an array has an event semaphore." (http://osdir.com/ml/db.mysql.windows/2002-10/msg00001.html)
_________________
Win32 SVN builds: http://www.mercuric.net/nwn/nwnx/

<Fluffy-Kooshy> NWNx plugin is to this as nuclear warheads are to getting rid of fire ants.

<ThriWork> whenever I hear nwn extender, I think what does NWN need a penis extender for?