3XLcom
asked on
Mysql performance issue
i have a DB as attached but for a query like this :
how should i resolve this ? I have attached my db sql
backup-2013-12-19.sql
INSERT INTO dakikatrafik (saat, ip, total_in, total_out)
SELECT `timestampfromfile`, `ip_addr`
, SUM(IF(`direction`='in', `octets`, 0)) AS total_in
, SUM(IF(`direction`='out', `octets`, 0)) AS total_out
FROM (
SELECT `timestampfromfile`, `srcip` AS ip_addr, `octets`, 'out' AS `direction`
FROM mytable
WHERE timestampfromfile > DATE_SUB(NOW(), INTERVAL minute(now()) MINUTE)
UNION ALL
SELECT `timestampfromfile`, `dstip` AS ip_addr, `octets`, 'in' AS `direction`
FROM mytable
WHERE timestampfromfile > DATE_SUB(NOW(), INTERVAL minute(now()) MINUTE)
) a
INNER JOIN ipAdresleri i ON i.ip=a.ip_addr
GROUP BY `timestampfromfile`, `ip_addr`
;
takes more then one hour which need to be work in every hour :)how should i resolve this ? I have attached my db sql
backup-2013-12-19.sql
ASKER
mysql> EXPLAIN SELECT `timestampfromfile`, `srcip` AS ip_addr, `octets`, 'out' AS `direction` FROM mytable WHERE timestampfromfile > DATE_SUB(NOW(), INTERVAL minute(now()) MINUTE);
+----+-------------+---------+------+---------------+------+---------+------+--------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+---------+------+---------------+------+---------+------+--------+-------------+
| 1 | SIMPLE | mytable | ALL | NULL | NULL | NULL | NULL | 257445 | Using where |
+----+-------------+---------+------+---------------+------+---------+------+--------+-------------+
1 row in set (0.00 sec)
mysql> EXPLAIN SELECT `timestampfromfile`, `srcip` AS ip_addr, `octets`, 'out' AS `direction` FROM mytable a INNER JOIN ipAdresleri i ON i.ip=a.srcip WHERE timestampfromfile > DATE_SUB(NOW(), INTERVAL minute(now()) MINUTE);
+----+-------------+-------+-------+---------------+---------+---------+------+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+-------+---------------+---------+---------+------+------+-------------+
| 1 | SIMPLE | i | index | NULL | PRIMARY | 26 | NULL | 5239 | Using index |
| 1 | SIMPLE | a | ref | PRIMARY | PRIMARY | 47 | func | 2618 | Using where |
+----+-------------+-------+-------+---------------+---------+---------+------+------+-------------+
2 rows in set (0.00 sec)
Okay, so you definitely want to limit IP address inside the derived table query as you get to leverage the efficiency sooner (i.e., avoid bringing back 500K rows only to filter to 5K). Perhaps if you had an index with both srcip and date (and a separate one for dstip and date), you will see even better performance.
ASKER
but in the derived table src or dst is our ip no row will be limited.
we already created indexes but nothing change
we already created indexes but nothing change
Not sure I follow. According to the EXPLAIN results, you would be better off with this:
Therefore, I am suggesting you see if a combined index on `srcip` AND timestampfromfile performs better for you than index on just `srcip` OR timestampfromfile. You already have the PRIMARY KEY in the ipAdresleri table, so nothing to change there as the JOIN will make this more efficient compared to without as evidenced by the significant difference in row count in your EXPLAIN results above.
SELECT `timestampfromfile`, `srcip` AS ip_addr, `octets`, 'out' AS `direction`
FROM mytable a
INNER JOIN ipAdresleri i ON i.ip=a.`srcip`
WHERE timestampfromfile > DATE_SUB(NOW(), INTERVAL minute(now()) MINUTE)
UNION ALL
SELECT `timestampfromfile`, `dstip` AS ip_addr, `octets`, 'in' AS `direction`
FROM mytable a
INNER JOIN ipAdresleri i ON i.ip=a.`dstip`
WHERE timestampfromfile > DATE_SUB(NOW(), INTERVAL minute(now()) MINUTE)
Therefore, I am suggesting you see if a combined index on `srcip` AND timestampfromfile performs better for you than index on just `srcip` OR timestampfromfile. You already have the PRIMARY KEY in the ipAdresleri table, so nothing to change there as the JOIN will make this more efficient compared to without as evidenced by the significant difference in row count in your EXPLAIN results above.
ASKER
it is completed in 144 seconds this time . but that is not all query
It was just to improve it one part at a time.
To make sure we are on the same page, I got MySQL installed and added the following:
When you run this:
You see that IX_SrcIP and IX_DstIP are used, creating a much more closer fit of rows scanned to rows returned, correct?
Next, just plug this back to the original query, commenting out INSERT part to test.
It finishes in 2 seconds for me. If that works for you also, uncomment the INSERT line.
To make sure we are on the same page, I got MySQL installed and added the following:
ALTER TABLE `test`.`mytable`
DROP INDEX ,
ADD INDEX `IX_SrcIP` (`srcIP` ASC, `timestampfromfile` ASC),
DROP INDEX ,
ADD INDEX `IX_DstIP` (`dstIP` ASC, `timestampfromfile` ASC);
When you run this:
EXPLAIN
SELECT `timestampfromfile`, `srcip` AS ip_addr, `octets`, 'out' AS `direction`
FROM mytable a
INNER JOIN ipAdresleri i ON i.ip=a.`srcip`
WHERE timestampfromfile > DATE_SUB(NOW(), INTERVAL minute(now()) MINUTE)
UNION ALL
SELECT `timestampfromfile`, `dstip` AS ip_addr, `octets`, 'in' AS `direction`
FROM mytable a
INNER JOIN ipAdresleri i ON i.ip=a.`dstip`
WHERE timestampfromfile > DATE_SUB(NOW(), INTERVAL minute(now()) MINUTE)
You see that IX_SrcIP and IX_DstIP are used, creating a much more closer fit of rows scanned to rows returned, correct?
Next, just plug this back to the original query, commenting out INSERT part to test.
-- INSERT INTO dakikatrafik (saat, ip, total_in, total_out)
SELECT `timestampfromfile`, `ip_addr`
, SUM(IF(`direction`='in', `octets`, 0)) AS total_in
, SUM(IF(`direction`='out', `octets`, 0)) AS total_out
FROM (
SELECT `timestampfromfile`, `srcip` AS ip_addr, `octets`, 'out' AS `direction`
FROM mytable a
INNER JOIN ipAdresleri i ON i.ip=a.`srcip`
WHERE timestampfromfile > DATE_SUB(NOW(), INTERVAL minute(now()) MINUTE)
UNION ALL
SELECT `timestampfromfile`, `dstip` AS ip_addr, `octets`, 'in' AS `direction`
FROM mytable a
INNER JOIN ipAdresleri i ON i.ip=a.`dstip`
WHERE timestampfromfile > DATE_SUB(NOW(), INTERVAL minute(now()) MINUTE)
) a
INNER JOIN ipAdresleri i ON i.ip=a.ip_addr
GROUP BY `timestampfromfile`, `ip_addr`
;
It finishes in 2 seconds for me. If that works for you also, uncomment the INSERT line.
To get a clean cut between minutes and to lessen the number of rows written to the traffic table, which ultimately will help with performance if you query that table often, you can look at something like this (unless you need the specific time stamp of the activity down to the second).
It only includes the time stamp values between the previous minute. For example, it is 11:50am for me, so the query would run with the below filter.
WHERE timestampfromfile >= '2013-12-19 11:49:00'
AND timestampfromfile < '2013-12-19 11:50:00'
I hope that helps!
-- INSERT INTO dakikatrafik (saat, ip, total_in, total_out)
SELECT `timestampfromfile`, `ip_addr`
, SUM(IF(`direction`='in', `octets`, 0)) AS total_in
, SUM(IF(`direction`='out', `octets`, 0)) AS total_out
FROM (
SELECT DATE_SUB(timestampfromfile, INTERVAL SECOND(timestampfromfile) SECOND) AS `timestampfromfile`
, `srcip` AS ip_addr, `octets`, 'out' AS `direction`
FROM mytable a
INNER JOIN ipAdresleri i ON i.ip=a.`srcip`
WHERE timestampfromfile >= DATE_SUB(NOW(), INTERVAL 60+SECOND(NOW()) SECOND)
AND timestampfromfile < DATE_SUB(NOW(), INTERVAL SECOND(NOW()) SECOND)
UNION ALL
SELECT DATE_SUB(timestampfromfile, INTERVAL SECOND(timestampfromfile) SECOND) AS `timestampfromfile`
, `dstip` AS ip_addr, `octets`, 'in' AS `direction`
FROM mytable a
INNER JOIN ipAdresleri i ON i.ip=a.`dstip`
WHERE timestampfromfile >= DATE_SUB(NOW(), INTERVAL 60+SECOND(NOW()) SECOND)
AND timestampfromfile < DATE_SUB(NOW(), INTERVAL SECOND(NOW()) SECOND)
) a
INNER JOIN ipAdresleri i ON i.ip=a.ip_addr
GROUP BY `timestampfromfile`, `ip_addr`
;
It only includes the time stamp values between the previous minute. For example, it is 11:50am for me, so the query would run with the below filter.
WHERE timestampfromfile >= '2013-12-19 11:49:00'
AND timestampfromfile < '2013-12-19 11:50:00'
I hope that helps!
ASKER
mysql> INSERT INTO dakikatrafik (saat, ip, total_in, total_out) SELECT `timestampfromfile`, `ip_addr` , SUM(IF(`direction`='in', `octets`, 0)) AS total_in , SUM(IF(`direction`='out', `octets`, 0)) AS total_out FROM ( SELECT `timestampfromfile`, `srcip` AS ip_addr, `octets`, 'out' AS `direction` FROM mytable a INNER JOIN ipAdresleri i ON i.ip=a.`srcip` WHERE timestampfromfile > DATE_SUB(NOW(), INTERVAL minute(now()) MINUTE) UNION ALL SELECT `timestampfromfile`, `dstip` AS ip_addr, `octets`, 'in' AS `direction` FROM mytable a INNER JOIN ipAdresleri i ON i.ip=a.`dstip` WHERE timestampfromfile > DATE_SUB(NOW(), INTERVAL minute(now()) MINUTE) ) a INNER JOIN ipAdresleri i ON i.ip=a.ip_addr GROUP BY `timestampfromfile`, `ip_addr`;
Ctrl-C -- sending "KILL QUERY 1009" to server ...
Ctrl-C -- query aborted.
ERROR 1317 (70100): Query execution was interrupted
it could not complete the process for in 30 minutes and i have canceled
ASKER
and also that does not worked for me :
mysql> ALTER TABLE `ip`.`mytable` DROP INDEX , ADD INDEX `IX_SrcIP` (`srcIP` ASC, `timestampfromfile` ASC), DROP INDEX , ADD INDEX `IX_DstIP` (`dstIP` ASC, `timestampfromfile` ASC);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' ADD INDEX `IX_SrcIP` (`srcIP` ASC, `timestampfromfile` ASC), DROP INDEX , ADD ' at line 1
ASKER
I am sorry ; I have done the indexing but now problem is about inserting the rows.
when i activate insert into it can not complete the process.
when i activate insert into it can not complete the process.
mysql> EXPLAIN
-> SELECT `timestampfromfile`, `srcip` AS ip_addr, `octets`, 'out' AS `direction`
-> FROM mytable a
-> INNER JOIN ipAdresleri i ON i.ip=a.`srcip`
-> WHERE timestampfromfile > DATE_SUB(NOW(), INTERVAL minute(now()) MINUTE)
->
-> UNION ALL
->
-> SELECT `timestampfromfile`, `dstip` AS ip_addr, `octets`, 'in' AS `direction`
-> FROM mytable a
-> INNER JOIN ipAdresleri i ON i.ip=a.`dstip`
-> WHERE timestampfromfile > DATE_SUB(NOW(), INTERVAL minute(now()) MINUTE);
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 1102
Current database: ip
+----+--------------+------------+-------+---------------+----------+---------+------+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+--------------+------------+-------+---------------+----------+---------+------+------+-------------+
| 1 | PRIMARY | i | index | NULL | PRIMARY | 26 | NULL | 5239 | Using index |
| 1 | PRIMARY | a | ref | IX_SrcIP | IX_SrcIP | 47 | func | 7 | Using where |
| 2 | UNION | i | index | NULL | PRIMARY | 26 | NULL | 5239 | Using index |
| 2 | UNION | a | ref | IX_DstIP | IX_DstIP | 47 | func | 9 | Using where |
| NULL | UNION RESULT | <union1,2> | ALL | NULL | NULL | NULL | NULL | NULL | |
+----+--------------+------------+-------+---------------+----------+---------+------+------+-------------+
5 rows in set (0.01 sec)
mysql> SELECT `timestampfromfile`, `ip_addr`
-> , SUM(IF(`direction`='in', `octets`, 0)) AS total_in
-> , SUM(IF(`direction`='out', `octets`, 0)) AS total_out
-> FROM (
-> SELECT `timestampfromfile`, `srcip` AS ip_addr, `octets`, 'out' AS `direction`
-> FROM mytable a
-> INNER JOIN ipAdresleri i ON i.ip=a.`srcip`
-> WHERE timestampfromfile > DATE_SUB(NOW(), INTERVAL minute(now()) MINUTE)
->
-> UNION ALL
->
-> SELECT `timestampfromfile`, `dstip` AS ip_addr, `octets`, 'in' AS `direction`
-> FROM mytable a
-> INNER JOIN ipAdresleri i ON i.ip=a.`dstip`
-> WHERE timestampfromfile > DATE_SUB(NOW(), INTERVAL minute(now()) MINUTE)
-> ) a
-> INNER JOIN ipAdresleri i ON i.ip=a.ip_addr
-> GROUP BY `timestampfromfile`, `ip_addr`
-> ;
+---------------------+----------------+----------+-----------+
| timestampfromfile | ip_addr | total_in | total_out |
+---------------------+----------------+----------+-----------+
| 2013-12-19 19:40:00 | 178.20.224.10 | 411136 | 84736 |
| 2013-12-19 19:40:00 | 178.20.224.15 | 5767424 | 770560 |
| 2013-12-19 19:40:00 | 178.20.224.155 | 2040320 | 1555456 |
| 2013-12-19 19:40:00 | 178.20.224.16 | 64512 | 1218560 |
| 2013-12-19 19:40:00 | 178.20.224.19 | 118784 | 52992 |
| 2013-12-19 19:40:00 | 178.20.224.203 | 6117120 | 76800 |
| 2013-12-19 19:40:00 | 178.20.224.208 | 17408 | 0 |
| 2013-12-19 19:40:00 | 178.20.224.218 | 818432 | 28672 |
| 2013-12-19 19:40:00 | 178.20.224.219 | 198912 | 368640 |
| 2013-12-19 19:40:00 | 178.20.224.22 | 517120 | 167424 |
| 2013-12-19 19:40:00 | 178.20.224.229 | 7168 | 0 |
| 2013-12-19 19:40:00 | 178.20.224.231 | 13312 | 0 |
| 2013-12-19 19:40:00 | 178.20.224.24 | 1024000 | 905216 |
| 2013-12-19 19:40:00 | 178.20.224.26 | 50688 | 0 |
| 2013-12-19 19:40:00 | 178.20.224.34 | 32000 | 36608 |
| 2013-12-19 19:40:00 | 178.20.225.163 | 251904 | 395264 |
| 2013-12-19 19:40:00 | 178.20.225.195 | 269312 | 13312 |
| 2013-12-19 19:40:00 | 178.20.225.197 | 316928 | 0 |
| 2013-12-19 19:40:00 | 178.20.225.199 | 71936 | 0 |
| 2013-12-19 19:40:00 | 178.20.225.200 | 370176 | 0 |
| 2013-12-19 19:40:00 | 178.20.225.204 | 832768 | 980224 |
| 2013-12-19 19:40:00 | 178.20.225.205 | 2156800 | 29696 |
| 2013-12-19 19:40:00 | 178.20.225.206 | 13312 | 41728 |
| 2013-12-19 19:40:00 | 178.20.225.254 | 381952 | 1155072 |
| 2013-12-19 19:40:00 | 178.20.225.82 | 353792 | 52224 |
| 2013-12-19 19:40:00 | 178.20.225.83 | 497152 | 183808 |
| 2013-12-19 19:40:00 | 178.20.225.91 | 0 | 376320 |
| 2013-12-19 19:40:00 | 178.20.226.12 | 75776 | 0 |
| 2013-12-19 19:40:00 | 178.20.226.121 | 7168 | 0 |
| 2013-12-19 19:40:00 | 178.20.226.124 | 15360 | 0 |
| 2013-12-19 19:40:00 | 178.20.226.126 | 1975808 | 144128 |
| 2013-12-19 19:40:00 | 178.20.226.131 | 92672 | 0 |
| 2013-12-19 19:40:00 | 178.20.226.14 | 641536 | 154880 |
| 2013-12-19 19:40:00 | 178.20.226.140 | 2695168 | 902144 |
| 2013-12-19 19:40:00 | 178.20.226.142 | 19712 | 0 |
| 2013-12-19 19:40:00 | 178.20.226.144 | 859648 | 468224 |
| 2013-12-19 19:40:00 | 178.20.226.145 | 25088 | 81408 |
| 2013-12-19 19:40:00 | 178.20.226.146 | 64512 | 0 |
| 2013-12-19 19:40:00 | 178.20.226.149 | 388864 | 644608 |
| 2013-12-19 19:40:00 | 178.20.226.150 | 11776 | 22016 |
| 2013-12-19 19:40:00 | 178.20.226.17 | 377344 | 0 |
| 2013-12-19 19:40:00 | 178.20.226.187 | 24064 | 0 |
| 2013-12-19 19:40:00 | 178.20.226.188 | 169216 | 16384 |
| 2013-12-19 19:40:00 | 178.20.226.200 | 23552 | 67072 |
| 2013-12-19 19:40:00 | 178.20.226.233 | 378624 | 384000 |
| 2013-12-19 19:40:00 | 178.20.226.68 | 462592 | 55296 |
| 2013-12-19 19:40:00 | 178.20.227.100 | 15360 | 0 |
| 2013-12-19 19:40:00 | 178.20.227.114 | 4360960 | 2509056 |
| 2013-12-19 19:40:00 | 178.20.227.120 | 4352 | 0 |
| 2013-12-19 19:40:00 | 178.20.227.168 | 7168 | 11520 |
| 2013-12-19 19:40:00 | 178.20.227.169 | 97792 | 782336 |
| 2013-12-19 19:40:00 | 178.20.227.170 | 870144 | 376320 |
| 2013-12-19 19:40:00 | 178.20.227.176 | 7168 | 0 |
| 2013-12-19 19:40:00 | 178.20.227.178 | 370176 | 0 |
| 2013-12-19 19:40:00 | 178.20.227.179 | 1155072 | 419328 |
| 2013-12-19 19:40:00 | 178.20.227.222 | 11008 | 0 |
| 2013-12-19 19:40:00 | 178.20.227.223 | 14336 | 0 |
| 2013-12-19 19:40:00 | 178.20.227.227 | 33792 | 27904 |
| 2013-12-19 19:40:00 | 178.20.227.231 | 11776 | 0 |
| 2013-12-19 19:40:00 | 178.20.227.244 | 0 | 384000 |
| 2013-12-19 19:40:00 | 178.20.227.245 | 396032 | 1185280 |
| 2013-12-19 19:40:00 | 178.20.227.252 | 32000 | 0 |
| 2013-12-19 19:40:00 | 178.20.227.32 | 419328 | 0 |
| 2013-12-19 19:40:00 | 178.20.227.41 | 84224 | 29696 |
| 2013-12-19 19:40:00 | 178.20.227.43 | 1651456 | 432896 |
| 2013-12-19 19:40:00 | 178.20.227.48 | 67328 | 92416 |
| 2013-12-19 19:40:00 | 178.20.227.71 | 108032 | 7046144 |
| 2013-12-19 19:40:00 | 178.20.227.72 | 2091776 | 2220544 |
| 2013-12-19 19:40:00 | 178.20.227.73 | 30464 | 0 |
| 2013-12-19 19:40:00 | 178.20.227.75 | 342272 | 55808 |
| 2013-12-19 19:40:00 | 178.20.227.76 | 303104 | 7033344 |
| 2013-12-19 19:40:00 | 178.20.227.77 | 1805568 | 219136 |
| 2013-12-19 19:40:00 | 178.20.227.78 | 2573056 | 438272 |
| 2013-12-19 19:40:00 | 178.20.227.85 | 384768 | 280320 |
| 2013-12-19 19:40:00 | 178.20.227.86 | 892416 | 1736960 |
| 2013-12-19 19:40:00 | 178.20.227.90 | 12364032 | 152832 |
| 2013-12-19 19:40:00 | 178.20.228.120 | 5963776 | 36418560 |
| 2013-12-19 19:40:00 | 178.20.228.223 | 8704 | 0 |
| 2013-12-19 19:40:00 | 178.20.228.224 | 4561920 | 14334464 |
| 2013-12-19 19:40:00 | 178.20.228.225 | 1423872 | 4254976 |
| 2013-12-19 19:40:00 | 178.20.228.30 | 30720 | 44800 |
| 2013-12-19 19:40:00 | 178.20.228.37 | 3392256 | 90624 |
| 2013-12-19 19:40:00 | 178.20.228.43 | 1632512 | 17773312 |
| 2013-12-19 19:40:00 | 178.20.228.56 | 40960 | 3599104 |
| 2013-12-19 19:40:00 | 178.20.228.57 | 1365248 | 10380800 |
| 2013-12-19 19:40:00 | 178.20.228.73 | 3427072 | 656128 |
| 2013-12-19 19:40:00 | 178.20.228.74 | 60416 | 0 |
| 2013-12-19 19:40:00 | 178.20.228.75 | 12452864 | 30720 |
| 2013-12-19 19:40:00 | 178.20.228.87 | 8960 | 7168 |
| 2013-12-19 19:40:00 | 178.20.228.88 | 41216 | 0 |
| 2013-12-19 19:40:00 | 178.20.229.217 | 13312 | 0 |
| 2013-12-19 19:40:00 | 178.20.230.137 | 1105664 | 7168 |
| 2013-12-19 19:40:00 | 178.20.230.156 | 14336 | 0 |
| 2013-12-19 19:40:00 | 178.20.230.172 | 3087360 | 227328 |
| 2013-12-19 19:40:00 | 178.20.230.174 | 15360 | 0 |
| 2013-12-19 19:40:00 | 178.20.230.177 | 34816 | 0 |
| 2013-12-19 19:40:00 | 178.20.230.178 | 11264 | 0 |
| 2013-12-19 19:40:00 | 178.20.230.180 | 55552 | 357376 |
| 2013-12-19 19:40:00 | 178.20.230.190 | 794880 | 385536 |
| 2013-12-19 19:40:00 | 178.20.230.199 | 242944 | 18944 |
| 2013-12-19 19:40:00 | 178.20.231.100 | 26112 | 7168 |
| 2013-12-19 19:40:00 | 178.20.231.101 | 28160 | 0 |
| 2013-12-19 19:40:00 | 178.20.231.102 | 15238400 | 21004544 |
| 2013-12-19 19:40:00 | 178.20.231.11 | 20480 | 0 |
| 2013-12-19 19:40:00 | 178.20.231.13 | 1563648 | 2316800 |
| 2013-12-19 19:40:00 | 178.20.231.14 | 829952 | 1871360 |
| 2013-12-19 19:40:00 | 178.20.231.154 | 49920 | 0 |
| 2013-12-19 19:40:00 | 178.20.231.155 | 2848000 | 19712 |
| 2013-12-19 19:40:00 | 178.20.231.158 | 518144 | 435968 |
| 2013-12-19 19:40:00 | 178.20.231.159 | 11776 | 0 |
| 2013-12-19 19:40:00 | 178.20.231.160 | 13312 | 0 |
| 2013-12-19 19:40:00 | 178.20.231.168 | 24064 | 16384 |
| 2013-12-19 19:40:00 | 178.20.231.17 | 0 | 7168 |
| 2013-12-19 19:40:00 | 178.20.231.170 | 26368 | 0 |
| 2013-12-19 19:40:00 | 178.20.231.175 | 480256 | 42496 |
| 2013-12-19 19:40:00 | 178.20.231.178 | 200192 | 73728 |
| 2013-12-19 19:40:00 | 178.20.231.18 | 554752 | 772352 |
| 2013-12-19 19:40:00 | 178.20.231.19 | 242432 | 405760 |
| 2013-12-19 19:40:00 | 178.20.231.205 | 366592 | 0 |
| 2013-12-19 19:40:00 | 178.20.231.210 | 8043008 | 1115392 |
| 2013-12-19 19:40:00 | 178.20.231.211 | 342528 | 685824 |
| 2013-12-19 19:40:00 | 178.20.231.213 | 162560 | 402944 |
| 2013-12-19 19:40:00 | 178.20.231.32 | 15360 | 0 |
| 2013-12-19 19:40:00 | 178.20.231.33 | 381952 | 783360 |
| 2013-12-19 19:40:00 | 178.20.231.4 | 1172224 | 2116608 |
| 2013-12-19 19:40:00 | 178.20.231.42 | 50176 | 0 |
| 2013-12-19 19:40:00 | 178.20.231.44 | 0 | 197632 |
| 2013-12-19 19:40:00 | 178.20.231.48 | 820992 | 1182464 |
| 2013-12-19 19:40:00 | 178.20.231.49 | 400384 | 0 |
| 2013-12-19 19:40:00 | 178.20.231.50 | 408576 | 280320 |
| 2013-12-19 19:40:00 | 178.20.231.51 | 13312 | 0 |
| 2013-12-19 19:40:00 | 178.20.231.52 | 7168 | 0 |
| 2013-12-19 19:40:00 | 178.20.231.57 | 15360 | 0 |
| 2013-12-19 19:40:00 | 178.20.231.64 | 2360320 | 1543680 |
| 2013-12-19 19:40:00 | 178.20.231.76 | 394240 | 206848 |
| 2013-12-19 19:40:00 | 178.20.231.77 | 43008 | 424192 |
| 2013-12-19 19:40:00 | 178.20.231.80 | 9984 | 0 |
| 2013-12-19 19:40:00 | 178.20.231.81 | 0 | 38912 |
| 2013-12-19 19:40:00 | 178.20.231.82 | 9903616 | 12995584 |
| 2013-12-19 19:40:00 | 178.20.231.84 | 37632 | 22272 |
| 2013-12-19 19:40:00 | 178.20.231.85 | 0 | 23040 |
| 2013-12-19 19:40:00 | 178.20.231.86 | 5797376 | 13572864 |
| 2013-12-19 19:40:00 | 178.20.231.90 | 149248 | 926464 |
| 2013-12-19 19:40:00 | 178.20.231.92 | 26368 | 13824 |
| 2013-12-19 19:40:00 | 178.20.231.93 | 27648 | 14336 |
| 2013-12-19 19:40:00 | 178.20.231.94 | 42496 | 766976 |
| 2013-12-19 19:40:00 | 178.20.231.95 | 5836032 | 9885184 |
| 2013-12-19 19:40:00 | 185.9.156.1 | 0 | 301056 |
| 2013-12-19 19:40:00 | 185.9.156.101 | 301056 | 0 |
| 2013-12-19 19:40:00 | 185.9.156.107 | 94208 | 1546240 |
| 2013-12-19 19:40:00 | 185.9.156.116 | 0 | 28672 |
| 2013-12-19 19:40:00 | 185.9.156.127 | 9970688 | 878592 |
| 2013-12-19 19:40:00 | 185.9.156.129 | 0 | 28672 |
| 2013-12-19 19:40:00 | 185.9.156.134 | 133120 | 0 |
| 2013-12-19 19:40:00 | 185.9.156.135 | 4848640 | 0 |
| 2013-12-19 19:40:00 | 185.9.156.136 | 77572096 | 69174272 |
| 2013-12-19 19:40:00 | 185.9.156.141 | 4415488 | 36864 |
| 2013-12-19 19:40:00 | 185.9.156.191 | 83968 | 0 |
| 2013-12-19 19:40:00 | 185.9.156.192 | 0 | 97280 |
| 2013-12-19 19:40:00 | 185.9.156.242 | 12333056 | 0 |
| 2013-12-19 19:40:00 | 185.9.156.25 | 1677312 | 3084288 |
| 2013-12-19 19:40:00 | 185.9.156.35 | 53248 | 0 |
| 2013-12-19 19:40:00 | 185.9.156.37 | 1642496 | 102400 |
| 2013-12-19 19:40:00 | 185.9.156.41 | 7940096 | 81920 |
| 2013-12-19 19:40:00 | 185.9.156.45 | 595968 | 1702912 |
| 2013-12-19 19:40:00 | 185.9.156.49 | 77824 | 0 |
| 2013-12-19 19:40:00 | 185.9.156.5 | 4170752 | 3084288 |
| 2013-12-19 19:40:00 | 185.9.156.51 | 0 | 28672 |
| 2013-12-19 19:40:00 | 185.9.156.55 | 65536 | 0 |
| 2013-12-19 19:40:00 | 185.9.156.70 | 47104 | 0 |
| 2013-12-19 19:40:00 | 185.9.156.75 | 474112 | 12288 |
| 2013-12-19 19:40:00 | 185.9.156.77 | 592896 | 0 |
| 2013-12-19 19:40:00 | 185.9.156.79 | 0 | 706560 |
| 2013-12-19 19:40:00 | 185.9.157.125 | 44288 | 70400 |
| 2013-12-19 19:40:00 | 185.9.157.127 | 622336 | 381952 |
| 2013-12-19 19:40:00 | 185.9.157.129 | 13056 | 0 |
| 2013-12-19 19:40:00 | 185.9.157.130 | 0 | 384000 |
| 2013-12-19 19:40:00 | 185.9.157.165 | 0 | 11776 |
| 2013-12-19 19:40:00 | 185.9.157.175 | 105984 | 7168 |
| 2013-12-19 19:40:00 | 185.9.157.178 | 2429440 | 549888 |
| 2013-12-19 19:40:00 | 185.9.157.185 | 24064 | 0 |
| 2013-12-19 19:40:00 | 185.9.157.186 | 467456 | 150528 |
| 2013-12-19 19:40:00 | 185.9.157.2 | 15360 | 368640 |
| 2013-12-19 19:40:00 | 185.9.157.229 | 14592 | 14080 |
| 2013-12-19 19:40:00 | 185.9.157.234 | 31232 | 65280 |
| 2013-12-19 19:40:00 | 185.9.157.238 | 7168 | 0 |
| 2013-12-19 19:40:00 | 185.9.157.246 | 2448640 | 962304 |
| 2013-12-19 19:40:00 | 185.9.157.250 | 18944 | 0 |
| 2013-12-19 19:40:00 | 185.9.159.10 | 7168 | 0 |
| 2013-12-19 19:40:00 | 185.9.159.103 | 11776 | 0 |
| 2013-12-19 19:40:00 | 185.9.159.104 | 626176 | 424960 |
| 2013-12-19 19:40:00 | 185.9.159.11 | 4634112 | 17133824 |
| 2013-12-19 19:40:00 | 185.9.159.119 | 531200 | 811776 |
| 2013-12-19 19:40:00 | 185.9.159.12 | 18944 | 25088 |
| 2013-12-19 19:40:00 | 185.9.159.121 | 89856 | 92160 |
| 2013-12-19 19:40:00 | 185.9.159.124 | 1973248 | 571648 |
| 2013-12-19 19:40:00 | 185.9.159.13 | 11776 | 0 |
| 2013-12-19 19:40:00 | 185.9.159.14 | 1816832 | 162560 |
| 2013-12-19 19:40:00 | 185.9.159.148 | 463360 | 388096 |
| 2013-12-19 19:40:00 | 185.9.159.154 | 406016 | 49920 |
| 2013-12-19 19:40:00 | 185.9.159.155 | 27136 | 194304 |
| 2013-12-19 19:40:00 | 185.9.159.158 | 205056 | 112896 |
| 2013-12-19 19:40:00 | 185.9.159.159 | 11776 | 0 |
| 2013-12-19 19:40:00 | 185.9.159.16 | 86528 | 808960 |
| 2013-12-19 19:40:00 | 185.9.159.160 | 29696 | 631040 |
| 2013-12-19 19:40:00 | 185.9.159.167 | 70656 | 11776 |
| 2013-12-19 19:40:00 | 185.9.159.168 | 48128 | 149760 |
| 2013-12-19 19:40:00 | 185.9.159.169 | 2473728 | 384000 |
| 2013-12-19 19:40:00 | 185.9.159.17 | 7168 | 441856 |
| 2013-12-19 19:40:00 | 185.9.159.172 | 2358528 | 2952704 |
| 2013-12-19 19:40:00 | 185.9.159.182 | 786944 | 63488 |
| 2013-12-19 19:40:00 | 185.9.159.189 | 45056 | 165888 |
| 2013-12-19 19:40:00 | 185.9.159.200 | 11776 | 297728 |
| 2013-12-19 19:40:00 | 185.9.159.206 | 16061952 | 174592 |
| 2013-12-19 19:40:00 | 185.9.159.208 | 1288448 | 1643776 |
| 2013-12-19 19:40:00 | 185.9.159.21 | 0 | 12288 |
| 2013-12-19 19:40:00 | 185.9.159.211 | 575232 | 32256 |
| 2013-12-19 19:40:00 | 185.9.159.212 | 2387968 | 4747520 |
| 2013-12-19 19:40:00 | 185.9.159.215 | 11005440 | 10105088 |
| 2013-12-19 19:40:00 | 185.9.159.221 | 23552 | 0 |
| 2013-12-19 19:40:00 | 185.9.159.223 | 224256 | 0 |
| 2013-12-19 19:40:00 | 185.9.159.227 | 59122944 | 160512 |
| 2013-12-19 19:40:00 | 185.9.159.23 | 7168 | 53504 |
| 2013-12-19 19:40:00 | 185.9.159.230 | 11776 | 0 |
| 2013-12-19 19:40:00 | 185.9.159.232 | 11020544 | 47176704 |
| 2013-12-19 19:40:00 | 185.9.159.233 | 79750656 | 9073152 |
| 2013-12-19 19:40:00 | 185.9.159.234 | 3965952 | 6199296 |
| 2013-12-19 19:40:00 | 185.9.159.240 | 4791552 | 107520 |
| 2013-12-19 19:40:00 | 185.9.159.243 | 2269696 | 89856 |
| 2013-12-19 19:40:00 | 185.9.159.251 | 26624 | 0 |
| 2013-12-19 19:40:00 | 185.9.159.254 | 789248 | 392704 |
| 2013-12-19 19:40:00 | 185.9.159.28 | 15872 | 0 |
| 2013-12-19 19:40:00 | 185.9.159.31 | 2891264 | 450048 |
| 2013-12-19 19:40:00 | 185.9.159.33 | 383488 | 0 |
| 2013-12-19 19:40:00 | 185.9.159.35 | 14592 | 0 |
| 2013-12-19 19:40:00 | 185.9.159.37 | 70656 | 0 |
| 2013-12-19 19:40:00 | 185.9.159.41 | 34816 | 0 |
| 2013-12-19 19:40:00 | 185.9.159.42 | 391168 | 35584 |
| 2013-12-19 19:40:00 | 185.9.159.49 | 14848 | 19456 |
| 2013-12-19 19:40:00 | 185.9.159.52 | 3812608 | 342784 |
| 2013-12-19 19:40:00 | 185.9.159.55 | 902912 | 37888 |
| 2013-12-19 19:40:00 | 185.9.159.6 | 1479936 | 1088256 |
| 2013-12-19 19:40:00 | 185.9.159.61 | 6704384 | 1870080 |
| 2013-12-19 19:40:00 | 185.9.159.64 | 23552 | 24576 |
| 2013-12-19 19:40:00 | 185.9.159.69 | 179712 | 378368 |
| 2013-12-19 19:40:00 | 185.9.159.70 | 143360 | 0 |
| 2013-12-19 19:40:00 | 185.9.159.8 | 5294080 | 1419008 |
| 2013-12-19 19:40:00 | 185.9.159.82 | 1282048 | 55296 |
| 2013-12-19 19:40:00 | 185.9.159.84 | 43008 | 118784 |
| 2013-12-19 19:40:00 | 185.9.159.85 | 192768 | 20992 |
| 2013-12-19 19:40:00 | 185.9.159.86 | 2916096 | 233728 |
| 2013-12-19 19:40:00 | 185.9.159.91 | 12800 | 23296 |
| 2013-12-19 19:40:00 | 185.9.159.92 | 150784 | 0 |
| 2013-12-19 19:40:00 | 37.123.100.107 | 97792 | 381952 |
| 2013-12-19 19:40:00 | 37.123.100.111 | 3215360 | 1841664 |
| 2013-12-19 19:40:00 | 37.123.100.126 | 11776 | 0 |
| 2013-12-19 19:40:00 | 37.123.100.132 | 58880 | 28160 |
| 2013-12-19 19:40:00 | 37.123.100.134 | 6059008 | 2532096 |
| 2013-12-19 19:40:00 | 37.123.100.138 | 155648 | 57856 |
| 2013-12-19 19:40:00 | 37.123.100.154 | 389120 | 2328064 |
| 2013-12-19 19:40:00 | 37.123.100.2 | 0 | 757760 |
| 2013-12-19 19:40:00 | 37.123.100.204 | 112128 | 0 |
| 2013-12-19 19:40:00 | 37.123.100.206 | 13056 | 0 |
| 2013-12-19 19:40:00 | 37.123.100.208 | 5888 | 0 |
| 2013-12-19 19:40:00 | 37.123.100.216 | 99328 | 24576 |
| 2013-12-19 19:40:00 | 37.123.100.217 | 0 | 377344 |
| 2013-12-19 19:40:00 | 37.123.100.218 | 944384 | 48128 |
| 2013-12-19 19:40:00 | 37.123.100.220 | 25088 | 50432 |
| 2013-12-19 19:40:00 | 37.123.100.241 | 34304 | 0 |
| 2013-12-19 19:40:00 | 37.123.100.252 | 39424 | 7168 |
| 2013-12-19 19:40:00 | 37.123.100.30 | 7168 | 0 |
| 2013-12-19 19:40:00 | 37.123.100.41 | 4146432 | 1070080 |
| 2013-12-19 19:40:00 | 37.123.100.42 | 1419520 | 536576 |
| 2013-12-19 19:40:00 | 37.123.100.55 | 11776 | 0 |
| 2013-12-19 19:40:00 | 37.123.101.163 | 26624 | 46336 |
| 2013-12-19 19:40:00 | 37.123.102.183 | 370176 | 760320 |
| 2013-12-19 19:40:00 | 37.123.103.13 | 44032 | 397312 |
| 2013-12-19 19:40:00 | 37.123.103.132 | 378624 | 0 |
| 2013-12-19 19:40:00 | 37.123.103.252 | 880640 | 1169664 |
| 2013-12-19 19:40:00 | 37.123.96.1 | 722944 | 6197248 |
| 2013-12-19 19:40:00 | 37.123.96.116 | 2979584 | 541440 |
| 2013-12-19 19:40:00 | 37.123.96.179 | 66560 | 46080 |
| 2013-12-19 19:40:00 | 37.123.96.181 | 7168 | 0 |
| 2013-12-19 19:40:00 | 37.123.96.184 | 11776 | 0 |
| 2013-12-19 19:40:00 | 37.123.96.21 | 7168 | 0 |
| 2013-12-19 19:40:00 | 37.123.96.229 | 11776 | 0 |
| 2013-12-19 19:40:00 | 37.123.96.236 | 521984 | 39936 |
| 2013-12-19 19:40:00 | 37.123.96.238 | 11776 | 0 |
| 2013-12-19 19:40:00 | 37.123.96.253 | 135936 | 0 |
| 2013-12-19 19:40:00 | 37.123.96.3 | 706304 | 768000 |
| 2013-12-19 19:40:00 | 37.123.96.5 | 830464 | 786432 |
| 2013-12-19 19:40:00 | 37.123.97.130 | 11264 | 0 |
| 2013-12-19 19:40:00 | 37.123.97.131 | 73728 | 27648 |
| 2013-12-19 19:40:00 | 37.123.97.138 | 31488 | 28160 |
| 2013-12-19 19:40:00 | 37.123.97.16 | 117760 | 0 |
| 2013-12-19 19:40:00 | 37.123.97.162 | 415488 | 227584 |
| 2013-12-19 19:40:00 | 37.123.97.163 | 471552 | 12800 |
| 2013-12-19 19:40:00 | 37.123.97.166 | 842496 | 84224 |
| 2013-12-19 19:40:00 | 37.123.97.176 | 13312 | 0 |
| 2013-12-19 19:40:00 | 37.123.97.177 | 22528 | 0 |
| 2013-12-19 19:40:00 | 37.123.97.18 | 440576 | 386304 |
| 2013-12-19 19:40:00 | 37.123.97.182 | 1333504 | 82688 |
| 2013-12-19 19:40:00 | 37.123.97.183 | 0 | 418560 |
| 2013-12-19 19:40:00 | 37.123.97.185 | 1453568 | 39936 |
| 2013-12-19 19:40:00 | 37.123.97.187 | 0 | 13312 |
| 2013-12-19 19:40:00 | 37.123.97.189 | 366848 | 0 |
| 2013-12-19 19:40:00 | 37.123.97.195 | 0 | 384000 |
| 2013-12-19 19:40:00 | 37.123.97.198 | 38144 | 13312 |
| 2013-12-19 19:40:00 | 37.123.97.202 | 21248 | 0 |
| 2013-12-19 19:40:00 | 37.123.97.203 | 1138176 | 3584 |
| 2013-12-19 19:40:00 | 37.123.97.205 | 7168 | 0 |
| 2013-12-19 19:40:00 | 37.123.97.24 | 4480768 | 434176 |
| 2013-12-19 19:40:00 | 37.123.97.26 | 378880 | 44288 |
| 2013-12-19 19:40:00 | 37.123.97.28 | 11776 | 0 |
| 2013-12-19 19:40:00 | 37.123.97.30 | 3543552 | 722944 |
| 2013-12-19 19:40:00 | 37.123.97.4 | 768000 | 706304 |
| 2013-12-19 19:40:00 | 37.123.97.5 | 15907328 | 39412736 |
| 2013-12-19 19:40:00 | 37.123.97.66 | 1205504 | 12800 |
| 2013-12-19 19:40:00 | 37.123.97.70 | 6054912 | 4382208 |
| 2013-12-19 19:40:00 | 37.123.97.71 | 202240 | 35072 |
| 2013-12-19 19:40:00 | 37.123.97.72 | 10496 | 0 |
| 2013-12-19 19:40:00 | 37.123.97.75 | 0 | 7168 |
| 2013-12-19 19:40:00 | 37.123.97.76 | 1741568 | 1948160 |
| 2013-12-19 19:40:00 | 37.123.97.91 | 29184 | 0 |
| 2013-12-19 19:40:00 | 37.123.98.11 | 25856 | 0 |
| 2013-12-19 19:40:00 | 37.123.98.12 | 366848 | 0 |
| 2013-12-19 19:40:00 | 37.123.98.121 | 75008 | 2726400 |
| 2013-12-19 19:40:00 | 37.123.98.122 | 23552 | 14848 |
| 2013-12-19 19:40:00 | 37.123.98.14 | 29696 | 17664 |
| 2013-12-19 19:40:00 | 37.123.98.198 | 11776 | 0 |
| 2013-12-19 19:40:00 | 37.123.98.201 | 273664 | 0 |
| 2013-12-19 19:40:00 | 37.123.98.202 | 94720 | 0 |
| 2013-12-19 19:40:00 | 37.123.98.204 | 363520 | 0 |
| 2013-12-19 19:40:00 | 37.123.98.238 | 7168 | 0 |
| 2013-12-19 19:40:00 | 37.123.98.7 | 23552 | 368640 |
| 2013-12-19 19:40:00 | 37.123.99.143 | 26624 | 7168 |
| 2013-12-19 19:40:00 | 37.123.99.195 | 67328 | 81664 |
| 2013-12-19 19:40:00 | 37.123.99.197 | 14147840 | 771584 |
| 2013-12-19 19:40:00 | 37.123.99.204 | 1362432 | 128256 |
| 2013-12-19 19:40:00 | 37.123.99.211 | 1505024 | 7168 |
| 2013-12-19 19:40:00 | 37.123.99.212 | 840960 | 344832 |
| 2013-12-19 19:40:00 | 37.123.99.213 | 154368 | 5632 |
| 2013-12-19 19:41:00 | 178.20.224.10 | 11776 | 174848 |
| 2013-12-19 19:41:00 | 178.20.224.12 | 13312 | 0 |
| 2013-12-19 19:41:00 | 178.20.224.14 | 7168 | 0 |
| 2013-12-19 19:41:00 | 178.20.224.15 | 4256000 | 477696 |
| 2013-12-19 19:41:00 | 178.20.224.153 | 7168 | 0 |
| 2013-12-19 19:41:00 | 178.20.224.155 | 905728 | 407040 |
| 2013-12-19 19:41:00 | 178.20.224.16 | 0 | 393216 |
| 2013-12-19 19:41:00 | 178.20.224.19 | 111104 | 0 |
| 2013-12-19 19:41:00 | 178.20.224.203 | 4990208 | 27648 |
| 2013-12-19 19:41:00 | 178.20.224.204 | 15360 | 0 |
| 2013-12-19 19:41:00 | 178.20.224.205 | 7424 | 0 |
| 2013-12-19 19:41:00 | 178.20.224.207 | 0 | 193536 |
| 2013-12-19 19:41:00 | 178.20.224.210 | 40192 | 0 |
| 2013-12-19 19:41:00 | 178.20.224.211 | 0 | 7168 |
| 2013-12-19 19:41:00 | 178.20.224.218 | 97280 | 79360 |
| 2013-12-19 19:41:00 | 178.20.224.219 | 23552 | 287744 |
| 2013-12-19 19:41:00 | 178.20.224.22 | 880128 | 0 |
| 2013-12-19 19:41:00 | 178.20.224.223 | 0 | 384000 |
| 2013-12-19 19:41:00 | 178.20.224.24 | 1245952 | 27904 |
| 2013-12-19 19:41:00 | 178.20.224.26 | 47360 | 81920 |
| 2013-12-19 19:41:00 | 178.20.224.32 | 454400 | 0 |
| 2013-12-19 19:41:00 | 178.20.224.34 | 43008 | 14336 |
| 2013-12-19 19:41:00 | 178.20.225.163 | 111104 | 384000 |
| 2013-12-19 19:41:00 | 178.20.225.195 | 362496 | 141056 |
| 2013-12-19 19:41:00 | 178.20.225.197 | 758784 | 391168 |
| 2013-12-19 19:41:00 | 178.20.225.199 | 1351936 | 6656 |
| 2013-12-19 19:41:00 | 178.20.225.200 | 35328 | 0 |
| 2013-12-19 19:41:00 | 178.20.225.204 | 1622528 | 18688 |
| 2013-12-19 19:41:00 | 178.20.225.205 | 1131008 | 13312 |
| 2013-12-19 19:41:00 | 178.20.225.206 | 13312 | 0 |
| 2013-12-19 19:41:00 | 178.20.225.254 | 13824 | 0 |
| 2013-12-19 19:41:00 | 178.20.225.82 | 11776 | 0 |
| 2013-12-19 19:41:00 | 178.20.225.90 | 22016 | 0 |
| 2013-12-19 19:41:00 | 178.20.225.91 | 11776 | 0 |
| 2013-12-19 19:41:00 | 178.20.226.121 | 11776 | 0 |
| 2013-12-19 19:41:00 | 178.20.226.124 | 0 | 5376 |
| 2013-12-19 19:41:00 | 178.20.226.126 | 533504 | 41728 |
| 2013-12-19 19:41:00 | 178.20.226.131 | 452352 | 0 |
| 2013-12-19 19:41:00 | 178.20.226.136 | 13312 | 0 |
| 2013-12-19 19:41:00 | 178.20.226.14 | 1011968 | 83456 |
| 2013-12-19 19:41:00 | 178.20.226.140 | 1799424 | 562688 |
| 2013-12-19 19:41:00 | 178.20.226.142 | 30720 | 0 |
| 2013-12-19 19:41:00 | 178.20.226.144 | 1964288 | 631808 |
| 2013-12-19 19:41:00 | 178.20.226.145 | 416512 | 67840 |
| 2013-12-19 19:41:00 | 178.20.226.146 | 23808 | 0 |
| 2013-12-19 19:41:00 | 178.20.226.149 | 841472 | 52224 |
| 2013-12-19 19:41:00 | 178.20.226.150 | 159744 | 0 |
| 2013-12-19 19:41:00 | 178.20.226.16 | 13312 | 0 |
| 2013-12-19 19:41:00 | 178.20.226.186 | 11776 | 0 |
| 2013-12-19 19:41:00 | 178.20.226.187 | 81152 | 18944 |
| 2013-12-19 19:41:00 | 178.20.226.188 | 73216 | 30976 |
| 2013-12-19 19:41:00 | 178.20.226.2 | 7168 | 0 |
| 2013-12-19 19:41:00 | 178.20.226.200 | 18944 | 24576 |
| 2013-12-19 19:41:00 | 178.20.226.233 | 111104 | 0 |
| 2013-12-19 19:41:00 | 178.20.226.68 | 794368 | 7168 |
| 2013-12-19 19:41:00 | 178.20.227.114 | 3888896 | 2221056 |
| 2013-12-19 19:41:00 | 178.20.227.120 | 23552 | 0 |
| 2013-12-19 19:41:00 | 178.20.227.168 | 7168 | 0 |
| 2013-12-19 19:41:00 | 178.20.227.169 | 300032 | 0 |
| 2013-12-19 19:41:00 | 178.20.227.170 | 483072 | 18176 |
| 2013-12-19 19:41:00 | 178.20.227.173 | 41472 | 22016 |
| 2013-12-19 19:41:00 | 178.20.227.179 | 20992 | 324608 |
| 2013-12-19 19:41:00 | 178.20.227.180 | 13312 | 0 |
| 2013-12-19 19:41:00 | 178.20.227.184 | 13312 | 0 |
| 2013-12-19 19:41:00 | 178.20.227.188 | 26624 | 0 |
| 2013-12-19 19:41:00 | 178.20.227.192 | 7168 | 0 |
| 2013-12-19 19:41:00 | 178.20.227.224 | 0 | 16640 |
| 2013-12-19 19:41:00 | 178.20.227.227 | 31232 | 0 |
| 2013-12-19 19:41:00 | 178.20.227.244 | 378368 | 0 |
| 2013-12-19 19:41:00 | 178.20.227.245 | 429312 | 1939968 |
| 2013-12-19 19:41:00 | 178.20.227.252 | 67328 | 13312 |
| 2013-12-19 19:41:00 | 178.20.227.254 | 366848 | 0 |
| 2013-12-19 19:41:00 | 178.20.227.32 | 108800 | 0 |
| 2013-12-19 19:41:00 | 178.20.227.41 | 474624 | 45568 |
| 2013-12-19 19:41:00 | 178.20.227.43 | 1126144 | 853760 |
| 2013-12-19 19:41:00 | 178.20.227.48 | 424448 | 19456 |
| 2013-12-19 19:41:00 | 178.20.227.71 | 124160 | 7614208 |
| 2013-12-19 19:41:00 | 178.20.227.72 | 1159936 | 1559808 |
| 2013-12-19 19:41:00 | 178.20.227.73 | 605440 | 28672 |
| 2013-12-19 19:41:00 | 178.20.227.75 | 513792 | 24320 |
| 2013-12-19 19:41:00 | 178.20.227.76 | 273920 | 5922816 |
| 2013-12-19 19:41:00 | 178.20.227.77 | 2757632 | 199424 |
| 2013-12-19 19:41:00 | 178.20.227.78 | 5031680 | 154368 |
| 2013-12-19 19:41:00 | 178.20.227.85 | 11776 | 175616 |
| 2013-12-19 19:41:00 | 178.20.227.86 | 635136 | 1130240 |
| 2013-12-19 19:41:00 | 178.20.227.90 | 13386496 | 236288 |
| 2013-12-19 19:41:00 | 178.20.228.118 | 1192960 | 13312 |
| 2013-12-19 19:41:00 | 178.20.228.120 | 5914368 | 41472000 |
| 2013-12-19 19:41:00 | 178.20.228.121 | 383488 | 0 |
| 2013-12-19 19:41:00 | 178.20.228.204 | 18432 | 0 |
| 2013-12-19 19:41:00 | 178.20.228.224 | 10833408 | 9145856 |
| 2013-12-19 19:41:00 | 178.20.228.225 | 1874688 | 2653440 |
| 2013-12-19 19:41:00 | 178.20.228.226 | 15872 | 0 |
| 2013-12-19 19:41:00 | 178.20.228.30 | 12288 | 0 |
| 2013-12-19 19:41:00 | 178.20.228.31 | 0 | 8704 |
| 2013-12-19 19:41:00 | 178.20.228.32 | 7168 | 0 |
| 2013-12-19 19:41:00 | 178.20.228.34 | 140800 | 37376 |
| 2013-12-19 19:41:00 | 178.20.228.35 | 7424 | 0 |
| 2013-12-19 19:41:00 | 178.20.228.37 | 3819008 | 74496 |
| 2013-12-19 19:41:00 | 178.20.228.43 | 1680896 | 16289024 |
| 2013-12-19 19:41:00 | 178.20.228.52 | 18432 | 0 |
| 2013-12-19 19:41:00 | 178.20.228.56 | 777472 | 2410752 |
| 2013-12-19 19:41:00 | 178.20.228.57 | 1591808 | 12499456 |
| 2013-12-19 19:41:00 | 178.20.228.69 | 7168 | 0 |
| 2013-12-19 19:41:00 | 178.20.228.73 | 2487296 | 786944 |
| 2013-12-19 19:41:00 | 178.20.228.74 | 72960 | 0 |
| 2013-12-19 19:41:00 | 178.20.228.75 | 27710208 | 711680 |
| 2013-12-19 19:41:00 | 178.20.228.87 | 14336 | 0 |
| 2013-12-19 19:41:00 | 178.20.228.88 | 190720 | 60672 |
| 2013-12-19 19:41:00 | 178.20.229.217 | 0 | 11776 |
| 2013-12-19 19:41:00 | 178.20.230.133 | 7168 | 0 |
| 2013-12-19 19:41:00 | 178.20.230.137 | 748800 | 0 |
| 2013-12-19 19:41:00 | 178.20.230.152 | 15360 | 13312 |
| 2013-12-19 19:41:00 | 178.20.230.172 | 45056 | 523264 |
| 2013-12-19 19:41:00 | 178.20.230.174 | 370176 | 0 |
| 2013-12-19 19:41:00 | 178.20.230.180 | 0 | 1198080 |
| 2013-12-19 19:41:00 | 178.20.230.189 | 0 | 19456 |
| 2013-12-19 19:41:00 | 178.20.230.190 | 829184 | 1196288 |
| 2013-12-19 19:41:00 | 178.20.230.199 | 870400 | 29184 |
| 2013-12-19 19:41:00 | 178.20.231.10 | 13312 | 0 |
| 2013-12-19 19:41:00 | 178.20.231.100 | 70144 | 65024 |
| 2013-12-19 19:41:00 | 178.20.231.101 | 7168 | 0 |
| 2013-12-19 19:41:00 | 178.20.231.102 | 16472320 | 17994752 |
| 2013-12-19 19:41:00 | 178.20.231.13 | 1222656 | 1543936 |
| 2013-12-19 19:41:00 | 178.20.231.14 | 109056 | 16640 |
| 2013-12-19 19:41:00 | 178.20.231.149 | 26624 | 0 |
| 2013-12-19 19:41:00 | 178.20.231.154 | 37120 | 0 |
| 2013-12-19 19:41:00 | 178.20.231.155 | 4780544 | 462848 |
| 2013-12-19 19:41:00 | 178.20.231.158 | 108032 | 22528 |
| 2013-12-19 19:41:00 | 178.20.231.159 | 260096 | 30208 |
| 2013-12-19 19:41:00 | 178.20.231.168 | 12288 | 7168 |
| 2013-12-19 19:41:00 | 178.20.231.17 | 52992 | 0 |
| 2013-12-19 19:41:00 | 178.20.231.175 | 535040 | 409600 |
| 2013-12-19 19:41:00 | 178.20.231.176 | 22016 | 0 |
| 2013-12-19 19:41:00 | 178.20.231.178 | 473344 | 69632 |
| 2013-12-19 19:41:00 | 178.20.231.18 | 433152 | 403712 |
| 2013-12-19 19:41:00 | 178.20.231.19 | 91392 | 771072 |
| 2013-12-19 19:41:00 | 178.20.231.20 | 0 | 18432 |
| 2013-12-19 19:41:00 | 178.20.231.200 | 13312 | 0 |
| 2013-12-19 19:41:00 | 178.20.231.205 | 13312 | 0 |
| 2013-12-19 19:41:00 | 178.20.231.210 | 1353984 | 374528 |
| 2013-12-19 19:41:00 | 178.20.231.211 | 231936 | 346368 |
| 2013-12-19 19:41:00 | 178.20.231.213 | 42496 | 768000 |
| 2013-12-19 19:41:00 | 178.20.231.28 | 34816 | 0 |
| 2013-12-19 19:41:00 | 178.20.231.33 | 104704 | 0 |
| 2013-12-19 19:41:00 | 178.20.231.4 | 794880 | 2123264 |
| 2013-12-19 19:41:00 | 178.20.231.44 | 7168 | 0 |
| 2013-12-19 19:41:00 | 178.20.231.48 | 588800 | 1977344 |
| 2013-12-19 19:41:00 | 178.20.231.49 | 884736 | 1153024 |
| 2013-12-19 19:41:00 | 178.20.231.50 | 876544 | 2328064 |
| 2013-12-19 19:41:00 | 178.20.231.51 | 13312 | 0 |
| 2013-12-19 19:41:00 | 178.20.231.52 | 15872 | 0 |
| 2013-12-19 19:41:00 | 178.20.231.61 | 13312 | 0 |
| 2013-12-19 19:41:00 | 178.20.231.64 | 62464 | 392704 |
| 2013-12-19 19:41:00 | 178.20.231.66 | 15360 | 0 |
| 2013-12-19 19:41:00 | 178.20.231.76 | 73472 | 121088 |
| 2013-12-19 19:41:00 | 178.20.231.77 | 797696 | 26624 |
| 2013-12-19 19:41:00 | 178.20.231.80 | 95488 | 0 |
| 2013-12-19 19:41:00 | 178.20.231.82 | 12997632 | 18587648 |
| 2013-12-19 19:41:00 | 178.20.231.84 | 14592 | 0 |
| 2013-12-19 19:41:00 | 178.20.231.86 | 11913984 | 11223552 |
| 2013-12-19 19:41:00 | 178.20.231.89 | 0 | 30208 |
| 2013-12-19 19:41:00 | 178.20.231.90 | 109568 | 200960 |
| 2013-12-19 19:41:00 | 178.20.231.92 | 30208 | 0 |
| 2013-12-19 19:41:00 | 178.20.231.93 | 41472 | 15616 |
| 2013-12-19 19:41:00 | 178.20.231.94 | 8704 | 373760 |
| 2013-12-19 19:41:00 | 178.20.231.95 | 6991104 | 10400512 |
| 2013-12-19 19:41:00 | 178.20.231.99 | 15360 | 0 |
| 2013-12-19 19:41:00 | 185.9.156.101 | 57344 | 0 |
| 2013-12-19 19:41:00 | 185.9.156.103 | 0 | 28672 |
| 2013-12-19 19:41:00 | 185.9.156.107 | 353280 | 419840 |
| 2013-12-19 19:41:00 | 185.9.156.110 | 0 | 448512 |
| 2013-12-19 19:41:00 | 185.9.156.113 | 91136 | 0 |
| 2013-12-19 19:41:00 | 185.9.156.115 | 0 | 1536000 |
| 2013-12-19 19:41:00 | 185.9.156.127 | 4184064 | 272384 |
| 2013-12-19 19:41:00 | 185.9.156.131 | 47104 | 0 |
| 2013-12-19 19:41:00 | 185.9.156.134 | 6643712 | 47104 |
| 2013-12-19 19:41:00 | 185.9.156.135 | 1538048 | 56320 |
| 2013-12-19 19:41:00 | 185.9.156.136 | 66944000 | 71516160 |
| 2013-12-19 19:41:00 | 185.9.156.141 | 6311936 | 0 |
| 2013-12-19 19:41:00 | 185.9.156.19 | 0 | 1536000 |
| 2013-12-19 19:41:00 | 185.9.156.192 | 83968 | 93184 |
| 2013-12-19 19:41:00 | 185.9.156.194 | 0 | 222208 |
| 2013-12-19 19:41:00 | 185.9.156.242 | 6953984 | 3055616 |
| 2013-12-19 19:41:00 | 185.9.156.25 | 540672 | 7190528 |
| 2013-12-19 19:41:00 | 185.9.156.252 | 0 | 3072000 |
| 2013-12-19 19:41:00 | 185.9.156.3 | 0 | 47104 |
| 2013-12-19 19:41:00 | 185.9.156.35 | 998400 | 28672 |
| 2013-12-19 19:41:00 | 185.9.156.37 | 57344 | 102400 |
| 2013-12-19 19:41:00 | 185.9.156.41 | 17531904 | 392192 |
| 2013-12-19 19:41:00 | 185.9.156.45 | 1985536 | 209920 |
| 2013-12-19 19:41:00 | 185.9.156.49 | 337920 | 0 |
| 2013-12-19 19:41:00 | 185.9.156.5 | 5404672 | 9517056 |
| 2013-12-19 19:41:00 | 185.9.156.51 | 47104 | 0 |
| 2013-12-19 19:41:00 | 185.9.156.53 | 0 | 51200 |
| 2013-12-19 19:41:00 | 185.9.156.55 | 0 | 48128 |
| 2013-12-19 19:41:00 | 185.9.156.75 | 1688576 | 132096 |
| 2013-12-19 19:41:00 | 185.9.156.77 | 47104 | 0 |
| 2013-12-19 19:41:00 | 185.9.157.125 | 66560 | 64000 |
| 2013-12-19 19:41:00 | 185.9.157.127 | 21504 | 0 |
| 2013-12-19 19:41:00 | 185.9.157.135 | 372992 | 7168 |
| 2013-12-19 19:41:00 | 185.9.157.165 | 380160 | 20992 |
| 2013-12-19 19:41:00 | 185.9.157.175 | 1536768 | 22784 |
| 2013-12-19 19:41:00 | 185.9.157.178 | 3128832 | 367872 |
| 2013-12-19 19:41:00 | 185.9.157.185 | 386560 | 7168 |
| 2013-12-19 19:41:00 | 185.9.157.186 | 467712 | 90112 |
| 2013-12-19 19:41:00 | 185.9.157.2 | 457984 | 20736 |
| 2013-12-19 19:41:00 | 185.9.157.234 | 35328 | 0 |
| 2013-12-19 19:41:00 | 185.9.157.238 | 11776 | 0 |
| 2013-12-19 19:41:00 | 185.9.157.246 | 3417088 | 171520 |
| 2013-12-19 19:41:00 | 185.9.157.250 | 382464 | 0 |
| 2013-12-19 19:41:00 | 185.9.159.103 | 370176 | 0 |
| 2013-12-19 19:41:00 | 185.9.159.104 | 461312 | 15360 |
| 2013-12-19 19:41:00 | 185.9.159.11 | 6213888 | 36278272 |
| 2013-12-19 19:41:00 | 185.9.159.114 | 366592 | 0 |
| 2013-12-19 19:41:00 | 185.9.159.119 | 349696 | 399872 |
| 2013-12-19 19:41:00 | 185.9.159.12 | 740352 | 0 |
| 2013-12-19 19:41:00 | 185.9.159.121 | 83200 | 7168 |
| 2013-12-19 19:41:00 | 185.9.159.124 | 2146304 | 1224704 |
| 2013-12-19 19:41:00 | 185.9.159.13 | 11776 | 0 |
| 2013-12-19 19:41:00 | 185.9.159.14 | 817152 | 604928 |
| 2013-12-19 19:41:00 | 185.9.159.148 | 102400 | 55296 |
| 2013-12-19 19:41:00 | 185.9.159.154 | 48896 | 16128 |
| 2013-12-19 19:41:00 | 185.9.159.155 | 0 | 66048 |
| 2013-12-19 19:41:00 | 185.9.159.158 | 262400 | 119552 |
| 2013-12-19 19:41:00 | 185.9.159.16 | 15872 | 80640 |
| 2013-12-19 19:41:00 | 185.9.159.160 | 33792 | 150016 |
| 2013-12-19 19:41:00 | 185.9.159.167 | 46848 | 7168 |
| 2013-12-19 19:41:00 | 185.9.159.168 | 46336 | 81664 |
| 2013-12-19 19:41:00 | 185.9.159.169 | 1959424 | 23552 |
| 2013-12-19 19:41:00 | 185.9.159.17 | 26624 | 96256 |
| 2013-12-19 19:41:00 | 185.9.159.172 | 1687296 | 3053568 |
| 2013-12-19 19:41:00 | 185.9.159.176 | 86016 | 0 |
| 2013-12-19 19:41:00 | 185.9.159.182 | 20480 | 0 |
| 2013-12-19 19:41:00 | 185.9.159.189 | 403456 | 395776 |
| 2013-12-19 19:41:00 | 185.9.159.200 | 375808 | 0 |
| 2013-12-19 19:41:00 | 185.9.159.206 | 40327168 | 892416 |
| 2013-12-19 19:41:00 | 185.9.159.208 | 1077760 | 1605376 |
| 2013-12-19 19:41:00 | 185.9.159.21 | 0 | 12288 |
| 2013-12-19 19:41:00 | 185.9.159.211 | 778496 | 445440 |
| 2013-12-19 19:41:00 | 185.9.159.212 | 3466496 | 5342464 |
| 2013-12-19 19:41:00 | 185.9.159.213 | 26624 | 13312 |
| 2013-12-19 19:41:00 | 185.9.159.215 | 9799424 | 15847936 |
| 2013-12-19 19:41:00 | 185.9.159.223 | 1611776 | 1913344 |
| 2013-12-19 19:41:00 | 185.9.159.227 | 11531776 | 298752 |
| 2013-12-19 19:41:00 | 185.9.159.23 | 3840 | 0 |
| 2013-12-19 19:41:00 | 185.9.159.232 | 12695552 | 42562048 |
| 2013-12-19 19:41:00 | 185.9.159.233 | 71381760 | 6428928 |
| 2013-12-19 19:41:00 | 185.9.159.234 | 3874048 | 9508096 |
| 2013-12-19 19:41:00 | 185.9.159.240 | 1161216 | 334848 |
| 2013-12-19 19:41:00 | 185.9.159.243 | 1408768 | 14080 |
| 2013-12-19 19:41:00 | 185.9.159.251 | 20736 | 11520 |
| 2013-12-19 19:41:00 | 185.9.159.254 | 449792 | 396288 |
| 2013-12-19 19:41:00 | 185.9.159.28 | 18944 | 0 |
| 2013-12-19 19:41:00 | 185.9.159.31 | 479232 | 18432 |
| 2013-12-19 19:41:00 | 185.9.159.33 | 751872 | 0 |
| 2013-12-19 19:41:00 | 185.9.159.37 | 1075968 | 22528 |
| 2013-12-19 19:41:00 | 185.9.159.41 | 18432 | 0 |
| 2013-12-19 19:41:00 | 185.9.159.42 | 864768 | 6201088 |
| 2013-12-19 19:41:00 | 185.9.159.47 | 11776 | 0 |
| 2013-12-19 19:41:00 | 185.9.159.49 | 23552 | 0 |
| 2013-12-19 19:41:00 | 185.9.159.52 | 1970176 | 11776 |
| 2013-12-19 19:41:00 | 185.9.159.55 | 94464 | 90880 |
| 2013-12-19 19:41:00 | 185.9.159.6 | 1689600 | 1355776 |
| 2013-12-19 19:41:00 | 185.9.159.61 | 5630720 | 1462016 |
| 2013-12-19 19:41:00 | 185.9.159.64 | 40960 | 7168 |
| 2013-12-19 19:41:00 | 185.9.159.69 | 14336 | 371200 |
| 2013-12-19 19:41:00 | 185.9.159.70 | 1219072 | 162816 |
| 2013-12-19 19:41:00 | 185.9.159.8 | 3602688 | 1746688 |
| 2013-12-19 19:41:00 | 185.9.159.80 | 0 | 12032 |
| 2013-12-19 19:41:00 | 185.9.159.82 | 1175040 | 108544 |
| 2013-12-19 19:41:00 | 185.9.159.84 | 6656 | 0 |
| 2013-12-19 19:41:00 | 185.9.159.85 | 515072 | 356352 |
| 2013-12-19 19:41:00 | 185.9.159.86 | 2411520 | 48128 |
| 2013-12-19 19:41:00 | 185.9.159.91 | 80128 | 42496 |
| 2013-12-19 19:41:00 | 37.123.100.107 | 225024 | 23552 |
| 2013-12-19 19:41:00 | 37.123.100.111 | 2104832 | 809472 |
| 2013-12-19 19:41:00 | 37.123.100.116 | 408064 | 96768 |
| 2013-12-19 19:41:00 | 37.123.100.126 | 23552 | 28160 |
| 2013-12-19 19:41:00 | 37.123.100.132 | 113664 | 19456 |
| 2013-12-19 19:41:00 | 37.123.100.134 | 5934592 | 2974464 |
| 2013-12-19 19:41:00 | 37.123.100.138 | 806144 | 81920 |
| 2013-12-19 19:41:00 | 37.123.100.154 | 20480 | 384000 |
| 2013-12-19 19:41:00 | 37.123.100.2 | 763136 | 642048 |
| 2013-12-19 19:41:00 | 37.123.100.204 | 136448 | 0 |
| 2013-12-19 19:41:00 | 37.123.100.208 | 11776 | 0 |
| 2013-12-19 19:41:00 | 37.123.100.216 | 357888 | 11776 |
| 2013-12-19 19:41:00 | 37.123.100.217 | 15360 | 0 |
| 2013-12-19 19:41:00 | 37.123.100.218 | 1296384 | 853760 |
| 2013-12-19 19:41:00 | 37.123.100.220 | 190464 | 5632 |
| 2013-12-19 19:41:00 | 37.123.100.242 | 90112 | 0 |
| 2013-12-19 19:41:00 | 37.123.100.252 | 22528 | 0 |
| 2013-12-19 19:41:00 | 37.123.100.254 | 381952 | 0 |
| 2013-12-19 19:41:00 | 37.123.100.27 | 77824 | 1575424 |
| 2013-12-19 19:41:00 | 37.123.100.30 | 347648 | 0 |
| 2013-12-19 19:41:00 | 37.123.100.41 | 4686592 | 1424128 |
| 2013-12-19 19:41:00 | 37.123.100.42 | 1922304 | 318720 |
| 2013-12-19 19:41:00 | 37.123.100.55 | 0 | 34816 |
| 2013-12-19 19:41:00 | 37.123.101.163 | 42496 | 787712 |
| 2013-12-19 19:41:00 | 37.123.102.183 | 26112 | 378880 |
| 2013-12-19 19:41:00 | 37.123.102.254 | 18944 | 0 |
| 2013-12-19 19:41:00 | 37.123.103.13 | 29184 | 0 |
| 2013-12-19 19:41:00 | 37.123.103.132 | 13312 | 0 |
| 2013-12-19 19:41:00 | 37.123.103.15 | 32768 | 0 |
| 2013-12-19 19:41:00 | 37.123.103.252 | 130560 | 920832 |
| 2013-12-19 19:41:00 | 37.123.103.43 | 404992 | 1564672 |
| 2013-12-19 19:41:00 | 37.123.96.1 | 311552 | 6151168 |
| 2013-12-19 19:41:00 | 37.123.96.116 | 1401088 | 1746688 |
| 2013-12-19 19:41:00 | 37.123.96.179 | 64512 | 0 |
| 2013-12-19 19:41:00 | 37.123.96.181 | 11776 | 99840 |
| 2013-12-19 19:41:00 | 37.123.96.21 | 52736 | 721408 |
| 2013-12-19 19:41:00 | 37.123.96.227 | 0 | 175360 |
| 2013-12-19 19:41:00 | 37.123.96.235 | 7168 | 0 |
| 2013-12-19 19:41:00 | 37.123.96.236 | 741376 | 14336 |
| 2013-12-19 19:41:00 | 37.123.96.248 | 22016 | 371712 |
| 2013-12-19 19:41:00 | 37.123.96.253 | 29696 | 16896 |
| 2013-12-19 19:41:00 | 37.123.96.3 | 45568 | 153600 |
| 2013-12-19 19:41:00 | 37.123.96.35 | 0 | 11264 |
| 2013-12-19 19:41:00 | 37.123.96.39 | 11776 | 0 |
| 2013-12-19 19:41:00 | 37.123.96.5 | 81920 | 420864 |
| 2013-12-19 19:41:00 | 37.123.96.9 | 8704 | 0 |
| 2013-12-19 19:41:00 | 37.123.97.1 | 0 | 14336 |
| 2013-12-19 19:41:00 | 37.123.97.129 | 0 | 31488 |
| 2013-12-19 19:41:00 | 37.123.97.130 | 9216 | 0 |
| 2013-12-19 19:41:00 | 37.123.97.131 | 73728 | 9216 |
| 2013-12-19 19:41:00 | 37.123.97.138 | 110336 | 20992 |
| 2013-12-19 19:41:00 | 37.123.97.162 | 1159680 | 11264 |
| 2013-12-19 19:41:00 | 37.123.97.163 | 446976 | 7168 |
| 2013-12-19 19:41:00 | 37.123.97.166 | 840448 | 156672 |
| 2013-12-19 19:41:00 | 37.123.97.172 | 0 | 397312 |
| 2013-12-19 19:41:00 | 37.123.97.176 | 19456 | 359680 |
| 2013-12-19 19:41:00 | 37.123.97.18 | 56320 | 370176 |
| 2013-12-19 19:41:00 | 37.123.97.182 | 426496 | 123904 |
| 2013-12-19 19:41:00 | 37.123.97.183 | 284928 | 0 |
| 2013-12-19 19:41:00 | 37.123.97.185 | 820480 | 65280 |
| 2013-12-19 19:41:00 | 37.123.97.194 | 367616 | 0 |
| 2013-12-19 19:41:00 | 37.123.97.195 | 0 | 7168 |
| 2013-12-19 19:41:00 | 37.123.97.196 | 85760 | 0 |
| 2013-12-19 19:41:00 | 37.123.97.198 | 135680 | 0 |
| 2013-12-19 19:41:00 | 37.123.97.199 | 7168 | 0 |
| 2013-12-19 19:41:00 | 37.123.97.202 | 384000 | 7168 |
| 2013-12-19 19:41:00 | 37.123.97.203 | 18944 | 417536 |
| 2013-12-19 19:41:00 | 37.123.97.205 | 370176 | 0 |
| 2013-12-19 19:41:00 | 37.123.97.206 | 11776 | 0 |
| 2013-12-19 19:41:00 | 37.123.97.207 | 376832 | 0 |
| 2013-12-19 19:41:00 | 37.123.97.24 | 5796864 | 400384 |
| 2013-12-19 19:41:00 | 37.123.97.26 | 61184 | 18944 |
| 2013-12-19 19:41:00 | 37.123.97.30 | 4436992 | 311552 |
| 2013-12-19 19:41:00 | 37.123.97.4 | 135936 | 45568 |
| 2013-12-19 19:41:00 | 37.123.97.5 | 33297664 | 34047488 |
| 2013-12-19 19:41:00 | 37.123.97.66 | 922624 | 426496 |
| 2013-12-19 19:41:00 | 37.123.97.70 | 6769664 | 4920832 |
| 2013-12-19 19:41:00 | 37.123.97.71 | 2013952 | 1150976 |
| 2013-12-19 19:41:00 | 37.123.97.76 | 1693440 | 5014528 |
| 2013-12-19 19:41:00 | 37.123.98.11 | 366592 | 0 |
| 2013-12-19 19:41:00 | 37.123.98.115 | 13312 | 0 |
| 2013-12-19 19:41:00 | 37.123.98.121 | 645120 | 830976 |
| 2013-12-19 19:41:00 | 37.123.98.122 | 183040 | 776704 |
| 2013-12-19 19:41:00 | 37.123.98.14 | 13568 | 23040 |
| 2013-12-19 19:41:00 | 37.123.98.194 | 0 | 384000 |
| 2013-12-19 19:41:00 | 37.123.98.198 | 27136 | 0 |
| 2013-12-19 19:41:00 | 37.123.98.200 | 11776 | 0 |
| 2013-12-19 19:41:00 | 37.123.98.203 | 0 | 7168 |
| 2013-12-19 19:41:00 | 37.123.98.204 | 370176 | 0 |
| 2013-12-19 19:41:00 | 37.123.98.205 | 11776 | 0 |
| 2013-12-19 19:41:00 | 37.123.98.207 | 7168 | 11776 |
| 2013-12-19 19:41:00 | 37.123.98.239 | 37376 | 0 |
| 2013-12-19 19:41:00 | 37.123.98.7 | 1027840 | 1147648 |
| 2013-12-19 19:41:00 | 37.123.98.9 | 0 | 387328 |
| 2013-12-19 19:41:00 | 37.123.99.143 | 39936 | 0 |
| 2013-12-19 19:41:00 | 37.123.99.195 | 28928 | 25856 |
| 2013-12-19 19:41:00 | 37.123.99.197 | 3867392 | 483584 |
| 2013-12-19 19:41:00 | 37.123.99.204 | 2917120 | 676096 |
| 2013-12-19 19:41:00 | 37.123.99.207 | 7168 | 0 |
| 2013-12-19 19:41:00 | 37.123.99.211 | 1881344 | 49408 |
| 2013-12-19 19:41:00 | 37.123.99.212 | 26112 | 493568 |
| 2013-12-19 19:41:00 | 37.123.99.213 | 234752 | 11776 |
+---------------------+----------------+----------+-----------+
719 rows in set (4 min 53.08 sec)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i get a very small piece
empty result
mysql> SELECT DATE_SUB(timestampfromfile, INTERVAL SECOND(timestampfromfile) SECOND) AS `timestampfromfile` , `srcip` AS ip_addr, `octets`, 'out' AS `direction` FROM mytable a INNER JOIN ipAdresleri i ON i.ip=a.`srcip` WHERE timestampfromfile >= DATE_SUB(NOW(), INTERVAL 60+SECOND(NOW()) SECOND);
Empty set (2.73 sec)
empty result
ASKER
thank you so much
What does this return:
Open in new window
Depending on what the keys are for the tables, it may behoove you to put the JOIN for ip address inside the derived query. In other words, how does this compare to the above performance-wise:
Open in new window
Keep in mind as you troubleshoot this that a minute may be too tight a window to run this update. You may need to move to an hour, or fall back to day but tweak index enough to make the daily run performant. The difficulty you will have is that as you are running the query, you have more records inserting. In addition, it may be difficult to get the timing to capture the right records in the correct minute.
Kevin