Re: tracking scripts...

nope, that appears to be being blocked by the updates...

tried "select * from ipv4_table where country='gb' limit 1;"

it just sat there...

On Tue, Nov 26, 2013 at 3:00 PM, Vick Khera <vivek(at)khera(dot)org> wrote:

>
> On Tue, Nov 26, 2013 at 2:48 PM, Joey Quinn <bjquinniii(at)gmail(dot)com> wrote:
>
>> The ranges are indeed overlapping, though the update statements were
>> generated alphabetically rather than in IP order... If the command line
>> will let me query the table directly without being blocked by the ongoing
>> updates, then I could get a rough order of magnitude of progress by doing a
>> null count on the county field... hate to throw queries at it while it's
>> busy updating though...
>>
>
> Try a SELECT ... LIMIT 1; it will find the first row that matches and
> exit. So you can see if any particular country code has been set. Again,
> binary search on the codes.
>