/usr/sbin/mysqld, Version: 5.5.17-4-log ((Debian)). started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument # Time: 120111 6:30:06 # User@Host: freifunksql5[freifunksql5] @ localhost [] # Query_time: 5.194703 Lock_time: 0.000201 Rows_sent: 36 Rows_examined: 966185 use freifunksql5; SET timestamp=1326259806; SELECT DISTINCT crawl_interfaces.ipv6_link_local_addr, routers.hostname FROM crawl_interfaces, crawl_routers, routers WHERE crawl_routers.status='online' AND crawl_interfaces.name='br-mesh' AND routers.id=crawl_interfaces.router_id; # Time: 120111 6:35:08 # User@Host: freifunksql5[freifunksql5] @ localhost [] # Query_time: 6.714524 Lock_time: 0.000193 Rows_sent: 36 Rows_examined: 1018966 SET timestamp=1326260108; SELECT DISTINCT crawl_interfaces.ipv6_link_local_addr, routers.hostname FROM crawl_interfaces, crawl_routers, routers WHERE crawl_routers.status='online' AND crawl_interfaces.name='br-mesh' AND routers.id=crawl_interfaces.router_id; # Time: 120111 6:40:06 # User@Host: freifunksql5[freifunksql5] @ localhost [] # Query_time: 5.408984 Lock_time: 0.000208 Rows_sent: 36 Rows_examined: 967140 SET timestamp=1326260406; SELECT DISTINCT crawl_interfaces.ipv6_link_local_addr, routers.hostname FROM crawl_interfaces, crawl_routers, routers WHERE crawl_routers.status='online' AND crawl_interfaces.name='br-mesh' AND routers.id=crawl_interfaces.router_id; # Time: 120111 6:45:08 # User@Host: freifunksql5[freifunksql5] @ localhost [] # Query_time: 6.639433 Lock_time: 0.000223 Rows_sent: 36 Rows_examined: 1018972 SET timestamp=1326260708; SELECT DISTINCT crawl_interfaces.ipv6_link_local_addr, routers.hostname FROM crawl_interfaces, crawl_routers, routers WHERE crawl_routers.status='online' AND crawl_interfaces.name='br-mesh' AND routers.id=crawl_interfaces.router_id; # Time: 120111 6:50:06 # User@Host: freifunksql5[freifunksql5] @ localhost [] # Query_time: 5.052262 Lock_time: 0.000220 Rows_sent: 36 Rows_examined: 966188 SET timestamp=1326261006; SELECT DISTINCT crawl_interfaces.ipv6_link_local_addr, routers.hostname FROM crawl_interfaces, crawl_routers, routers WHERE crawl_routers.status='online' AND crawl_interfaces.name='br-mesh' AND routers.id=crawl_interfaces.router_id; # Time: 120111 6:55:06 # User@Host: freifunksql5[freifunksql5] @ localhost [] # Query_time: 5.117388 Lock_time: 0.000211 Rows_sent: 36 Rows_examined: 1020981 SET timestamp=1326261306; SELECT DISTINCT crawl_interfaces.ipv6_link_local_addr, routers.hostname FROM crawl_interfaces, crawl_routers, routers WHERE crawl_routers.status='online' AND crawl_interfaces.name='br-mesh' AND routers.id=crawl_interfaces.router_id; # Time: 120111 7:00:07 # User@Host: freifunksql5[freifunksql5] @ localhost [] # Query_time: 5.593118 Lock_time: 0.000180 Rows_sent: 36 Rows_examined: 970123 SET timestamp=1326261607; SELECT DISTINCT crawl_interfaces.ipv6_link_local_addr, routers.hostname FROM crawl_interfaces, crawl_routers, routers WHERE crawl_routers.status='online' AND crawl_interfaces.name='br-mesh' AND routers.id=crawl_interfaces.router_id; # Time: 120111 7:05:08 # User@Host: freifunksql5[freifunksql5] @ localhost [] # Query_time: 6.577085 Lock_time: 0.000191 Rows_sent: 36 Rows_examined: 1020983 SET timestamp=1326261908; SELECT DISTINCT crawl_interfaces.ipv6_link_local_addr, routers.hostname FROM crawl_interfaces, crawl_routers, routers WHERE crawl_routers.status='online' AND crawl_interfaces.name='br-mesh' AND routers.id=crawl_interfaces.router_id;