Re: stopping a query

2002-09-27 Thread Robert Citek
Hello Ozette, At 05:36 AM 9/27/2002 -0400, Ozette Brown wrote: >To stop a running query, you'll need to do a 'myqsladmin processlist' > and once you find the PID for the query, issues a "mysqladmin kill PID". >This should do the trick. Is there not a more elegant solution? Would not the above

Re: stopping a query

2002-09-27 Thread Ozette Brown
Robert, To stop a running query, you'll need to do a 'myqsladmin processlist' and once you find the PID for the query, issues a "mysqladmin kill PID". This should do the trick. Thanks, Ozette Robert Citek wrote: >Hello all, > >How do I stop a query once it has started without quitting the M

stopping a query

2002-09-26 Thread Robert Citek
Hello all, How do I stop a query once it has started without quitting the MySQL client? I have a MySQL daemon and client (v3.23.36) running on a RedHat Linux 7.1 box. I ran a query that joined two large tables (>300K rows each) on columns that I had forgot to index. When I pressed Ctrl-C, thi