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 <vi...@khera.org> wrote: > > On Tue, Nov 26, 2013 at 2:48 PM, Joey Quinn <bjquinn...@gmail.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. >
