HELP!!! major situation with mysql on windows 2000
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. I see that there are several servers that can be run. Should I be running one of other servers? I am currently running mysqld-nt but there is mysqld-max-nt, mysqld-max Not sure how to troubleshoot this. Thanks. - 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
Re: HELP!!! major situation with mysql on windows 2000
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
RE: HELP!!! major situation with mysql on windows 2000
Thanks to all - another coder showed me the error of my ways :) I had a join without a where clause - a big no-no. I had to restart the server and repair my code and now I am back to normal. Thanks to all. -Original Message- From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 11:26 AM To: Norris, Joseph Cc: Mysql_List (E-mail) Subject: Re: HELP!!! major situation with mysql on windows 2000 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
RE: HELP!!! major situation with mysql on windows 2000
The port of Cartesia does ship a lot of product. ;-) -Original Message- From: Norris, Joseph [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 1:02 PM To: 'Benjamin Pflugmann'; Norris, Joseph Cc: Mysql_List (E-mail) Subject: RE: HELP!!! major situation with mysql on windows 2000 Thanks to all - another coder showed me the error of my ways :) I had a join without a where clause - a big no-no. I had to restart the server and repair my code and now I am back to normal. Thanks to all. - 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
