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
>
>
---------------------------------------------------------------------
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-thread98856@stripped>
To unsubscribe, e-mail <mysql-unsubscribe-cyon=bestweb.net@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
