List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:February 7 2002 5:39pm
Subject:Re: long query status info
View as plain text  
I can't read your structures or query from here.

nils@stripped wrote:

>hi,
>
>i'm running a big query across a table containing more than 137 million rows comparing
> them to another one with about 4000 rows and i'm wondering how long it will still take...
>
>is there a way to see how many operations have been made and how many are left?
>
>as you can see it already took about 107h:
>
># mysqladmin processlist
>+----+------+-----------+-----------------+---------+--------+----------------------+-------------
>| Id | User | Host      | db              | Command | Time   | State                |
> Info
>+----+------+-----------+-----------------+---------+--------+----------------------+------------
>| 7  | root | localhost | einzugsbereiche | Query   | 387723 | Copying to tmp table |
> SELECT
>
>
>---------------------------------------------------------------------
>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 <mysql-thread98801@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


Thread
long query status infonils7 Feb
  • Re: long query status infoGerald Clark7 Feb