RE: How to kill MySQL process ? - Rodrigo Haces - com.mysql.lists.win32

8 messages in com.mysql.lists.win32RE: How to kill MySQL process ?

From	Sent On	Attachments
Daniel Stenmark Eriksson	13 May 2004 01:13
Beau Frusetta	13 May 2004 01:22
Joe Harkins	13 May 2004 04:33
Rodrigo Haces	13 May 2004 08:28
Rodrigo Haces	13 May 2004 08:47
Joe Harkins	13 May 2004 08:53
Beau Frusetta	13 May 2004 11:39
Samuel	13 May 2004 15:26

Subject:	RE: How to kill MySQL process ?
From:	Rodrigo Haces (rhac...@yahoo.com.mx)
Date:	05/13/2004 08:47:21 AM
List:	com.mysql.lists.win32

I think you may be doing something wrong, i have tryed the next thing: I have task manager opened at the process tab I have 3 cmd's opened and do as follows: 1.- CMD1: d:\web\mysql\bin\mysqld-opt --standalone 2.- Check out that if there is a process of mysqld-opt at my task manager and found it. 3.- CMD2: d:\web\mysql\bin\mysql -u root 4.- SELECT * FROM TABLE; 5.- EXIT 6.- CMD3: d:\web\mysq\bin\mysqladmin -u root shutdown 7.- Check out again for the mysqld-opt at task manager but it's not there.

so i think you shoud try doing this, if the result is the same as me, check out your application and see if you have some unclosed connections, or something like that, or try making a simple application that only do steps 1 and 6 and check out the process list.

Hope this helps Rodrigo

-----Mensaje original----- De: Daniel Stenmark Eriksson [mailto:dan...@sema-tec.com] Enviado el: Jueves, 13 de Mayo de 2004 03:14 a.m. Para: win...@lists.mysql.com Asunto: How to kill MySQL process ?

Hi there,

I'm developing a application based on MySQL 4.1.0 alpha running on WINDOWS XP using MyODBC 3.51.07 to connect.

I would like my application to start and stop MySQL as the application starts and stops.

My application starts MySQL with "C:\.......\bin\mysqld-opt --standalone"

The mysql-opt.exe now appears in the process list of WINDOW task manger, consuming about 60 Mb RAM.

When trying to stop MySQL with: "C:\........\bin\mysqladmin -u user shutdown" MySQL is stopped in the sense it does not respond anymore, BUT, the mysql-opt.exe is still present in WINDOWS task manager, now consuming about 15 Mb RAM. When running my application once again it starts a second mysql-opt.exe in WINDOWS task manager, leaving it with approx. 15 Mb RAM when stopped.

How do I get rid of the mysql-opt.exe process when stopping MySQL ??

Daniel Stenmark Eriksson

SEMA-TEC AB Hanholmsvägen 41B SE-602 38 Norrköping Sweden

Phone. +46 11 12 80 60 Fax. +46 11 12 80 62 Mob. +46 707 10 32 14