Hi.
On Tue 2002-06-18 at 10:28:41 -0700, [EMAIL PROTECTED] wrote:
> Group,
>
> I have a system running on windoze 2000 with apache and perl that was
> running just great until I mades some
> changes to the sql and a join of two tables. Now I get a bunch of disk
> activity and my pages take forever to load
> I shut down the browser and still the activity - memory usage goes through
> the roof with ossilation between perl and
> mysql in task manager.
The MySQL server will only notice that you stopped the client, when it
is ready to send some results back. Depending on the query this may
take a while.
You should use your preferred admin tool (mysqladmin if nothing else),
and as database root look at the processlist and kill the query in
question.
> I see that there are several servers that can be run. Should I be running
> one of other servers?
No. As long as you have to ask, you have no need for the other
servers. ;-)
> I am currently running mysqld-nt but there is mysqld-max-nt, mysqld-max????
mysqld-max* has some additional features compiled in by default
(e.g. InnoDB table type). This has nothing to do with the problem you
observed. The *-nt version are for the server version of Windows,
including Windows 2000, so you are using the correct binary.
Bye,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
