MySQLd-nt (v4.0.14) is eating up all the available CPU resources on a Windows 2000 server (dual 933 Pentium, 1GB RAM), with a maximum of 40 users so far. I have tried each combination of the default configuration files, and each variety of the executable (nt, max-nt etc.), and it's always the same. The webpage to access the database is written is ASP, and all connections are closed when finished with before the page is finished. Has anyone any ideas why it shoots up to the top like this?
Many thanks Gary