主页 / 问题 / 1114781
Accepted
BERTOLDO
Asked:2020-04-24 02:20:42 +0000 UTC2020-04-24 02:20:42 +0000 UTC

确定仅使用 AWK 从中获取信息最多的 10 个 Internet 服务器

  • 772

有一个代理服务器日志文件，需要确定10台服务器（$7字段中的服务器名称）从中接收到的信息量最大（$5字段中的信息量）

服务器名称有时会重复，因此您需要确定每个服务器的信息总量，然后显示信息最多的 10 个服务器。

代理服务器的log-a文件条目的结构：

$1 - 请求时间；

$5 是以字节为单位传输的数据量；

$6 - 请求类型；

$7 - 请求的资源；

$8 - 用户名；

日志文件中的片段：

965332284.687 126107 10.1.6.0 TCP_MISS/503 1061 GET ftp://ftp.ruhr-uni-bochum.de/.subdisc3/local/winnt/2000/fixes/usa/sp1/sp1network.exe alex DIRECT/ftp.ruhr-uni-bochum.de -
965332324.957 126090 10.1.6.0 TCP_MISS/503 1033 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -
965332336.987 129098 10.1.6.0 TCP_MISS/503 1033 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -
965332348.015 239306 10.1.6.0 TCP_MISS/504 1066 GET http://mschus.www.conxion.com/download/win2000platform/sp/sp1/nt5/en-us/sp1network.exe alex DIRECT/mschus.www.conxion.com -
965332373.817 123096 10.1.6.0 TCP_MISS/503 1033 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -
965332377.837 129099 10.1.6.0 TCP_MISS/503 1033 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -
965332411.365 237443 10.1.6.0 TCP_MISS/504 1048 GET ftp://ftp.darmstadt.gmd.de/pub/pc/Win2k/microsoft/fixes/sp1/en/sp1network.exe alex DIRECT/ftp.darmstadt.gmd.de -
965332439.117 150093 10.1.6.0 TCP_MISS/503 1065 GET http://mschus.www.conxion.com/download/win2000platform/sp/sp1/nt5/en-us/sp1network.exe alex DIRECT/mschus.www.conxion.com -
965332470.987 132093 10.1.6.0 TCP_MISS/503 1065 GET http://mschus.www.conxion.com/download/win2000platform/sp/sp1/nt5/en-us/sp1network.exe alex DIRECT/mschus.www.conxion.com -
965332472.967 132089 10.1.6.0 TCP_MISS/503 1065 GET http://mschus.www.conxion.com/download/win2000platform/sp/sp1/nt5/en-us/sp1network.exe alex DIRECT/mschus.www.conxion.com -
965332483.137 219058 10.1.6.0 TCP_MISS/503 1033 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -
965332490.137 192090 10.1.6.0 TCP_MISS/503 1065 GET http://mschus.www.conxion.com/download/win2000platform/sp/sp1/nt5/en-us/sp1network.exe alex DIRECT/mschus.www.conxion.com -
965332514.167 125964 10.1.6.0 TCP_MISS/503 1061 GET ftp://ftp.ruhr-uni-bochum.de/.subdisc3/local/winnt/2000/fixes/usa/sp1/sp1network.exe alex DIRECT/ftp.ruhr-uni-bochum.de -
965332528.157 173922 10.1.6.0 TCP_MISS/503 1065 GET http://mschus.www.conxion.com/download/win2000platform/sp/sp1/nt5/en-us/sp1network.exe alex DIRECT/mschus.www.conxion.com -
965332532.458 153276 10.1.6.0 TCP_MISS/503 1039 GET ftp://ftp.hu-berlin.de/pub/windows/fixes/w2000/sp1/english/sp1network.exe alex DIRECT/ftp.hu-berlin.de -
965332554.127 123093 10.1.6.0 TCP_MISS/503 1033 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -
965332555.157 126095 10.1.6.0 TCP_MISS/503 1033 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -
965332588.327 143873 10.1.6.0 TCP_MISS/504 1034 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -
965332592.437 123099 10.1.6.0 TCP_MISS/503 1033 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -
965332607.457 129096 10.1.6.0 TCP_MISS/503 1033 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -
965332651.327 132098 10.1.6.0 TCP_MISS/503 1065 GET http://mschus.www.conxion.com/download/win2000platform/sp/sp1/nt5/en-us/sp1network.exe alex DIRECT/mschus.www.conxion.com -
965332653.297 132095 10.1.6.0 TCP_MISS/503 1065 GET http://mschus.www.conxion.com/download/win2000platform/sp/sp1/nt5/en-us/sp1network.exe alex DIRECT/mschus.www.conxion.com -
965332706.337 146843 10.1.6.0 TCP_MISS/503 1065 GET http://mschus.www.conxion.com/download/win2000platform/sp/sp1/nt5/en-us/sp1network.exe alex DIRECT/mschus.www.conxion.com -
965332714.477 179843 10.1.6.0 TCP_MISS/503 1065 GET http://mschus.www.conxion.com/download/win2000platform/sp/sp1/nt5/en-us/sp1network.exe alex DIRECT/mschus.www.conxion.com -
965332734.467 123099 10.1.6.0 TCP_MISS/503 1047 GET ftp://ftp.darmstadt.gmd.de/pub/pc/Win2k/microsoft/fixes/sp1/en/sp1network.exe alex DIRECT/ftp.darmstadt.gmd.de -
965332735.477 126090 10.1.6.0 TCP_MISS/503 1039 GET ftp://ftp.mathematik.uni-marburg.de/pub/mirror/w2ksp/en-us/sp1network.exe alex DIRECT/ftp.mathematik.uni-marburg.de -
965332760.215 191697 10.1.6.0 TCP_MISS/504 1066 GET http://mschus.www.conxion.com/download/win2000platform/sp/sp1/nt5/en-us/sp1network.exe alex DIRECT/mschus.www.conxion.com -
965332775.457 125723 10.1.6.0 TCP_MISS/503 1033 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -
965332784.647 125972 10.1.6.0 TCP_MISS/503 1033 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -
965332822.637 123042 10.1.6.0 TCP_MISS/503 1033 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -
965332824.627 123101 10.1.6.0 TCP_MISS/503 1033 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -
965332855.798 140926 10.1.6.0 TCP_MISS/503 1033 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -
965332862.907 123097 10.1.6.0 TCP_MISS/503 1065 GET http://mschus.www.conxion.com/download/win2000platform/sp/sp1/nt5/en-us/sp1network.exe alex DIRECT/mschus.www.conxion.com -
965332864.135 239427 10.1.6.0 TCP_MISS/504 1040 GET ftp://ftp.hu-berlin.de/pub/windows/fixes/w2000/sp1/english/sp1network.exe alex DIRECT/ftp.hu-berlin.de -
965332895.307 146475 10.1.6.0 TCP_MISS/503 1065 GET http://mschus.www.conxion.com/download/win2000platform/sp/sp1/nt5/en-us/sp1network.exe alex DIRECT/mschus.www.conxion.com -
965332923.787 132098 10.1.6.0 TCP_MISS/503 1065 GET http://mschus.www.conxion.com/download/win2000platform/sp/sp1/nt5/en-us/sp1network.exe alex DIRECT/mschus.www.conxion.com -
965332933.797 144096 10.1.6.0 TCP_MISS/503 1065 GET http://mschus.www.conxion.com/download/win2000platform/sp/sp1/nt5/en-us/sp1network.exe alex DIRECT/mschus.www.conxion.com -
965332953.057 123091 10.1.6.0 TCP_MISS/503 1061 GET ftp://ftp.ruhr-uni-bochum.de/.subdisc3/local/winnt/2000/fixes/usa/sp1/sp1network.exe alex DIRECT/ftp.ruhr-uni-bochum.de -
965333004.947 123096 10.1.6.0 TCP_MISS/503 1033 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -
965333005.947 126089 10.1.6.0 TCP_MISS/503 1033 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -
965333015.078 176088 10.1.6.0 TCP_MISS/503 1039 GET ftp://ftp.mathematik.uni-marburg.de/pub/mirror/w2ksp/en-us/sp1network.exe alex DIRECT/ftp.mathematik.uni-marburg.de -
965333021.078 216044 10.1.6.0 TCP_MISS/503 1065 GET http://mschus.www.conxion.com/download/win2000platform/sp/sp1/nt5/en-us/sp1network.exe alex DIRECT/mschus.www.conxion.com -
965333030.077 134888 10.1.6.0 TCP_MISS/503 1033 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -
965333043.217 123092 10.1.6.0 TCP_MISS/503 1033 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -
965333055.167 125943 10.1.6.0 TCP_MISS/503 1033 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -
965333104.097 132089 10.1.6.0 TCP_MISS/503 1065 GET http://mschus.www.conxion.com/download/win2000platform/sp/sp1/nt5/en-us/sp1network.exe alex DIRECT/mschus.www.conxion.com -
965333132.057 146711 10.1.6.0 TCP_MISS/503 1065 GET http://mschus.www.conxion.com/download/win2000platform/sp/sp1/nt5/en-us/sp1network.exe alex DIRECT/mschus.www.conxion.com -
965333157.207 146925 10.1.6.0 TCP_MISS/503 1065 GET http://mschus.www.conxion.com/download/win2000platform/sp/sp1/nt5/en-us/sp1network.exe alex DIRECT/mschus.www.conxion.com -
965333162.107 192030 10.1.6.0 TCP_MISS/503 1065 GET http://mschus.www.conxion.com/download/win2000platform/sp/sp1/nt5/en-us/sp1network.exe alex DIRECT/mschus.www.conxion.com -
965333185.257 123091 10.1.6.0 TCP_MISS/503 1039 GET ftp://ftp.hu-berlin.de/pub/windows/fixes/w2000/sp1/english/sp1network.exe alex DIRECT/ftp.hu-berlin.de -
965333201.428 141255 10.1.6.0 TCP_MISS/503 1047 GET ftp://ftp.darmstadt.gmd.de/pub/pc/Win2k/microsoft/fixes/sp1/en/sp1network.exe alex DIRECT/ftp.darmstadt.gmd.de -
965333211.397 192092 10.1.6.0 TCP_MISS/503 1065 GET http://mschus.www.conxion.com/download/win2000platform/sp/sp1/nt5/en-us/sp1network.exe alex DIRECT/mschus.www.conxion.com -
965333226.557 126062 10.1.6.0 TCP_MISS/503 1033 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -
965333264.427 188923 10.1.6.0 TCP_MISS/504 1062 GET ftp://ftp.ruhr-uni-bochum.de/.subdisc3/local/winnt/2000/fixes/usa/sp1/sp1network.exe alex DIRECT/ftp.ruhr-uni-bochum.de -
965333279.428 129098 10.1.6.0 TCP_MISS/503 1033 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -
965333281.417 129095 10.1.6.0 TCP_MISS/503 1033 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -
965333291.517 125857 10.1.6.0 TCP_MISS/503 1033 GET ftp://ftp.ism.ru/pub/drivers/software/microsoft/win2000/sp1network.exe alex DIRECT/ftp.ism.ru -

仅使用 awk 代码如何做到这一点？

linux

1 个回答

  1. Best Answer

    算法复杂度在O(n²)范围内的惰性版本： 

    function idx_of_max(a) {
    i_max = 0;
    for (i in a) {
        if (a[i] > a[i_max]) {
            i_max = i;
        }
    }

    return i_max;
}

{
    servers[$7] += $5;
}

END {
    for (n = 1; n <= 10; n++) {
        srv = idx_of_max(servers);
        if (!srv) {
            break;
        }

        print n ": " srv " = " servers[srv];
        delete servers[srv];
    }
}

    好的方法是，在这里您需要创建一个函数，用于按值对关联数组的键进行排序（而AWK中的数组仅关联），但这是一个带星号的任务 :-)

    • 3

相关问题