{"id":31631,"date":"2025-04-22T00:55:58","date_gmt":"2025-04-21T16:55:58","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/31631.html"},"modified":"2025-04-22T00:55:58","modified_gmt":"2025-04-21T16:55:58","slug":"%e8%8e%b7%e5%8f%96%e6%9c%8d%e5%8a%a1%e5%99%a8%e4%bf%a1%e6%81%af%e7%9b%b8%e5%85%b3%e8%84%9a%e6%9c%ac","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/31631.html","title":{"rendered":"\u83b7\u53d6\u670d\u52a1\u5668\u4fe1\u606f\u76f8\u5173\u811a\u672c"},"content":{"rendered":"<h4>\u6807\u9898<\/h4>\n<p>\u4f7f\u7528 Paramiko \u548c Tkinter \u5b9e\u73b0\u8fdc\u7a0b\u670d\u52a1\u5668\u4fe1\u606f\u91c7\u96c6\u5de5\u5177 <img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250421165557-6806789d792c7.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h4>\u7b80\u4ecb<\/h4>\n<p>\u8fd9\u7bc7\u6587\u6863\u4ecb\u7ecd\u4e86\u4e00\u6b3e\u4f7f\u7528 Paramiko\u3001Tkinter \u548c Openpyxl \u5f00\u53d1\u7684\u8fdc\u7a0b\u670d\u52a1\u5668\u4fe1\u606f\u91c7\u96c6\u5de5\u5177\u3002\u7528\u6237\u53ef\u4ee5\u901a\u8fc7\u4e00\u4e2a\u7b80\u5355\u7684\u56fe\u5f62\u754c\u9762\u5bf9\u591a\u4e2a\u670d\u52a1\u5668\u6267\u884cCPU\u3001\u5185\u5b58\u3001\u7f51\u7edc\u3001\u78c1\u76d8\u53caGPU\u7b49\u6570\u636e\u7684\u91c7\u96c6&#xff0c;\u5e76\u5c06\u7ed3\u679c\u4fdd\u5b58\u81f3Excel\u6587\u4ef6\u4e2d\u3002<\/p>\n<h4>\u529f\u80fd\u7279\u70b9<\/h4>\n<ul>\n<li>\u901a\u8fc7SSH\u8fde\u63a5\u8fdc\u7a0b\u670d\u52a1\u5668\u91c7\u96c6\u4fe1\u606f<\/li>\n<li>\u652f\u6301\u591a\u79cd\u4fe1\u606f\u7c7b\u578b&#xff1a;\u5185\u5b58\u3001CPU\u3001\u78c1\u76d8IO\u3001\u7f51\u7edc\u4fe1\u606f\u53caGPU\u4fe1\u606f<\/li>\n<li>\u6570\u636e\u81ea\u52a8\u4fdd\u5b58\u81f3Excel\u6587\u4ef6&#xff0c;\u5e76\u63d0\u4f9b\u5408\u5e76\u529f\u80fd<\/li>\n<li>\u652f\u6301\u591a\u79cdGPU\u7c7b\u578b&#xff08;NVIDIA\u3001XPU\u3001Tianshu&#xff09;<\/li>\n<li>\u63d0\u4f9b\u56fe\u5f62\u7528\u6237\u754c\u9762&#xff0c;\u7b80\u5316\u64cd\u4f5c<\/li>\n<\/ul>\n<h4>\u73af\u5883\u8981\u6c42<\/h4>\n<ul>\n<li>Python 3.x<\/li>\n<li>Required Python libraries: Paramiko, Tkinter, Openpyxl, Pandas<\/li>\n<\/ul>\n<h4>\u5b89\u88c5\u6b65\u9aa4<\/h4>\n<li>\n<p>\u5b89\u88c5 Python \u53ca \u5fc5\u8981\u7684\u7b2c\u4e09\u65b9\u5e93<\/p>\n<p>\u786e\u4fdd\u7cfb\u7edf\u4e0a\u5b89\u88c5\u4e86Python&#xff0c;\u60a8\u53ef\u4ee5\u901a\u8fc7\u4ee5\u4e0b\u547d\u4ee4\u68c0\u67e5Python\u7248\u672c&#xff1a;<\/p>\n<p> python &#8211;version<\/p>\n<p>\u63a5\u7740\u5b89\u88c5\u6240\u9700\u7b2c\u4e09\u65b9\u5e93&#xff1a;<\/p>\n<p> pip <span class=\"token function\">install<\/span> paramiko openpyxl pandas\n <\/li>\n<li>\n<p>\u8fd0\u884c\u4ee3\u7801<\/p>\n<p>\u5c06\u4ee3\u7801\u4fdd\u5b58\u4e3aPython\u6587\u4ef6&#xff08;\u5982 server_info_collector.py&#xff09;&#xff0c;\u7136\u540e\u8fd0\u884c&#xff1a;<\/p>\n<p> python server_info_collector.py\n <\/li>\n<li>\n<p>\u4f7f\u7528\u56fe\u5f62\u7528\u6237\u754c\u9762<\/p>\n<p>\u7a0b\u5e8f\u542f\u52a8\u540e&#xff0c;\u4f1a\u5f39\u51fa\u4e00\u4e2a\u5bf9\u8bdd\u6846\u8981\u6c42\u8f93\u5165\u670d\u52a1\u5668\u76f8\u5173\u4fe1\u606f&#xff0c;\u5305\u62ec&#xff1a;<\/p>\n<ul>\n<li>\u670d\u52a1\u5668IP<\/li>\n<li>\u7528\u6237\u540d<\/li>\n<li>\u5bc6\u7801<\/li>\n<li>\u9009\u62e9\u76d8\u540d\u79f0&#xff08;\u7528\u9017\u53f7\u5206\u9694&#xff09;<\/li>\n<li>GPU\u578b\u53f7<\/li>\n<li>\u6301\u7eed\u8fd0\u884c\u65f6\u95f4&#xff08;\u79d2&#xff09;<\/li>\n<li>\u4fe1\u606f\u91c7\u96c6\u95f4\u9694&#xff08;\u79d2&#xff09;<\/li>\n<\/ul>\n<p>\u6839\u636e\u60a8\u7684\u9700\u6c42\u8f93\u5165\u76f8\u5e94\u7684\u53c2\u6570&#xff0c;\u7136\u540e\u786e\u8ba4&#xff0c;\u7a0b\u5e8f\u4f1a\u81ea\u52a8\u8fdb\u884c\u6570\u636e\u6536\u96c6\u5e76\u5b58\u50a8\u3002<\/p>\n<\/li>\n<h4>\u4f7f\u7528\u8bf4\u660e<\/h4>\n<li>\n<p>\u5f00\u59cb\u6570\u636e\u91c7\u96c6<\/p>\n<p>\u5728\u586b\u5199\u597d\u6240\u9700\u4fe1\u606f\u5e76\u786e\u8ba4\u540e&#xff0c;\u7a0b\u5e8f\u5c06\u6839\u636e\u6307\u5b9a\u7684\u914d\u7f6e\u5f00\u59cb\u4ece\u76ee\u6807\u670d\u52a1\u5668\u91c7\u96c6\u6570\u636e\u3002<\/p>\n<\/li>\n<li>\n<p>\u6570\u636e\u7684\u5b58\u50a8\u548c\u67e5\u770b<\/p>\n<p>\u91c7\u96c6\u5b8c\u6210\u540e&#xff0c;\u7a0b\u5e8f\u4f1a\u5c06\u6570\u636e\u4fdd\u5b58\u5230\u5f53\u524d\u8fd0\u884c\u76ee\u5f55\u4e0b\u7684\u591a\u4e2aExcel\u6587\u4ef6\u4e2d&#xff1a;<\/p>\n<ul>\n<li>memory_info.xlsx &#8211; \u5185\u5b58\u4fe1\u606f<\/li>\n<li>cpu_info.xlsx &#8211; CPU \u4fe1\u606f<\/li>\n<li>network_info.xlsx &#8211; \u7f51\u7edc\u4fe1\u606f<\/li>\n<li>disk_io_info.xlsx &#8211; \u786c\u76d8IO\u4fe1\u606f<\/li>\n<li>nvidia_gpu_info.xlsx, xpu_gpu_info.xlsx, tianshu_gpu_info.xlsx &#8211; \u4e0d\u540c\u7c7b\u578b\u7684GPU\u4fe1\u606f<\/li>\n<\/ul>\n<p>\u6700\u540e&#xff0c;\u7a0b\u5e8f\u5c06\u5404\u4e2a\u6587\u4ef6\u5408\u5e76\u4e3a merged_file.xlsx\u3002<\/p>\n<\/li>\n<li>\n<p>\u505c\u6b62\u548c\u5173\u95ed<\/p>\n<p>\u5b8c\u6210\u6570\u636e\u91c7\u96c6\u540e&#xff0c;\u70b9\u51fb\u56fe\u5f62\u754c\u9762\u7684\u5173\u95ed\u6309\u94ae\u5373\u53ef\u9000\u51fa\u7a0b\u5e8f\u3002<\/p>\n<\/li>\n<h4>\u6ce8\u610f\u4e8b\u9879<\/h4>\n<ul>\n<li>\u786e\u4fdd\u6240\u8fde\u63a5\u7684\u670d\u52a1\u5668\u5bf9SSH\u8fde\u63a5\u7684IP\u662f\u5f00\u653e\u7684\u3002<\/li>\n<li>\u8981\u63d0\u4f9b\u6b63\u786e\u7684\u7528\u6237\u540d\u548c\u5bc6\u7801\u4ee5\u83b7\u5f97\u8bbf\u95ee\u6743\u9650\u3002<\/li>\n<\/ul>\n<h4>\u6f5c\u5728\u95ee\u9898\u548c\u8c03\u8bd5<\/h4>\n<ul>\n<li>\u5982\u679c\u51fa\u73b0\u65e0\u6cd5\u8fde\u63a5\u7684\u95ee\u9898&#xff0c;\u8bf7\u68c0\u67e5\u4e3b\u673aIP\u548c\u7f51\u7edc\u8fde\u63a5\u662f\u5426\u6b63\u5e38\u3002<\/li>\n<li>\u5982\u679c\u83b7\u53d6GPU\u4fe1\u606f\u5931\u8d25&#xff0c;\u8bf7\u68c0\u67e5\u670d\u52a1\u5668\u4e0a\u662f\u5426\u5b89\u88c5\u5bf9\u5e94\u7684\u7ba1\u7406\u5de5\u5177&#xff08;\u4f8b\u5982 nvidia-smi \u5bf9\u4e8eNVIDIA GPU&#xff09;\u3002<\/li>\n<\/ul>\n<h4>\u7ed3\u8bba<\/h4>\n<p>\u8fd9\u6b3e\u4fe1\u606f\u91c7\u96c6\u5de5\u5177\u63d0\u4f9b\u4e86\u4e00\u79cd\u9ad8\u6548\u3001\u4fbf\u6377\u7684\u65b9\u5f0f\u6765\u83b7\u53d6\u8fdc\u7a0b\u670d\u52a1\u5668\u4e0a\u7684\u5173\u952e\u4fe1\u606f&#xff0c;\u9002\u5408\u65e5\u5e38\u76d1\u63a7\u548c\u6027\u80fd\u5206\u6790\u4f7f\u7528\u3002<\/p>\n<p><span class=\"token keyword\">import<\/span> paramiko<br \/>\n<span class=\"token keyword\">from<\/span> openpyxl <span class=\"token keyword\">import<\/span> load_workbook<span class=\"token punctuation\">,<\/span> Workbook<br \/>\n<span class=\"token keyword\">import<\/span> tkinter <span class=\"token keyword\">as<\/span> tk<br \/>\n<span class=\"token keyword\">from<\/span> tkinter <span class=\"token keyword\">import<\/span> simpledialog<br \/>\n<span class=\"token keyword\">import<\/span> time<br \/>\n<span class=\"token keyword\">import<\/span> os<br \/>\n<span class=\"token keyword\">import<\/span> datetime<br \/>\n<span class=\"token keyword\">import<\/span> pandas <span class=\"token keyword\">as<\/span> pd<br \/>\n<span class=\"token keyword\">import<\/span> warnings<br \/>\n<span class=\"token keyword\">import<\/span> multiprocessing<br \/>\nwarnings<span class=\"token punctuation\">.<\/span>filterwarnings<span class=\"token punctuation\">(<\/span>action<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#039;ignore&#039;<\/span><span class=\"token punctuation\">,<\/span>module<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#039;.*paramiko.*&#039;<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token comment\"># Initialize the global parameters storage<\/span><br \/>\nlast_inputs <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">{<\/span><br \/>\n    <span class=\"token string\">&#034;server_ip&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token string\">&#034;username&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token string\">&#034;password&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token string\">&#034;selected_devices&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token string\">&#034;selected_gpus&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token string\">&#034;total_run_time&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;&#034;<\/span><br \/>\n<span class=\"token punctuation\">}<\/span><\/p>\n<p><span class=\"token keyword\">class<\/span> <span class=\"token class-name\">CustomDialog<\/span><span class=\"token punctuation\">(<\/span>tk<span class=\"token punctuation\">.<\/span>simpledialog<span class=\"token punctuation\">.<\/span>Dialog<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token keyword\">def<\/span> <span class=\"token function\">__init__<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">,<\/span> master<span class=\"token punctuation\">,<\/span> title<span class=\"token operator\">&#061;<\/span><span class=\"token boolean\">None<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>initial_values <span class=\"token operator\">&#061;<\/span> last_inputs<br \/>\n        <span class=\"token builtin\">super<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>__init__<span class=\"token punctuation\">(<\/span>master<span class=\"token punctuation\">,<\/span> title<span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">def<\/span> <span class=\"token function\">body<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">,<\/span> master<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        tk<span class=\"token punctuation\">.<\/span>Label<span class=\"token punctuation\">(<\/span>master<span class=\"token punctuation\">,<\/span> text<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;\u670d\u52a1\u5668IP:&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>grid<span class=\"token punctuation\">(<\/span>row<span class=\"token operator\">&#061;<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        tk<span class=\"token punctuation\">.<\/span>Label<span class=\"token punctuation\">(<\/span>master<span class=\"token punctuation\">,<\/span> text<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;\u7528\u6237\u540d:&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>grid<span class=\"token punctuation\">(<\/span>row<span class=\"token operator\">&#061;<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        tk<span class=\"token punctuation\">.<\/span>Label<span class=\"token punctuation\">(<\/span>master<span class=\"token punctuation\">,<\/span> text<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;\u5bc6\u7801:&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>grid<span class=\"token punctuation\">(<\/span>row<span class=\"token operator\">&#061;<\/span><span class=\"token number\">2<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        tk<span class=\"token punctuation\">.<\/span>Label<span class=\"token punctuation\">(<\/span>master<span class=\"token punctuation\">,<\/span> text<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;\u9009\u62e9\u76d8\u540d\u79f0&#xff08;\u7528\u9017\u53f7\u5206\u9694&#xff09;:&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>grid<span class=\"token punctuation\">(<\/span>row<span class=\"token operator\">&#061;<\/span><span class=\"token number\">3<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        tk<span class=\"token punctuation\">.<\/span>Label<span class=\"token punctuation\">(<\/span>master<span class=\"token punctuation\">,<\/span> text<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;GPU\u578b\u53f7:&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>grid<span class=\"token punctuation\">(<\/span>row<span class=\"token operator\">&#061;<\/span><span class=\"token number\">4<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        tk<span class=\"token punctuation\">.<\/span>Label<span class=\"token punctuation\">(<\/span>master<span class=\"token punctuation\">,<\/span> text<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;\u6301\u7eed\u8fd0\u884c\u65f6\u95f4&#xff08;\u79d2&#xff09;:&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>grid<span class=\"token punctuation\">(<\/span>row<span class=\"token operator\">&#061;<\/span><span class=\"token number\">5<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        tk<span class=\"token punctuation\">.<\/span>Label<span class=\"token punctuation\">(<\/span>master<span class=\"token punctuation\">,<\/span> text<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;\u4fe1\u606f\u91c7\u96c6\u95f4\u9694&#xff08;\u79d2&#xff09;:&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>grid<span class=\"token punctuation\">(<\/span>row<span class=\"token operator\">&#061;<\/span><span class=\"token number\">6<\/span><span class=\"token punctuation\">)<\/span>  <span class=\"token comment\"># \u65b0\u589e\u8f93\u5165\u6846\u6807\u7b7e<\/span><\/p>\n<p>        self<span class=\"token punctuation\">.<\/span>e1 <span class=\"token operator\">&#061;<\/span> tk<span class=\"token punctuation\">.<\/span>Entry<span class=\"token punctuation\">(<\/span>master<span class=\"token punctuation\">)<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>e2 <span class=\"token operator\">&#061;<\/span> tk<span class=\"token punctuation\">.<\/span>Entry<span class=\"token punctuation\">(<\/span>master<span class=\"token punctuation\">)<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>e3 <span class=\"token operator\">&#061;<\/span> tk<span class=\"token punctuation\">.<\/span>Entry<span class=\"token punctuation\">(<\/span>master<span class=\"token punctuation\">)<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>e4 <span class=\"token operator\">&#061;<\/span> tk<span class=\"token punctuation\">.<\/span>Entry<span class=\"token punctuation\">(<\/span>master<span class=\"token punctuation\">)<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>e5 <span class=\"token operator\">&#061;<\/span> tk<span class=\"token punctuation\">.<\/span>Entry<span class=\"token punctuation\">(<\/span>master<span class=\"token punctuation\">)<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>e6 <span class=\"token operator\">&#061;<\/span> tk<span class=\"token punctuation\">.<\/span>Entry<span class=\"token punctuation\">(<\/span>master<span class=\"token punctuation\">)<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>e7 <span class=\"token operator\">&#061;<\/span> tk<span class=\"token punctuation\">.<\/span>Entry<span class=\"token punctuation\">(<\/span>master<span class=\"token punctuation\">)<\/span>  <span class=\"token comment\"># \u65b0\u589e\u8f93\u5165\u6846<\/span><\/p>\n<p>        self<span class=\"token punctuation\">.<\/span>e1<span class=\"token punctuation\">.<\/span>grid<span class=\"token punctuation\">(<\/span>row<span class=\"token operator\">&#061;<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span> column<span class=\"token operator\">&#061;<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>e2<span class=\"token punctuation\">.<\/span>grid<span class=\"token punctuation\">(<\/span>row<span class=\"token operator\">&#061;<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> column<span class=\"token operator\">&#061;<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>e3<span class=\"token punctuation\">.<\/span>grid<span class=\"token punctuation\">(<\/span>row<span class=\"token operator\">&#061;<\/span><span class=\"token number\">2<\/span><span class=\"token punctuation\">,<\/span> column<span class=\"token operator\">&#061;<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>e4<span class=\"token punctuation\">.<\/span>grid<span class=\"token punctuation\">(<\/span>row<span class=\"token operator\">&#061;<\/span><span class=\"token number\">3<\/span><span class=\"token punctuation\">,<\/span> column<span class=\"token operator\">&#061;<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>e5<span class=\"token punctuation\">.<\/span>grid<span class=\"token punctuation\">(<\/span>row<span class=\"token operator\">&#061;<\/span><span class=\"token number\">4<\/span><span class=\"token punctuation\">,<\/span> column<span class=\"token operator\">&#061;<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>e6<span class=\"token punctuation\">.<\/span>grid<span class=\"token punctuation\">(<\/span>row<span class=\"token operator\">&#061;<\/span><span class=\"token number\">5<\/span><span class=\"token punctuation\">,<\/span> column<span class=\"token operator\">&#061;<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>e7<span class=\"token punctuation\">.<\/span>grid<span class=\"token punctuation\">(<\/span>row<span class=\"token operator\">&#061;<\/span><span class=\"token number\">6<\/span><span class=\"token punctuation\">,<\/span> column<span class=\"token operator\">&#061;<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span>  <span class=\"token comment\"># \u65b0\u589e\u8f93\u5165\u6846\u4f4d\u7f6e<\/span><\/p>\n<p>        self<span class=\"token punctuation\">.<\/span>e1<span class=\"token punctuation\">.<\/span>insert<span class=\"token punctuation\">(<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span> self<span class=\"token punctuation\">.<\/span>initial_values<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;server_ip&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>e2<span class=\"token punctuation\">.<\/span>insert<span class=\"token punctuation\">(<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span> self<span class=\"token punctuation\">.<\/span>initial_values<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;username&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>e3<span class=\"token punctuation\">.<\/span>insert<span class=\"token punctuation\">(<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span> self<span class=\"token punctuation\">.<\/span>initial_values<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;password&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>e4<span class=\"token punctuation\">.<\/span>insert<span class=\"token punctuation\">(<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span> self<span class=\"token punctuation\">.<\/span>initial_values<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;selected_devices&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>e5<span class=\"token punctuation\">.<\/span>insert<span class=\"token punctuation\">(<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span> self<span class=\"token punctuation\">.<\/span>initial_values<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;selected_gpus&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>e6<span class=\"token punctuation\">.<\/span>insert<span class=\"token punctuation\">(<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span> self<span class=\"token punctuation\">.<\/span>initial_values<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;total_run_time&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>e7<span class=\"token punctuation\">.<\/span>insert<span class=\"token punctuation\">(<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span> self<span class=\"token punctuation\">.<\/span>initial_values<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;interval&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;5&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span>  <span class=\"token comment\"># \u9ed8\u8ba45\u79d2<\/span><\/p>\n<p>        <span class=\"token keyword\">return<\/span> self<span class=\"token punctuation\">.<\/span>e1<\/p>\n<p>    <span class=\"token keyword\">def<\/span> <span class=\"token function\">apply<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">global<\/span> last_inputs<\/p>\n<p>        server_ip <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>e1<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        username <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>e2<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        password <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>e3<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        selected_devices <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span>d<span class=\"token punctuation\">.<\/span>strip<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">for<\/span> d <span class=\"token keyword\">in<\/span> self<span class=\"token punctuation\">.<\/span>e4<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>split<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;,&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">]<\/span><br \/>\n        selected_gpus <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span>gpu<span class=\"token punctuation\">.<\/span>strip<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">for<\/span> gpu <span class=\"token keyword\">in<\/span> self<span class=\"token punctuation\">.<\/span>e5<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>split<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;,&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">]<\/span><br \/>\n        total_run_time <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>e6<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        interval <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>e7<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>  <span class=\"token comment\"># \u83b7\u53d6\u65b0\u7684\u8f93\u5165\u503c<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>result <span class=\"token operator\">&#061;<\/span> server_ip<span class=\"token punctuation\">,<\/span> username<span class=\"token punctuation\">,<\/span> password<span class=\"token punctuation\">,<\/span> selected_devices<span class=\"token punctuation\">,<\/span> selected_gpus<span class=\"token punctuation\">,<\/span> total_run_time<span class=\"token punctuation\">,<\/span> interval<\/p>\n<p>        <span class=\"token comment\"># Update global last_inputs<\/span><br \/>\n        last_inputs<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;server_ip&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> server_ip<br \/>\n        last_inputs<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;username&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> username<br \/>\n        last_inputs<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;password&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> password<br \/>\n        last_inputs<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;selected_devices&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>e4<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        last_inputs<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;selected_gpus&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>e5<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        last_inputs<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;total_run_time&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> total_run_time<br \/>\n        last_inputs<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;interval&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> interval  <span class=\"token comment\"># \u4fdd\u5b58\u65b0\u7684\u8f93\u5165\u503c<\/span><\/p>\n<p><span class=\"token keyword\">def<\/span> <span class=\"token function\">get_memory_info<\/span><span class=\"token punctuation\">(<\/span>server_ip<span class=\"token punctuation\">,<\/span> username<span class=\"token punctuation\">,<\/span> password<span class=\"token punctuation\">,<\/span> total_run_time<span class=\"token punctuation\">,<\/span> interval<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    start_time <span class=\"token operator\">&#061;<\/span> time<span class=\"token punctuation\">.<\/span>time<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    file_path <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;memory_info.xlsx&#039;<\/span><br \/>\n    headers <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;Time&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Total&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Used&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Free&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Shared&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Buff\/Cache&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Available&#039;<\/span><span class=\"token punctuation\">]<\/span><\/p>\n<p>    wb<span class=\"token punctuation\">,<\/span> ws <span class=\"token operator\">&#061;<\/span> initialize_workbook<span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">,<\/span> headers<span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">try<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">while<\/span> time<span class=\"token punctuation\">.<\/span>time<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&#8211;<\/span> start_time <span class=\"token operator\">&lt;<\/span> total_run_time<span class=\"token punctuation\">:<\/span><br \/>\n            ssh <span class=\"token operator\">&#061;<\/span> paramiko<span class=\"token punctuation\">.<\/span>SSHClient<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            ssh<span class=\"token punctuation\">.<\/span>set_missing_host_key_policy<span class=\"token punctuation\">(<\/span>paramiko<span class=\"token punctuation\">.<\/span>AutoAddPolicy<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            ssh<span class=\"token punctuation\">.<\/span>connect<span class=\"token punctuation\">(<\/span>server_ip<span class=\"token punctuation\">,<\/span> username<span class=\"token operator\">&#061;<\/span>username<span class=\"token punctuation\">,<\/span> password<span class=\"token operator\">&#061;<\/span>password<span class=\"token punctuation\">)<\/span><\/p>\n<p>            <span class=\"token comment\"># \u83b7\u53d6\u65f6\u95f4\u4fe1\u606f<\/span><br \/>\n            stdin<span class=\"token punctuation\">,<\/span> stdout<span class=\"token punctuation\">,<\/span> stderr <span class=\"token operator\">&#061;<\/span> ssh<span class=\"token punctuation\">.<\/span>exec_command<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;date &#043;%T&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            current_time <span class=\"token operator\">&#061;<\/span> stdout<span class=\"token punctuation\">.<\/span>read<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>decode<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>strip<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>            <span class=\"token comment\"># \u83b7\u53d6\u5185\u5b58\u4fe1\u606f<\/span><br \/>\n            stdin<span class=\"token punctuation\">,<\/span> stdout<span class=\"token punctuation\">,<\/span> stderr <span class=\"token operator\">&#061;<\/span> ssh<span class=\"token punctuation\">.<\/span>exec_command<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;free -g&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            memory_info <span class=\"token operator\">&#061;<\/span> stdout<span class=\"token punctuation\">.<\/span>read<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>decode<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>split<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\\\\n&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            memory_values <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span><br \/>\n            <span class=\"token keyword\">for<\/span> line <span class=\"token keyword\">in<\/span> memory_info<span class=\"token punctuation\">:<\/span><br \/>\n                <span class=\"token keyword\">if<\/span> line<span class=\"token punctuation\">.<\/span>startswith<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;Mem:&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n                    memory_values <span class=\"token operator\">&#061;<\/span> line<span class=\"token punctuation\">.<\/span>split<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">[<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">:<\/span><span class=\"token punctuation\">]<\/span><\/p>\n<p>            <span class=\"token comment\"># \u7ec4\u5408\u5185\u5b58\u4fe1\u606f\u6570\u636e<\/span><br \/>\n            memory_data <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span>current_time<span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#043;<\/span> memory_values<br \/>\n            ws<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span>memory_data<span class=\"token punctuation\">)<\/span><\/p>\n<p>            ssh<span class=\"token punctuation\">.<\/span>close<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            time<span class=\"token punctuation\">.<\/span>sleep<span class=\"token punctuation\">(<\/span>interval<span class=\"token punctuation\">)<\/span><\/p>\n<p>        wb<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#039;Memory information of server <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>server_ip<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> has been appended to the file <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>file_path<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">.&#039;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">except<\/span> paramiko<span class=\"token punctuation\">.<\/span>SSHException <span class=\"token keyword\">as<\/span> e<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;SSH connection error: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>e<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;SSH connection error, please check if the server IP, username, and password are correct.&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">except<\/span> Exception <span class=\"token keyword\">as<\/span> e<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;An error occurred: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>e<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token keyword\">def<\/span> <span class=\"token function\">get_cpu_info<\/span><span class=\"token punctuation\">(<\/span>server_ip<span class=\"token punctuation\">,<\/span> username<span class=\"token punctuation\">,<\/span> password<span class=\"token punctuation\">,<\/span> total_run_time<span class=\"token punctuation\">,<\/span> interval<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    start_time <span class=\"token operator\">&#061;<\/span> time<span class=\"token punctuation\">.<\/span>time<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    file_path <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;cpu_info.xlsx&#039;<\/span><br \/>\n    headers <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;Time&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;CPU&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;%idle&#039;<\/span><span class=\"token punctuation\">]<\/span><\/p>\n<p>    wb<span class=\"token punctuation\">,<\/span> ws <span class=\"token operator\">&#061;<\/span> initialize_workbook<span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">,<\/span> headers<span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">try<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">while<\/span> time<span class=\"token punctuation\">.<\/span>time<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&#8211;<\/span> start_time <span class=\"token operator\">&lt;<\/span> total_run_time<span class=\"token punctuation\">:<\/span><br \/>\n            ssh <span class=\"token operator\">&#061;<\/span> paramiko<span class=\"token punctuation\">.<\/span>SSHClient<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            ssh<span class=\"token punctuation\">.<\/span>set_missing_host_key_policy<span class=\"token punctuation\">(<\/span>paramiko<span class=\"token punctuation\">.<\/span>AutoAddPolicy<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            ssh<span class=\"token punctuation\">.<\/span>connect<span class=\"token punctuation\">(<\/span>server_ip<span class=\"token punctuation\">,<\/span> username<span class=\"token operator\">&#061;<\/span>username<span class=\"token punctuation\">,<\/span> password<span class=\"token operator\">&#061;<\/span>password<span class=\"token punctuation\">)<\/span><\/p>\n<p>            stdin<span class=\"token punctuation\">,<\/span> stdout<span class=\"token punctuation\">,<\/span> stderr <span class=\"token operator\">&#061;<\/span> ssh<span class=\"token punctuation\">.<\/span>exec_command<span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#039;timeout <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>interval<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> mpstat -P ALL 1 | tail -n &#043;4&#039;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n            frequency_info <span class=\"token operator\">&#061;<\/span> stdout<span class=\"token punctuation\">.<\/span>readlines<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>            <span class=\"token keyword\">for<\/span> info <span class=\"token keyword\">in<\/span> frequency_info<span class=\"token punctuation\">:<\/span><br \/>\n                <span class=\"token keyword\">if<\/span> info<span class=\"token punctuation\">.<\/span>strip<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n                    data <span class=\"token operator\">&#061;<\/span> info<span class=\"token punctuation\">.<\/span>split<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n                    time_info <span class=\"token operator\">&#061;<\/span> data<span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#043;<\/span> <span class=\"token string\">&#039; &#039;<\/span> <span class=\"token operator\">&#043;<\/span> data<span class=\"token punctuation\">[<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">]<\/span><br \/>\n                    cpu_idle_percentage <span class=\"token operator\">&#061;<\/span> data<span class=\"token punctuation\">[<\/span><span class=\"token operator\">&#8211;<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">]<\/span><br \/>\n                    cpu_info <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span>time_info<span class=\"token punctuation\">,<\/span> data<span class=\"token punctuation\">[<\/span><span class=\"token number\">2<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span> cpu_idle_percentage<span class=\"token punctuation\">]<\/span><br \/>\n                    ws<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span>cpu_info<span class=\"token punctuation\">)<\/span><\/p>\n<p>            ssh<span class=\"token punctuation\">.<\/span>close<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            time<span class=\"token punctuation\">.<\/span>sleep<span class=\"token punctuation\">(<\/span>interval<span class=\"token punctuation\">)<\/span><\/p>\n<p>        wb<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#039;CPU information of server <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>server_ip<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> has been appended to the file <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>file_path<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">.&#039;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">except<\/span> paramiko<span class=\"token punctuation\">.<\/span>SSHException <span class=\"token keyword\">as<\/span> e<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;SSH connection error: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>e<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;SSH connection error, please check if the server IP, username, and password are correct.&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">except<\/span> Exception <span class=\"token keyword\">as<\/span> e<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;An error occurred: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>e<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token keyword\">def<\/span> <span class=\"token function\">get_network_info<\/span><span class=\"token punctuation\">(<\/span>server_ip<span class=\"token punctuation\">,<\/span> username<span class=\"token punctuation\">,<\/span> password<span class=\"token punctuation\">,<\/span> total_run_time<span class=\"token punctuation\">,<\/span> interval<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    start_time <span class=\"token operator\">&#061;<\/span> time<span class=\"token punctuation\">.<\/span>time<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    file_path <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;network_info.xlsx&#039;<\/span><br \/>\n    headers <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;Time&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Interface&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;RX Rate (MB\/s)&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;TX Rate (MB\/s)&#039;<\/span><span class=\"token punctuation\">]<\/span><\/p>\n<p>    wb<span class=\"token punctuation\">,<\/span> ws <span class=\"token operator\">&#061;<\/span> initialize_workbook<span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">,<\/span> headers<span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">try<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">while<\/span> time<span class=\"token punctuation\">.<\/span>time<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&#8211;<\/span> start_time <span class=\"token operator\">&lt;<\/span> total_run_time<span class=\"token punctuation\">:<\/span><br \/>\n            ssh <span class=\"token operator\">&#061;<\/span> paramiko<span class=\"token punctuation\">.<\/span>SSHClient<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            ssh<span class=\"token punctuation\">.<\/span>set_missing_host_key_policy<span class=\"token punctuation\">(<\/span>paramiko<span class=\"token punctuation\">.<\/span>AutoAddPolicy<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            ssh<span class=\"token punctuation\">.<\/span>connect<span class=\"token punctuation\">(<\/span>server_ip<span class=\"token punctuation\">,<\/span> username<span class=\"token operator\">&#061;<\/span>username<span class=\"token punctuation\">,<\/span> password<span class=\"token operator\">&#061;<\/span>password<span class=\"token punctuation\">)<\/span><\/p>\n<p>            stdin<span class=\"token punctuation\">,<\/span> stdout<span class=\"token punctuation\">,<\/span> stderr <span class=\"token operator\">&#061;<\/span> ssh<span class=\"token punctuation\">.<\/span>exec_command<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;ifconfig -a&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            net_info <span class=\"token operator\">&#061;<\/span> stdout<span class=\"token punctuation\">.<\/span>read<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>decode<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>split<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\\\\n&#039;<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>            <span class=\"token keyword\">for<\/span> line <span class=\"token keyword\">in<\/span> net_info<span class=\"token punctuation\">:<\/span><br \/>\n                <span class=\"token keyword\">if<\/span> line<span class=\"token punctuation\">.<\/span>strip<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>startswith<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;en&#039;<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">or<\/span> line<span class=\"token punctuation\">.<\/span>strip<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>startswith<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;ib&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n                    interface <span class=\"token operator\">&#061;<\/span> line<span class=\"token punctuation\">.<\/span>strip<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>split<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;:&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span><br \/>\n                    current_time<span class=\"token punctuation\">,<\/span> rx_rate<span class=\"token punctuation\">,<\/span> tx_rate <span class=\"token operator\">&#061;<\/span> get_rdma_data<span class=\"token punctuation\">(<\/span>ssh<span class=\"token punctuation\">,<\/span> interface<span class=\"token punctuation\">)<\/span><br \/>\n                    <span class=\"token keyword\">if<\/span> rx_rate <span class=\"token keyword\">is<\/span> <span class=\"token keyword\">not<\/span> <span class=\"token boolean\">None<\/span> <span class=\"token keyword\">and<\/span> tx_rate <span class=\"token keyword\">is<\/span> <span class=\"token keyword\">not<\/span> <span class=\"token boolean\">None<\/span><span class=\"token punctuation\">:<\/span><br \/>\n                        ws<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">[<\/span>current_time<span class=\"token punctuation\">,<\/span> interface<span class=\"token punctuation\">,<\/span> rx_rate<span class=\"token punctuation\">,<\/span> tx_rate<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>            ssh<span class=\"token punctuation\">.<\/span>close<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            time<span class=\"token punctuation\">.<\/span>sleep<span class=\"token punctuation\">(<\/span>interval<span class=\"token punctuation\">)<\/span><\/p>\n<p>        wb<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#039;Network information of server <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>server_ip<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> has been appended to the file <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>file_path<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">.&#039;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">except<\/span> paramiko<span class=\"token punctuation\">.<\/span>SSHException <span class=\"token keyword\">as<\/span> e<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;SSH connection error: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>e<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;SSH connection error, please check if the server IP, username, and password are correct.&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">except<\/span> Exception <span class=\"token keyword\">as<\/span> e<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;An error occurred: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>e<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token keyword\">def<\/span> <span class=\"token function\">get_rdma_data<\/span><span class=\"token punctuation\">(<\/span>ssh<span class=\"token punctuation\">,<\/span> interface<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    initial_time<span class=\"token punctuation\">,<\/span> initial_data <span class=\"token operator\">&#061;<\/span> get_rdma_bytes<span class=\"token punctuation\">(<\/span>ssh<span class=\"token punctuation\">,<\/span> interface<span class=\"token punctuation\">)<\/span><br \/>\n    time<span class=\"token punctuation\">.<\/span>sleep<span class=\"token punctuation\">(<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    final_time<span class=\"token punctuation\">,<\/span> final_data <span class=\"token operator\">&#061;<\/span> get_rdma_bytes<span class=\"token punctuation\">(<\/span>ssh<span class=\"token punctuation\">,<\/span> interface<span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">if<\/span> <span class=\"token string\">&#039;rx&#039;<\/span> <span class=\"token keyword\">in<\/span> initial_data <span class=\"token keyword\">and<\/span> <span class=\"token string\">&#039;rx&#039;<\/span> <span class=\"token keyword\">in<\/span> final_data <span class=\"token keyword\">and<\/span> <span class=\"token string\">&#039;tx&#039;<\/span> <span class=\"token keyword\">in<\/span> initial_data <span class=\"token keyword\">and<\/span> <span class=\"token string\">&#039;tx&#039;<\/span> <span class=\"token keyword\">in<\/span> final_data<span class=\"token punctuation\">:<\/span><br \/>\n        rx_diff <span class=\"token operator\">&#061;<\/span> final_data<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;rx&#039;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#8211;<\/span> initial_data<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;rx&#039;<\/span><span class=\"token punctuation\">]<\/span><br \/>\n        tx_diff <span class=\"token operator\">&#061;<\/span> final_data<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;tx&#039;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#8211;<\/span> initial_data<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;tx&#039;<\/span><span class=\"token punctuation\">]<\/span><br \/>\n        rx_rate <span class=\"token operator\">&#061;<\/span> rx_diff <span class=\"token operator\">\/<\/span> <span class=\"token number\">1024<\/span> <span class=\"token operator\">\/<\/span> <span class=\"token number\">1024<\/span><br \/>\n        tx_rate <span class=\"token operator\">&#061;<\/span> tx_diff <span class=\"token operator\">\/<\/span> <span class=\"token number\">1024<\/span> <span class=\"token operator\">\/<\/span> <span class=\"token number\">1024<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> final_time<span class=\"token punctuation\">,<\/span> rx_rate<span class=\"token punctuation\">,<\/span> tx_rate<br \/>\n    <span class=\"token keyword\">else<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;RDMA data not available for interface <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>interface<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">. Skipping calculation.&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> <span class=\"token boolean\">None<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token boolean\">None<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token boolean\">None<\/span><\/p>\n<p><span class=\"token keyword\">def<\/span> <span class=\"token function\">get_rdma_bytes<\/span><span class=\"token punctuation\">(<\/span>ssh<span class=\"token punctuation\">,<\/span> interface<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    _<span class=\"token punctuation\">,<\/span> stdout<span class=\"token punctuation\">,<\/span> _ <span class=\"token operator\">&#061;<\/span> ssh<span class=\"token punctuation\">.<\/span>exec_command<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;date &#043;%T&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    current_time <span class=\"token operator\">&#061;<\/span> stdout<span class=\"token punctuation\">.<\/span>read<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>decode<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>strip<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    _<span class=\"token punctuation\">,<\/span> stdout<span class=\"token punctuation\">,<\/span> _ <span class=\"token operator\">&#061;<\/span> ssh<span class=\"token punctuation\">.<\/span>exec_command<span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#039;ethtool -S <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>interface<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> | grep -i rdma&#039;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n    rdma_info <span class=\"token operator\">&#061;<\/span> stdout<span class=\"token punctuation\">.<\/span>read<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>decode<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    lines <span class=\"token operator\">&#061;<\/span> rdma_info<span class=\"token punctuation\">.<\/span>split<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\\\\n&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    data <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">{<\/span><span class=\"token punctuation\">}<\/span><br \/>\n    <span class=\"token keyword\">for<\/span> line <span class=\"token keyword\">in<\/span> lines<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">if<\/span> <span class=\"token string\">&#039;rx_vport_rdma_unicast_bytes&#039;<\/span> <span class=\"token keyword\">in<\/span> line<span class=\"token punctuation\">:<\/span><br \/>\n            data<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;rx&#039;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token builtin\">int<\/span><span class=\"token punctuation\">(<\/span>line<span class=\"token punctuation\">.<\/span>split<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;:&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">[<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>strip<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">elif<\/span> <span class=\"token string\">&#039;tx_vport_rdma_unicast_bytes&#039;<\/span> <span class=\"token keyword\">in<\/span> line<span class=\"token punctuation\">:<\/span><br \/>\n            data<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;tx&#039;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token builtin\">int<\/span><span class=\"token punctuation\">(<\/span>line<span class=\"token punctuation\">.<\/span>split<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;:&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">[<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>strip<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">return<\/span> current_time<span class=\"token punctuation\">,<\/span> data<\/p>\n<p><span class=\"token keyword\">def<\/span> <span class=\"token function\">get_nvidia_gpu_info<\/span><span class=\"token punctuation\">(<\/span>server_ip<span class=\"token punctuation\">,<\/span> username<span class=\"token punctuation\">,<\/span> password<span class=\"token punctuation\">,<\/span> total_run_time<span class=\"token punctuation\">,<\/span> interval<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    start_time <span class=\"token operator\">&#061;<\/span> time<span class=\"token punctuation\">.<\/span>time<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    file_path <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;nvidia_gpu_info.xlsx&#039;<\/span><br \/>\n    headers <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;Time&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;GPU&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Temp&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Power Draw&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Max Power Limit&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Tx Throughput&#039;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n               <span class=\"token string\">&#039;Rx Throughput&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;GPU-Util&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Memory-Used&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Memory-Total&#039;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n               <span class=\"token string\">&#039;SM_Clocks&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;SM_MaxClocks&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Memory_Clocks&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Memory_MaxClocks&#039;<\/span><span class=\"token punctuation\">]<\/span><\/p>\n<p>    wb<span class=\"token punctuation\">,<\/span> ws <span class=\"token operator\">&#061;<\/span> initialize_workbook<span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">,<\/span> headers<span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">try<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">while<\/span> time<span class=\"token punctuation\">.<\/span>time<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&#8211;<\/span> start_time <span class=\"token operator\">&lt;<\/span> total_run_time<span class=\"token punctuation\">:<\/span><br \/>\n            ssh <span class=\"token operator\">&#061;<\/span> paramiko<span class=\"token punctuation\">.<\/span>SSHClient<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            ssh<span class=\"token punctuation\">.<\/span>set_missing_host_key_policy<span class=\"token punctuation\">(<\/span>paramiko<span class=\"token punctuation\">.<\/span>AutoAddPolicy<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            ssh<span class=\"token punctuation\">.<\/span>connect<span class=\"token punctuation\">(<\/span>server_ip<span class=\"token punctuation\">,<\/span> username<span class=\"token operator\">&#061;<\/span>username<span class=\"token punctuation\">,<\/span> password<span class=\"token operator\">&#061;<\/span>password<span class=\"token punctuation\">)<\/span><\/p>\n<p>            temp_file <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#034;\/tmp\/gpu_info.txt&#034;<\/span><br \/>\n            combined_command <span class=\"token operator\">&#061;<\/span> <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;<br \/>\nnvidia-smi -q &gt; {temp_file} &amp;&amp;<br \/>\necho &#034;##TIMESTAMP##&#034; &amp;&amp; grep -i Timestamp {temp_file} | grep -v &#039;Latest Timestamp&#039; | sed &#039;s\/.*: \/\/&#039; &amp;&amp;<br \/>\necho &#034;##MINORNUMBER##&#034; &amp;&amp; grep &#039;Minor Number&#039; {temp_file} | awk -F &#039;:&#039; &#039;{{print $2}}&#039; &amp;&amp;<br \/>\necho &#034;##TEMPERATURE##&#034; &amp;&amp; grep -i &#039;GPU Current Temp&#039; {temp_file} | sed &#039;s\/.*: \/\/&#039; &amp;&amp;<br \/>\necho &#034;##POWERDRAW##&#034; &amp;&amp; sed -n -e &#039;\/GPU Power Readings\/,\/Max Power Limit\/p&#039; {temp_file} | grep -E &#039;Power Draw&#039; | sed &#039;s\/.*: \/\/&#039; &amp;&amp;<br \/>\necho &#034;##MAXPOWER##&#034; &amp;&amp; sed -n -e &#039;\/GPU Power Readings\/,\/Max Power Limit\/p&#039; {temp_file} | grep -E &#039;Max Power Limit&#039; | sed &#039;s\/.*: \/\/&#039; &amp;&amp;<br \/>\necho &#034;##TXTHROUGHPUT##&#034; &amp;&amp; grep -i &#039;Tx Throughput&#039; {temp_file} | sed &#039;s\/.*: \/\/&#039; &amp;&amp;<br \/>\necho &#034;##RXTHROUGHPUT##&#034; &amp;&amp; grep -i &#039;Rx Throughput&#039; {temp_file} | sed &#039;s\/.*: \/\/&#039; &amp;&amp;<br \/>\necho &#034;##GPUUTIL##&#034; &amp;&amp; sed -n -e &#039;\/Utilization\/,\/Gpu\/p&#039; {temp_file} | grep -E &#039;Gpu&#039; | sed &#039;s\/.*: \/\/&#039; &amp;&amp;<br \/>\necho &#034;##MEMUSED##&#034; &amp;&amp; sed -n -e &#039;\/FB Memory Usage\/, \/Free\/p&#039; {temp_file} | grep -E &#039;Used&#039; | sed &#039;s\/.*: \/\/&#039; &amp;&amp;<br \/>\necho &#034;##MEMTOTAL##&#034; &amp;&amp; sed -n -e &#039;\/FB Memory Usage\/, \/Free\/p&#039; {temp_file} | grep -E &#039;Total&#039; | sed &#039;s\/.*: \/\/&#039; &amp;&amp;<br \/>\necho &#034;##SMCLOCKS##&#034; &amp;&amp; awk &#039;\/^ *Clocks *$\/{{p&#061;1; count&#061;0; next}} \/^$\/{{p&#061;0}} p{{if (count&lt;4) {{print; count&#043;&#043;}}}}&#039; {temp_file} | awk -F &#039;:&#039; &#039;\/SM\/{{gsub(\/^[ \\\\\\\\\\\\\\\\t]&#043;|[ \\\\\\\\\\\\\\\\t]&#043;$\/, &#034;&#034;, $2); print $2}}&#039; &amp;&amp;<br \/>\necho &#034;##SMMAXCLOCKS##&#034; &amp;&amp; awk &#039;\/^ *Max Clocks *$\/{{p&#061;1; count&#061;0; next}} \/^$\/{{p&#061;0}} p{{if (count&lt;4) {{print; count&#043;&#043;}}}}&#039; {temp_file} | awk -F &#039;:&#039; &#039;\/SM\/{{gsub(\/^[ \\\\\\\\\\\\\\\\t]&#043;|[ \\\\\\\\\\\\\\\\t]&#043;$\/, &#034;&#034;, $2); print $2}}&#039; &amp;&amp;<br \/>\necho &#034;##MEMCLOCKS##&#034; &amp;&amp; awk &#039;\/^ *Clocks *$\/{{p&#061;1; count&#061;0; next}} \/^$\/{{p&#061;0}} p{{if (count&lt;4) {{print; count&#043;&#043;}}}}&#039; {temp_file} | awk -F &#039;:&#039; &#039;\/Memory\/{{gsub(\/^[ \\\\\\\\\\\\\\\\t]&#043;|[ \\\\\\\\\\\\\\\\t]&#043;$\/, &#034;&#034;, $2); print $2}}&#039; &amp;&amp;<br \/>\necho &#034;##MEMMAXCLOCKS##&#034; &amp;&amp; awk &#039;\/^ *Max Clocks *$\/{{p&#061;1; count&#061;0; next}} \/^$\/{{p&#061;0}} p{{if (count&lt;4) {{print; count&#043;&#043;}}}}&#039; {temp_file} | awk -F &#039;:&#039; &#039;\/Memory\/{{gsub(\/^[ \\\\\\\\\\\\\\\\t]&#043;|[ \\\\\\\\\\\\\\\\t]&#043;$\/, &#034;&#034;, $2); print $2}}&#039;<br \/>\n&#034;&#034;&#034;<\/span><span class=\"token punctuation\">.<\/span><span class=\"token builtin\">format<\/span><span class=\"token punctuation\">(<\/span>temp_file<span class=\"token operator\">&#061;<\/span>temp_file<span class=\"token punctuation\">)<\/span><\/p>\n<p>            stdin<span class=\"token punctuation\">,<\/span> stdout<span class=\"token punctuation\">,<\/span> stderr <span class=\"token operator\">&#061;<\/span> ssh<span class=\"token punctuation\">.<\/span>exec_command<span class=\"token punctuation\">(<\/span>combined_command<span class=\"token punctuation\">.<\/span>strip<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            output <span class=\"token operator\">&#061;<\/span> stdout<span class=\"token punctuation\">.<\/span>read<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>decode<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;utf-8&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>strip<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            error <span class=\"token operator\">&#061;<\/span> stderr<span class=\"token punctuation\">.<\/span>read<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>decode<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;utf-8&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>strip<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>            <span class=\"token keyword\">if<\/span> error<span class=\"token punctuation\">:<\/span><br \/>\n                <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;Command execution error: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>error<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n                <span class=\"token keyword\">return<\/span><\/p>\n<p>            markers <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><br \/>\n                <span class=\"token string\">&#034;##TIMESTAMP##&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;##MINORNUMBER##&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;##TEMPERATURE##&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;##POWERDRAW##&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;##MAXPOWER##&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;##TXTHROUGHPUT##&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;##RXTHROUGHPUT##&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;##GPUUTIL##&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;##MEMUSED##&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;##MEMTOTAL##&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;##SMCLOCKS##&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;##SMMAXCLOCKS##&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;##MEMCLOCKS##&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;##MEMMAXCLOCKS##&#034;<\/span><br \/>\n            <span class=\"token punctuation\">]<\/span><\/p>\n<p>            data_dict <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">{<\/span>marker<span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token keyword\">for<\/span> marker <span class=\"token keyword\">in<\/span> markers<span class=\"token punctuation\">}<\/span><br \/>\n            current_marker <span class=\"token operator\">&#061;<\/span> <span class=\"token boolean\">None<\/span><br \/>\n            <span class=\"token keyword\">for<\/span> line <span class=\"token keyword\">in<\/span> output<span class=\"token punctuation\">.<\/span>splitlines<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n                <span class=\"token keyword\">if<\/span> line <span class=\"token keyword\">in<\/span> markers<span class=\"token punctuation\">:<\/span><br \/>\n                    current_marker <span class=\"token operator\">&#061;<\/span> line<br \/>\n                <span class=\"token keyword\">elif<\/span> current_marker<span class=\"token punctuation\">:<\/span><br \/>\n                    data_dict<span class=\"token punctuation\">[<\/span>current_marker<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span>line<span class=\"token punctuation\">)<\/span><\/p>\n<p>            max_row <span class=\"token operator\">&#061;<\/span> ws<span class=\"token punctuation\">.<\/span>max_row<br \/>\n            <span class=\"token keyword\">for<\/span> i<span class=\"token punctuation\">,<\/span> marker <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">enumerate<\/span><span class=\"token punctuation\">(<\/span>markers<span class=\"token punctuation\">,<\/span> start<span class=\"token operator\">&#061;<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n                data_column <span class=\"token operator\">&#061;<\/span> data_dict<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span>marker<span class=\"token punctuation\">,<\/span> <span class=\"token boolean\">None<\/span><span class=\"token punctuation\">)<\/span><br \/>\n                <span class=\"token keyword\">if<\/span> data_column<span class=\"token punctuation\">:<\/span><br \/>\n                    <span class=\"token keyword\">for<\/span> j<span class=\"token punctuation\">,<\/span> data <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">enumerate<\/span><span class=\"token punctuation\">(<\/span>data_column<span class=\"token punctuation\">,<\/span> start<span class=\"token operator\">&#061;<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n                        ws<span class=\"token punctuation\">.<\/span>cell<span class=\"token punctuation\">(<\/span>row<span class=\"token operator\">&#061;<\/span>max_row <span class=\"token operator\">&#043;<\/span> j<span class=\"token punctuation\">,<\/span> column<span class=\"token operator\">&#061;<\/span>i<span class=\"token punctuation\">,<\/span> value<span class=\"token operator\">&#061;<\/span>data<span class=\"token punctuation\">.<\/span>strip<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>            ssh<span class=\"token punctuation\">.<\/span>close<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            time<span class=\"token punctuation\">.<\/span>sleep<span class=\"token punctuation\">(<\/span>interval<span class=\"token punctuation\">)<\/span><\/p>\n<p>        wb<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#039;NVIDIA GPU information has been appended to the file <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>file_path<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#039;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">except<\/span> paramiko<span class=\"token punctuation\">.<\/span>SSHException <span class=\"token keyword\">as<\/span> e<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;SSH connection error: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>e<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;SSH connection error, please check if the server IP, username, and password are correct.&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">except<\/span> Exception <span class=\"token keyword\">as<\/span> e<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;An error occurred: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>e<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token keyword\">def<\/span> <span class=\"token function\">initialize_workbook<\/span><span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">,<\/span> headers<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> os<span class=\"token punctuation\">.<\/span>path<span class=\"token punctuation\">.<\/span>exists<span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        wb <span class=\"token operator\">&#061;<\/span> Workbook<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        ws <span class=\"token operator\">&#061;<\/span> wb<span class=\"token punctuation\">.<\/span>active<br \/>\n        ws<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span>headers<span class=\"token punctuation\">)<\/span><br \/>\n        wb<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">else<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        wb <span class=\"token operator\">&#061;<\/span> load_workbook<span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">)<\/span><br \/>\n        ws <span class=\"token operator\">&#061;<\/span> wb<span class=\"token punctuation\">.<\/span>active<br \/>\n    <span class=\"token keyword\">return<\/span> wb<span class=\"token punctuation\">,<\/span> ws<\/p>\n<p><span class=\"token keyword\">def<\/span> <span class=\"token function\">collect_disk_io_info<\/span><span class=\"token punctuation\">(<\/span>server_ip<span class=\"token punctuation\">,<\/span> username<span class=\"token punctuation\">,<\/span> password<span class=\"token punctuation\">,<\/span> devices<span class=\"token punctuation\">,<\/span> total_run_time<span class=\"token punctuation\">,<\/span> interval<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    start_time <span class=\"token operator\">&#061;<\/span> time<span class=\"token punctuation\">.<\/span>time<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    file_path <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;disk_io_info.xlsx&#039;<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> os<span class=\"token punctuation\">.<\/span>path<span class=\"token punctuation\">.<\/span>exists<span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        wb <span class=\"token operator\">&#061;<\/span> Workbook<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>  <span class=\"token comment\"># \u521b\u5efa\u4e00\u4e2a\u65b0\u7684 Workbook \u5bf9\u8c61<\/span><br \/>\n        ws <span class=\"token operator\">&#061;<\/span> wb<span class=\"token punctuation\">.<\/span>active<br \/>\n        wb<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">try<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">while<\/span> time<span class=\"token punctuation\">.<\/span>time<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&#8211;<\/span> start_time <span class=\"token operator\">&lt;<\/span> total_run_time<span class=\"token punctuation\">:<\/span><br \/>\n            ssh <span class=\"token operator\">&#061;<\/span> paramiko<span class=\"token punctuation\">.<\/span>SSHClient<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            ssh<span class=\"token punctuation\">.<\/span>set_missing_host_key_policy<span class=\"token punctuation\">(<\/span>paramiko<span class=\"token punctuation\">.<\/span>AutoAddPolicy<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            ssh<span class=\"token punctuation\">.<\/span>connect<span class=\"token punctuation\">(<\/span>server_ip<span class=\"token punctuation\">,<\/span> username<span class=\"token operator\">&#061;<\/span>username<span class=\"token punctuation\">,<\/span> password<span class=\"token operator\">&#061;<\/span>password<span class=\"token punctuation\">)<\/span><\/p>\n<p>            <span class=\"token keyword\">for<\/span> device <span class=\"token keyword\">in<\/span> devices<span class=\"token punctuation\">:<\/span><br \/>\n                command <span class=\"token operator\">&#061;<\/span> <span class=\"token string-interpolation\"><span class=\"token string\">f&#034;iostat -xm 1 -d <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>device<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> -t 10 | awk &#039;NR&gt;2 {{print $1, $2, $3, $9}}&#039;&#034;<\/span><\/span><br \/>\n                <span class=\"token comment\"># print(&#034;\u6267\u884c\u7684\u547d\u4ee4\u662f:&#034;, command)<\/span><br \/>\n                stdin<span class=\"token punctuation\">,<\/span> stdout<span class=\"token punctuation\">,<\/span> stderr <span class=\"token operator\">&#061;<\/span> ssh<span class=\"token punctuation\">.<\/span>exec_command<span class=\"token punctuation\">(<\/span>command<span class=\"token punctuation\">)<\/span><br \/>\n                iostat_output <span class=\"token operator\">&#061;<\/span> stdout<span class=\"token punctuation\">.<\/span>readlines<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>  <span class=\"token comment\"># \u83b7\u53d6\u547d\u4ee4\u7684\u6807\u51c6\u8f93\u51fa\u7684\u6240\u6709\u884c<\/span><br \/>\n                ws<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;Iostat output for device: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>device<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>                <span class=\"token comment\"># \u5408\u5e76\u5355\u5143\u683c&#xff0c;\u5c06\u5355\u5143\u683c\u7684\u5bbd\u5ea6\u5408\u5e76\u4e3a4\u4e2a\u5355\u5143\u683c<\/span><br \/>\n                ws<span class=\"token punctuation\">.<\/span>merge_cells<span class=\"token punctuation\">(<\/span>start_row<span class=\"token operator\">&#061;<\/span>ws<span class=\"token punctuation\">.<\/span>max_row<span class=\"token punctuation\">,<\/span> start_column<span class=\"token operator\">&#061;<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> end_row<span class=\"token operator\">&#061;<\/span>ws<span class=\"token punctuation\">.<\/span>max_row<span class=\"token punctuation\">,<\/span> end_column<span class=\"token operator\">&#061;<\/span><span class=\"token number\">4<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>                <span class=\"token keyword\">for<\/span> line <span class=\"token keyword\">in<\/span> iostat_output<span class=\"token punctuation\">:<\/span><br \/>\n                    row_data <span class=\"token operator\">&#061;<\/span> line<span class=\"token punctuation\">.<\/span>strip<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>split<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>  <span class=\"token comment\"># \u4f7f\u7528 split() \u65b9\u6cd5\u6839\u636e\u7a7a\u683c\u62c6\u5206\u6570\u636e<\/span><br \/>\n                    ws<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span>row_data<span class=\"token punctuation\">)<\/span>  <span class=\"token comment\"># \u5c06\u62c6\u5206\u540e\u7684\u6570\u636e\u5199\u5165\u8868\u683c\u4e2d<\/span><\/p>\n<p>            ssh<span class=\"token punctuation\">.<\/span>close<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            time<span class=\"token punctuation\">.<\/span>sleep<span class=\"token punctuation\">(<\/span>interval<span class=\"token punctuation\">)<\/span><\/p>\n<p>        wb<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#039;Disk IO information of server <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>server_ip<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> has been appended to the file <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>file_path<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">.&#039;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">except<\/span> paramiko<span class=\"token punctuation\">.<\/span>SSHException <span class=\"token keyword\">as<\/span> e<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;SSH connection error: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>e<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;SSH connection error, please check if the server IP, username, and password are correct.&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">except<\/span> Exception <span class=\"token keyword\">as<\/span> e<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;Error occurred: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>e<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token keyword\">def<\/span> <span class=\"token function\">get_xpu_gpu_info<\/span><span class=\"token punctuation\">(<\/span>server_ip<span class=\"token punctuation\">,<\/span> username<span class=\"token punctuation\">,<\/span> password<span class=\"token punctuation\">,<\/span> total_run_time<span class=\"token punctuation\">,<\/span> interval<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    start_time <span class=\"token operator\">&#061;<\/span> time<span class=\"token punctuation\">.<\/span>time<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    file_path <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;xpu_gpu_info.xlsx&#039;<\/span><br \/>\n    headers <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;Time&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;DevID&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Temp&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Power Draw&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Power Limit&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;GPU-Util&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Memory-Used&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Memory-Total&#039;<\/span><span class=\"token punctuation\">]<\/span><\/p>\n<p>    wb<span class=\"token punctuation\">,<\/span> ws <span class=\"token operator\">&#061;<\/span> initialize_workbook<span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">,<\/span> headers<span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">try<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">while<\/span> time<span class=\"token punctuation\">.<\/span>time<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&#8211;<\/span> start_time <span class=\"token operator\">&lt;<\/span> total_run_time<span class=\"token punctuation\">:<\/span><br \/>\n            ssh <span class=\"token operator\">&#061;<\/span> paramiko<span class=\"token punctuation\">.<\/span>SSHClient<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            ssh<span class=\"token punctuation\">.<\/span>set_missing_host_key_policy<span class=\"token punctuation\">(<\/span>paramiko<span class=\"token punctuation\">.<\/span>AutoAddPolicy<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            ssh<span class=\"token punctuation\">.<\/span>connect<span class=\"token punctuation\">(<\/span>server_ip<span class=\"token punctuation\">,<\/span> username<span class=\"token operator\">&#061;<\/span>username<span class=\"token punctuation\">,<\/span> password<span class=\"token operator\">&#061;<\/span>password<span class=\"token punctuation\">)<\/span><\/p>\n<p>            commands <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><br \/>\n                <span class=\"token string\">&#034;xpu-smi -q | grep -i Timestamp | grep -v &#039;Latest Timestamp&#039; | sed &#039;s\/.*: \/\/&#039;&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;xpu-smi -q |grep -i &#039;Minor Number&#039; | awk -F &#039;:&#039; &#039;{print $2}&#039;&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;xpu-smi -q | grep -i &#039;XPU Current Temp&#039;  | sed &#039;s\/.*: \/\/&#039;&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;xpu-smi -q | sed -n -e &#039;\/Power Readings\/,\/Power Draw\/p&#039; | grep -E &#039;Power Draw&#039; | sed &#039;s\/.*: \/\/&#039;&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;xpu-smi -q | sed -n -e &#039;\/Power Readings\/,\/Enforced Power Limit\/p&#039; | grep -E &#039;Enforced Power Limit&#039; | sed &#039;s\/.*: \/\/&#039;&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;xpu-smi -q | sed -n -e &#039;\/Utilization\/,\/Xpu\/p&#039; | grep -E &#039;Xpu&#039; | sed &#039;s\/.*: \/\/&#039;&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;xpu-smi -q | sed -n -e &#039;\/Memory Usage\/, \/Free\/p&#039; |grep -E &#039;Used&#039;| sed &#039;s\/.*: \/\/&#039;&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;xpu-smi -q | sed -n -e &#039;\/Memory Usage\/, \/Free\/p&#039; |grep -E &#039;Total&#039;| sed &#039;s\/.*: \/\/&#039;&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            <span class=\"token punctuation\">]<\/span><\/p>\n<p>            max_row <span class=\"token operator\">&#061;<\/span> ws<span class=\"token punctuation\">.<\/span>max_row<br \/>\n            <span class=\"token keyword\">for<\/span> i<span class=\"token punctuation\">,<\/span> command <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">enumerate<\/span><span class=\"token punctuation\">(<\/span>commands<span class=\"token punctuation\">,<\/span> start<span class=\"token operator\">&#061;<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n                stdin<span class=\"token punctuation\">,<\/span> stdout<span class=\"token punctuation\">,<\/span> stderr <span class=\"token operator\">&#061;<\/span> ssh<span class=\"token punctuation\">.<\/span>exec_command<span class=\"token punctuation\">(<\/span>command<span class=\"token punctuation\">)<\/span><br \/>\n                output <span class=\"token operator\">&#061;<\/span> stdout<span class=\"token punctuation\">.<\/span>read<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>decode<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;utf-8&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>strip<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>                <span class=\"token keyword\">if<\/span> output<span class=\"token punctuation\">:<\/span><br \/>\n                    gpu_info <span class=\"token operator\">&#061;<\/span> output<span class=\"token punctuation\">.<\/span>split<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\\\\n&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n                    <span class=\"token keyword\">for<\/span> j<span class=\"token punctuation\">,<\/span> info <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">enumerate<\/span><span class=\"token punctuation\">(<\/span>gpu_info<span class=\"token punctuation\">,<\/span> start<span class=\"token operator\">&#061;<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n                        ws<span class=\"token punctuation\">.<\/span>cell<span class=\"token punctuation\">(<\/span>row<span class=\"token operator\">&#061;<\/span>max_row <span class=\"token operator\">&#043;<\/span> j <span class=\"token operator\">&#043;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> column<span class=\"token operator\">&#061;<\/span>i<span class=\"token punctuation\">,<\/span> value<span class=\"token operator\">&#061;<\/span>info<span class=\"token punctuation\">.<\/span>strip<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>            ssh<span class=\"token punctuation\">.<\/span>close<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            time<span class=\"token punctuation\">.<\/span>sleep<span class=\"token punctuation\">(<\/span>interval<span class=\"token punctuation\">)<\/span><\/p>\n<p>        wb<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#039;GPU information of server <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>server_ip<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> has been appended to the file <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>file_path<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">.&#039;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">except<\/span> paramiko<span class=\"token punctuation\">.<\/span>SSHException <span class=\"token keyword\">as<\/span> e<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;SSH connection error: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>e<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;SSH connection error, please check if the server IP, username, and password are correct.&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">except<\/span> Exception <span class=\"token keyword\">as<\/span> e<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;An error occurred: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>e<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token keyword\">def<\/span> <span class=\"token function\">get_tianshu_gpu_info<\/span><span class=\"token punctuation\">(<\/span>server_ip<span class=\"token punctuation\">,<\/span> username<span class=\"token punctuation\">,<\/span> password<span class=\"token punctuation\">,<\/span> total_run_time<span class=\"token punctuation\">,<\/span> interval<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    start_time <span class=\"token operator\">&#061;<\/span> time<span class=\"token punctuation\">.<\/span>time<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    file_path <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;tianshu_gpu_info.xlsx&#039;<\/span><br \/>\n    headers <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;Time&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;DevID&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Temp&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Power Draw&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Power Limit&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;GPU-Util&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Memory-Used&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Memory-Total&#039;<\/span><span class=\"token punctuation\">]<\/span><\/p>\n<p>    wb<span class=\"token punctuation\">,<\/span> ws <span class=\"token operator\">&#061;<\/span> initialize_workbook<span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">,<\/span> headers<span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">try<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">while<\/span> time<span class=\"token punctuation\">.<\/span>time<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&#8211;<\/span> start_time <span class=\"token operator\">&lt;<\/span> total_run_time<span class=\"token punctuation\">:<\/span><br \/>\n            ssh <span class=\"token operator\">&#061;<\/span> paramiko<span class=\"token punctuation\">.<\/span>SSHClient<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            ssh<span class=\"token punctuation\">.<\/span>set_missing_host_key_policy<span class=\"token punctuation\">(<\/span>paramiko<span class=\"token punctuation\">.<\/span>AutoAddPolicy<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            ssh<span class=\"token punctuation\">.<\/span>connect<span class=\"token punctuation\">(<\/span>server_ip<span class=\"token punctuation\">,<\/span> username<span class=\"token operator\">&#061;<\/span>username<span class=\"token punctuation\">,<\/span> password<span class=\"token operator\">&#061;<\/span>password<span class=\"token punctuation\">)<\/span><\/p>\n<p>            commands <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><br \/>\n                <span class=\"token string\">&#034;ixsmi -q | grep -i Timestamp | grep -v &#039;Latest Timestamp&#039; | sed &#039;s\/.*: \/\/&#039;&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;ixsmi -q |grep -i &#039;Minor Number&#039; | awk -F &#039;:&#039; &#039;{print $2}&#039;&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;ixsmi -q | grep -i &#039;GPU Current Temp&#039;  | sed &#039;s\/.*: \/\/&#039;&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;ixsmi -q | sed -n -e &#039;\/Power Readings\/,\/GPU Power Draw\/p&#039; | grep -E &#039;Power Draw&#039; | sed &#039;s\/.*: \/\/&#039;&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;ixsmi -q | sed -n -e &#039;\/Power Readings\/,\/GPU Power Limit\/p&#039; | grep -E &#039;Power Limit&#039; | sed &#039;s\/.*: \/\/&#039;&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;ixsmi -q | sed -n -e &#039;\/Utilization\/,\/Gpu\/p&#039; | grep -E &#039;Gpu&#039; | sed &#039;s\/.*: \/\/&#039;&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;ixsmi -q | sed -n -e &#039;\/Memory Usage\/, \/Free\/p&#039; |grep -E &#039;Used&#039;| sed &#039;s\/.*: \/\/&#039;&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;ixsmi -q | sed -n -e &#039;\/Memory Usage\/, \/Free\/p&#039; |grep -E &#039;Total&#039;| sed &#039;s\/.*: \/\/&#039;&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            <span class=\"token punctuation\">]<\/span><\/p>\n<p>            max_row <span class=\"token operator\">&#061;<\/span> ws<span class=\"token punctuation\">.<\/span>max_row<br \/>\n            <span class=\"token keyword\">for<\/span> i<span class=\"token punctuation\">,<\/span> command <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">enumerate<\/span><span class=\"token punctuation\">(<\/span>commands<span class=\"token punctuation\">,<\/span> start<span class=\"token operator\">&#061;<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n                stdin<span class=\"token punctuation\">,<\/span> stdout<span class=\"token punctuation\">,<\/span> stderr <span class=\"token operator\">&#061;<\/span> ssh<span class=\"token punctuation\">.<\/span>exec_command<span class=\"token punctuation\">(<\/span>command<span class=\"token punctuation\">)<\/span><br \/>\n                output <span class=\"token operator\">&#061;<\/span> stdout<span class=\"token punctuation\">.<\/span>read<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>decode<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;utf-8&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>strip<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>                <span class=\"token keyword\">if<\/span> output<span class=\"token punctuation\">:<\/span><br \/>\n                    gpu_info <span class=\"token operator\">&#061;<\/span> output<span class=\"token punctuation\">.<\/span>split<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\\\\n&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n                    <span class=\"token keyword\">for<\/span> j<span class=\"token punctuation\">,<\/span> info <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">enumerate<\/span><span class=\"token punctuation\">(<\/span>gpu_info<span class=\"token punctuation\">,<\/span> start<span class=\"token operator\">&#061;<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n                        ws<span class=\"token punctuation\">.<\/span>cell<span class=\"token punctuation\">(<\/span>row<span class=\"token operator\">&#061;<\/span>max_row <span class=\"token operator\">&#043;<\/span> j <span class=\"token operator\">&#043;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> column<span class=\"token operator\">&#061;<\/span>i<span class=\"token punctuation\">,<\/span> value<span class=\"token operator\">&#061;<\/span>info<span class=\"token punctuation\">.<\/span>strip<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>            ssh<span class=\"token punctuation\">.<\/span>close<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            time<span class=\"token punctuation\">.<\/span>sleep<span class=\"token punctuation\">(<\/span>interval<span class=\"token punctuation\">)<\/span><\/p>\n<p>        wb<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#039;GPU information of server <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>server_ip<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> has been appended to the file <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>file_path<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">.&#039;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">except<\/span> paramiko<span class=\"token punctuation\">.<\/span>SSHException <span class=\"token keyword\">as<\/span> e<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;SSH connection error: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>e<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;SSH connection error, please check if the server IP, username, and password are correct.&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">except<\/span> Exception <span class=\"token keyword\">as<\/span> e<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;An error occurred: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>e<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token keyword\">def<\/span> <span class=\"token function\">process_excel<\/span><span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token comment\"># \u8bfb\u53d6\u539f\u59cb\u8868\u683c<\/span><br \/>\n    file_path <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;disk_io_info.xlsx&#039;<\/span><br \/>\n    wb <span class=\"token operator\">&#061;<\/span> load_workbook<span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">)<\/span><br \/>\n    ws <span class=\"token operator\">&#061;<\/span> wb<span class=\"token punctuation\">.<\/span>active<\/p>\n<p>    data <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span><br \/>\n    collecting_data <span class=\"token operator\">&#061;<\/span> <span class=\"token boolean\">False<\/span><br \/>\n    current_time <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#034;&#034;<\/span><\/p>\n<p>    <span class=\"token comment\"># \u9010\u884c\u68c0\u67e5\u6570\u636e&#xff0c;\u63d0\u53d6\u9700\u8981\u7684\u4fe1\u606f<\/span><br \/>\n    <span class=\"token keyword\">for<\/span> row <span class=\"token keyword\">in<\/span> ws<span class=\"token punctuation\">.<\/span>iter_rows<span class=\"token punctuation\">(<\/span>values_only<span class=\"token operator\">&#061;<\/span><span class=\"token boolean\">True<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">if<\/span> row<span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token keyword\">and<\/span> <span class=\"token string\">&#039;\/&#039;<\/span> <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">str<\/span><span class=\"token punctuation\">(<\/span>row<span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>  <span class=\"token comment\"># \u5224\u65ad\u662f\u5426\u4e3a\u65e5\u671f\u65f6\u95f4\u884c<\/span><br \/>\n            current_time <span class=\"token operator\">&#061;<\/span> <span class=\"token string-interpolation\"><span class=\"token string\">f&#034;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>row<span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>row<span class=\"token punctuation\">[<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span>  <span class=\"token comment\"># \u5c06\u65e5\u671f\u548c\u65f6\u95f4\u62fc\u63a5\u8d77\u6765<\/span><br \/>\n        <span class=\"token keyword\">elif<\/span> row<span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;&#061;<\/span> <span class=\"token string\">&#034;Device&#034;<\/span> <span class=\"token keyword\">and<\/span> row<span class=\"token punctuation\">[<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;&#061;<\/span> <span class=\"token string\">&#034;r\/s&#034;<\/span> <span class=\"token keyword\">and<\/span> row<span class=\"token punctuation\">[<\/span><span class=\"token number\">2<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;&#061;<\/span> <span class=\"token string\">&#034;rMB\/s&#034;<\/span> <span class=\"token keyword\">and<\/span> row<span class=\"token punctuation\">[<\/span><span class=\"token number\">3<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;&#061;<\/span> <span class=\"token string\">&#034;wMB\/s&#034;<\/span><span class=\"token punctuation\">:<\/span>  <span class=\"token comment\"># \u786e\u8ba4\u662f\u6570\u636e\u6807\u9898\u884c<\/span><br \/>\n            collecting_data <span class=\"token operator\">&#061;<\/span> <span class=\"token boolean\">True<\/span><br \/>\n        <span class=\"token keyword\">elif<\/span> collecting_data <span class=\"token keyword\">and<\/span> row<span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token keyword\">and<\/span> row<span class=\"token punctuation\">[<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token keyword\">and<\/span> row<span class=\"token punctuation\">[<\/span><span class=\"token number\">2<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token keyword\">and<\/span> row<span class=\"token punctuation\">[<\/span><span class=\"token number\">3<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">:<\/span>  <span class=\"token comment\"># \u786e\u8ba4\u662f\u6570\u636e\u884c<\/span><br \/>\n            device <span class=\"token operator\">&#061;<\/span> row<span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span><br \/>\n            rMB_s <span class=\"token operator\">&#061;<\/span> row<span class=\"token punctuation\">[<\/span><span class=\"token number\">2<\/span><span class=\"token punctuation\">]<\/span><br \/>\n            wMB_s <span class=\"token operator\">&#061;<\/span> row<span class=\"token punctuation\">[<\/span><span class=\"token number\">3<\/span><span class=\"token punctuation\">]<\/span><br \/>\n            data<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">[<\/span>current_time<span class=\"token punctuation\">,<\/span> device<span class=\"token punctuation\">,<\/span> rMB_s<span class=\"token punctuation\">,<\/span> wMB_s<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token comment\"># \u5982\u679c\u6709\u6570\u636e\u624d\u7ee7\u7eed\u521b\u5efa\u65b0\u7684\u8868\u683c<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> data<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token comment\"># \u6784\u5efa\u65b0\u7684\u6570\u636e\u8868\u683c<\/span><br \/>\n        new_df <span class=\"token operator\">&#061;<\/span> pd<span class=\"token punctuation\">.<\/span>DataFrame<span class=\"token punctuation\">(<\/span>data<span class=\"token punctuation\">,<\/span> columns<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;Time&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;Device&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;rMB\/s&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;wMB\/s&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>        <span class=\"token comment\"># \u5c06\u65b0\u6570\u636e\u5199\u5165\u65b0\u7684 Excel \u8868\u683c<\/span><br \/>\n        new_file_path <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;new_disk_io_info.xlsx&#039;<\/span><br \/>\n        new_df<span class=\"token punctuation\">.<\/span>to_excel<span class=\"token punctuation\">(<\/span>new_file_path<span class=\"token punctuation\">,<\/span> index<span class=\"token operator\">&#061;<\/span><span class=\"token boolean\">False<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;\u65b0\u8868\u683c\u751f\u6210\u5b8c\u6210: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>new_file_path<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token comment\"># \u5220\u9664\u539f\u59cb Excel \u6587\u4ef6<\/span><br \/>\n        os<span class=\"token punctuation\">.<\/span>remove<span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;\u539f\u59cb Excel \u6587\u4ef6 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>file_path<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> \u5df2\u88ab\u5220\u9664&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">else<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;\u6ca1\u6709\u627e\u5230\u7b26\u5408\u6761\u4ef6\u7684\u6570\u636e&#034;<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token keyword\">def<\/span> <span class=\"token function\">merge_excel_files<\/span><span class=\"token punctuation\">(<\/span>output_file_name<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    merged_wb <span class=\"token operator\">&#061;<\/span> Workbook<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    file_list <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token builtin\">file<\/span> <span class=\"token keyword\">for<\/span> <span class=\"token builtin\">file<\/span> <span class=\"token keyword\">in<\/span> os<span class=\"token punctuation\">.<\/span>listdir<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">if<\/span> <span class=\"token builtin\">file<\/span><span class=\"token punctuation\">.<\/span>endswith<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;.xlsx&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">]<\/span><\/p>\n<p>    <span class=\"token keyword\">for<\/span> file_name <span class=\"token keyword\">in<\/span> file_list<span class=\"token punctuation\">:<\/span><br \/>\n        wb <span class=\"token operator\">&#061;<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename<span class=\"token operator\">&#061;<\/span>file_name<span class=\"token punctuation\">,<\/span> data_only<span class=\"token operator\">&#061;<\/span><span class=\"token boolean\">True<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        ws <span class=\"token operator\">&#061;<\/span> wb<span class=\"token punctuation\">.<\/span>active<br \/>\n        new_ws <span class=\"token operator\">&#061;<\/span> merged_wb<span class=\"token punctuation\">.<\/span>create_sheet<span class=\"token punctuation\">(<\/span>title<span class=\"token operator\">&#061;<\/span>os<span class=\"token punctuation\">.<\/span>path<span class=\"token punctuation\">.<\/span>splitext<span class=\"token punctuation\">(<\/span>file_name<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">for<\/span> row <span class=\"token keyword\">in<\/span> ws<span class=\"token punctuation\">.<\/span>iter_rows<span class=\"token punctuation\">(<\/span>values_only<span class=\"token operator\">&#061;<\/span><span class=\"token boolean\">True<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n            new_ws<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span>row<span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token comment\"># Save the merged Excel file<\/span><br \/>\n    merged_wb<span class=\"token punctuation\">.<\/span>remove<span class=\"token punctuation\">(<\/span>merged_wb<span class=\"token punctuation\">.<\/span>active<span class=\"token punctuation\">)<\/span><br \/>\n    merged_wb<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>output_file_name<span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#039;Merged Excel files saved to: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>output_file_name<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#039;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token keyword\">def<\/span> <span class=\"token function\">main<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    root <span class=\"token operator\">&#061;<\/span> tk<span class=\"token punctuation\">.<\/span>Tk<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    root<span class=\"token punctuation\">.<\/span>withdraw<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">while<\/span> <span class=\"token boolean\">True<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        dialog <span class=\"token operator\">&#061;<\/span> CustomDialog<span class=\"token punctuation\">(<\/span>root<span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;\u8bf7\u8f93\u5165\u670d\u52a1\u5668\u4fe1\u606f&#034;<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>        <span class=\"token keyword\">if<\/span> dialog<span class=\"token punctuation\">.<\/span>result<span class=\"token punctuation\">:<\/span><br \/>\n            server_ip<span class=\"token punctuation\">,<\/span> username<span class=\"token punctuation\">,<\/span> password<span class=\"token punctuation\">,<\/span> selected_devices<span class=\"token punctuation\">,<\/span> selected_gpus<span class=\"token punctuation\">,<\/span> total_run_time<span class=\"token punctuation\">,<\/span> interval <span class=\"token operator\">&#061;<\/span> dialog<span class=\"token punctuation\">.<\/span>result<br \/>\n            interval <span class=\"token operator\">&#061;<\/span> <span class=\"token builtin\">int<\/span><span class=\"token punctuation\">(<\/span>interval<span class=\"token punctuation\">)<\/span>  <span class=\"token comment\"># \u786e\u4fdd\u95f4\u9694\u65f6\u95f4\u662f\u6574\u6570<\/span><br \/>\n            total_run_time <span class=\"token operator\">&#061;<\/span> <span class=\"token builtin\">int<\/span><span class=\"token punctuation\">(<\/span>total_run_time<span class=\"token punctuation\">)<\/span><\/p>\n<p>            processes <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span><\/p>\n<p>            <span class=\"token keyword\">if<\/span> selected_devices<span class=\"token punctuation\">:<\/span><br \/>\n                p_disk_io <span class=\"token operator\">&#061;<\/span> multiprocessing<span class=\"token punctuation\">.<\/span>Process<span class=\"token punctuation\">(<\/span>target<span class=\"token operator\">&#061;<\/span>collect_disk_io_info<span class=\"token punctuation\">,<\/span> args<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">(<\/span><br \/>\n                server_ip<span class=\"token punctuation\">,<\/span> username<span class=\"token punctuation\">,<\/span> password<span class=\"token punctuation\">,<\/span> selected_devices<span class=\"token punctuation\">,<\/span> total_run_time<span class=\"token punctuation\">,<\/span> interval<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n                processes<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span>p_disk_io<span class=\"token punctuation\">)<\/span><\/p>\n<p>            p_memory <span class=\"token operator\">&#061;<\/span> multiprocessing<span class=\"token punctuation\">.<\/span>Process<span class=\"token punctuation\">(<\/span>target<span class=\"token operator\">&#061;<\/span>get_memory_info<span class=\"token punctuation\">,<\/span><br \/>\n                                               args<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">(<\/span>server_ip<span class=\"token punctuation\">,<\/span> username<span class=\"token punctuation\">,<\/span> password<span class=\"token punctuation\">,<\/span> total_run_time<span class=\"token punctuation\">,<\/span> interval<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            processes<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span>p_memory<span class=\"token punctuation\">)<\/span><\/p>\n<p>            p_cpu <span class=\"token operator\">&#061;<\/span> multiprocessing<span class=\"token punctuation\">.<\/span>Process<span class=\"token punctuation\">(<\/span>target<span class=\"token operator\">&#061;<\/span>get_cpu_info<span class=\"token punctuation\">,<\/span><br \/>\n                                            args<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">(<\/span>server_ip<span class=\"token punctuation\">,<\/span> username<span class=\"token punctuation\">,<\/span> password<span class=\"token punctuation\">,<\/span> total_run_time<span class=\"token punctuation\">,<\/span> interval<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            processes<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span>p_cpu<span class=\"token punctuation\">)<\/span><\/p>\n<p>            p_network <span class=\"token operator\">&#061;<\/span> multiprocessing<span class=\"token punctuation\">.<\/span>Process<span class=\"token punctuation\">(<\/span>target<span class=\"token operator\">&#061;<\/span>get_network_info<span class=\"token punctuation\">,<\/span><br \/>\n                                                args<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">(<\/span>server_ip<span class=\"token punctuation\">,<\/span> username<span class=\"token punctuation\">,<\/span> password<span class=\"token punctuation\">,<\/span> total_run_time<span class=\"token punctuation\">,<\/span> interval<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            processes<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span>p_network<span class=\"token punctuation\">)<\/span><\/p>\n<p>            <span class=\"token keyword\">for<\/span> selected_gpu <span class=\"token keyword\">in<\/span> selected_gpus<span class=\"token punctuation\">:<\/span><br \/>\n                <span class=\"token keyword\">if<\/span> selected_gpu<span class=\"token punctuation\">.<\/span>startswith<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;xpu&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n                    p_xpu_gpu <span class=\"token operator\">&#061;<\/span> multiprocessing<span class=\"token punctuation\">.<\/span>Process<span class=\"token punctuation\">(<\/span>target<span class=\"token operator\">&#061;<\/span>get_xpu_gpu_info<span class=\"token punctuation\">,<\/span><br \/>\n                                                        args<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">(<\/span>server_ip<span class=\"token punctuation\">,<\/span> username<span class=\"token punctuation\">,<\/span> password<span class=\"token punctuation\">,<\/span> total_run_time<span class=\"token punctuation\">,<\/span> interval<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n                    processes<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span>p_xpu_gpu<span class=\"token punctuation\">)<\/span><br \/>\n                <span class=\"token keyword\">elif<\/span> selected_gpu<span class=\"token punctuation\">.<\/span>startswith<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;nvidia&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n                    p_nvidia_gpu <span class=\"token operator\">&#061;<\/span> multiprocessing<span class=\"token punctuation\">.<\/span>Process<span class=\"token punctuation\">(<\/span>target<span class=\"token operator\">&#061;<\/span>get_nvidia_gpu_info<span class=\"token punctuation\">,<\/span> args<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">(<\/span><br \/>\n                    server_ip<span class=\"token punctuation\">,<\/span> username<span class=\"token punctuation\">,<\/span> password<span class=\"token punctuation\">,<\/span> total_run_time<span class=\"token punctuation\">,<\/span> interval<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n                    processes<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span>p_nvidia_gpu<span class=\"token punctuation\">)<\/span><br \/>\n                <span class=\"token keyword\">elif<\/span> selected_gpu<span class=\"token punctuation\">.<\/span>startswith<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;tianshu&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n                    p_tianshu_gpu <span class=\"token operator\">&#061;<\/span> multiprocessing<span class=\"token punctuation\">.<\/span>Process<span class=\"token punctuation\">(<\/span>target<span class=\"token operator\">&#061;<\/span>get_tianshu_gpu_info<span class=\"token punctuation\">,<\/span> args<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">(<\/span><br \/>\n                    server_ip<span class=\"token punctuation\">,<\/span> username<span class=\"token punctuation\">,<\/span> password<span class=\"token punctuation\">,<\/span> total_run_time<span class=\"token punctuation\">,<\/span> interval<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n                    processes<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span>p_tianshu_gpu<span class=\"token punctuation\">)<\/span><br \/>\n                <span class=\"token keyword\">else<\/span><span class=\"token punctuation\">:<\/span><br \/>\n                    <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;Unknown GPU type: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>selected_gpu<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>            <span class=\"token comment\"># \u542f\u52a8\u6240\u6709\u8fdb\u7a0b<\/span><br \/>\n            <span class=\"token keyword\">for<\/span> process <span class=\"token keyword\">in<\/span> processes<span class=\"token punctuation\">:<\/span><br \/>\n                process<span class=\"token punctuation\">.<\/span>start<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>            <span class=\"token comment\"># \u7b49\u5f85\u6240\u6709\u8fdb\u7a0b\u5b8c\u6210<\/span><br \/>\n            <span class=\"token keyword\">for<\/span> process <span class=\"token keyword\">in<\/span> processes<span class=\"token punctuation\">:<\/span><br \/>\n                process<span class=\"token punctuation\">.<\/span>join<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>            file_path <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;disk_io_info.xlsx&#039;<\/span><br \/>\n            <span class=\"token keyword\">if<\/span> os<span class=\"token punctuation\">.<\/span>path<span class=\"token punctuation\">.<\/span>exists<span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n                process_excel<span class=\"token punctuation\">(<\/span>file_path<span class=\"token punctuation\">)<\/span><br \/>\n            <span class=\"token keyword\">else<\/span><span class=\"token punctuation\">:<\/span><br \/>\n                <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;\u539f\u59cb Excel \u6587\u4ef6 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>file_path<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> \u4e0d\u5b58\u5728&#xff0c;\u65e0\u6cd5\u6267\u884c process_excel \u51fd\u6570\u3002&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>            merge_excel_files<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;merged_file.xlsx&#039;<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>            label <span class=\"token operator\">&#061;<\/span> tk<span class=\"token punctuation\">.<\/span>Label<span class=\"token punctuation\">(<\/span>root<span class=\"token punctuation\">,<\/span> text<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;\u4fe1\u606f\u5df2\u6536\u96c6\u5e76\u4fdd\u5b58\u81f3\u76f8\u5e94\u6587\u4ef6&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            label<span class=\"token punctuation\">.<\/span>pack<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">else<\/span><span class=\"token punctuation\">:<\/span><br \/>\n            <span class=\"token keyword\">break<\/span><\/p>\n<p>    close_button <span class=\"token operator\">&#061;<\/span> tk<span class=\"token punctuation\">.<\/span>Button<span class=\"token punctuation\">(<\/span>root<span class=\"token punctuation\">,<\/span> text<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;\u5173\u95ed&#034;<\/span><span class=\"token punctuation\">,<\/span> command<span class=\"token operator\">&#061;<\/span>root<span class=\"token punctuation\">.<\/span>destroy<span class=\"token punctuation\">)<\/span><br \/>\n    close_button<span class=\"token punctuation\">.<\/span>pack<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    root<span class=\"token punctuation\">.<\/span>mainloop<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token keyword\">if<\/span> __name__ <span class=\"token operator\">&#061;&#061;<\/span> <span class=\"token string\">&#034;__main__&#034;<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    main<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb1.9k\u6b21\uff0c\u70b9\u8d5e39\u6b21\uff0c\u6536\u85cf26\u6b21\u3002\u6807\u9898\u4f7f\u7528 Paramiko \u548c Tkinter \u5b9e\u73b0\u8fdc\u7a0b\u670d\u52a1\u5668\u4fe1\u606f\u91c7\u96c6\u5de5\u5177\u7b80\u4ecb\u8fd9\u7bc7\u6587\u6863\u4ecb\u7ecd\u4e86\u4e00\u6b3e\u4f7f\u7528 Paramiko\u3001Tkinter \u548c Openpyxl \u5f00\u53d1\u7684\u8fdc\u7a0b\u670d\u52a1\u5668\u4fe1\u606f\u91c7\u96c6\u5de5\u5177\u3002\u7528\u6237\u53ef\u4ee5\u901a\u8fc7\u4e00\u4e2a\u7b80\u5355\u7684\u56fe\u5f62\u754c\u9762\u5bf9\u591a\u4e2a\u670d\u52a1\u5668\u6267\u884cCPU\u3001\u5185\u5b58\u3001\u7f51\u7edc\u3001\u78c1\u76d8\u53caGPU\u7b49\u6570\u636e\u7684\u91c7\u96c6\uff0c\u5e76\u5c06\u7ed3\u679c\u4fdd\u5b58\u81f3Excel\u6587\u4ef6\u4e2d\u3002\u529f\u80fd\u7279\u70b9\u901a\u8fc7SSH\u8fde\u63a5\u8fdc\u7a0b\u670d\u52a1\u5668\u91c7\u96c6\u4fe1\u606f\u652f\u6301\u591a\u79cd\u4fe1\u606f\u7c7b\u578b\uff1a\u5185\u5b58\u3001CPU\u3001\u78c1\u76d8IO\u3001\u7f51\u7edc\u4fe1\u606f\u53caGPU\u4fe1\u606f\u6570\u636e\u81ea\u52a8\u4fdd\u5b58\u81f3Excel\u6587\u4ef6\uff0c\u5e76\u63d0\u4f9b\u5408\u5e76\u529f\u80fd\u652f\u6301\u591a\u79cdGPU\u7c7b\u578b\uff08NVIDIA\u3001_\u6293\u53d6\u670d\u52a1\u5668\u72b6\u6001\u4fe1\u606f\u7684\u811a\u672c\u7a0b\u5e8f<\/p>\n","protected":false},"author":2,"featured_media":31630,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[81,43,44],"topic":[],"class_list":["post-31631","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-python","tag-43","tag-44"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u83b7\u53d6\u670d\u52a1\u5668\u4fe1\u606f\u76f8\u5173\u811a\u672c - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/31631.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u83b7\u53d6\u670d\u52a1\u5668\u4fe1\u606f\u76f8\u5173\u811a\u672c - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb1.9k\u6b21\uff0c\u70b9\u8d5e39\u6b21\uff0c\u6536\u85cf26\u6b21\u3002\u6807\u9898\u4f7f\u7528 Paramiko \u548c Tkinter \u5b9e\u73b0\u8fdc\u7a0b\u670d\u52a1\u5668\u4fe1\u606f\u91c7\u96c6\u5de5\u5177\u7b80\u4ecb\u8fd9\u7bc7\u6587\u6863\u4ecb\u7ecd\u4e86\u4e00\u6b3e\u4f7f\u7528 Paramiko\u3001Tkinter \u548c Openpyxl \u5f00\u53d1\u7684\u8fdc\u7a0b\u670d\u52a1\u5668\u4fe1\u606f\u91c7\u96c6\u5de5\u5177\u3002\u7528\u6237\u53ef\u4ee5\u901a\u8fc7\u4e00\u4e2a\u7b80\u5355\u7684\u56fe\u5f62\u754c\u9762\u5bf9\u591a\u4e2a\u670d\u52a1\u5668\u6267\u884cCPU\u3001\u5185\u5b58\u3001\u7f51\u7edc\u3001\u78c1\u76d8\u53caGPU\u7b49\u6570\u636e\u7684\u91c7\u96c6\uff0c\u5e76\u5c06\u7ed3\u679c\u4fdd\u5b58\u81f3Excel\u6587\u4ef6\u4e2d\u3002\u529f\u80fd\u7279\u70b9\u901a\u8fc7SSH\u8fde\u63a5\u8fdc\u7a0b\u670d\u52a1\u5668\u91c7\u96c6\u4fe1\u606f\u652f\u6301\u591a\u79cd\u4fe1\u606f\u7c7b\u578b\uff1a\u5185\u5b58\u3001CPU\u3001\u78c1\u76d8IO\u3001\u7f51\u7edc\u4fe1\u606f\u53caGPU\u4fe1\u606f\u6570\u636e\u81ea\u52a8\u4fdd\u5b58\u81f3Excel\u6587\u4ef6\uff0c\u5e76\u63d0\u4f9b\u5408\u5e76\u529f\u80fd\u652f\u6301\u591a\u79cdGPU\u7c7b\u578b\uff08NVIDIA\u3001_\u6293\u53d6\u670d\u52a1\u5668\u72b6\u6001\u4fe1\u606f\u7684\u811a\u672c\u7a0b\u5e8f\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/31631.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-21T16:55:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250421165557-6806789d792c7.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/31631.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/31631.html\",\"name\":\"\u83b7\u53d6\u670d\u52a1\u5668\u4fe1\u606f\u76f8\u5173\u811a\u672c - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2025-04-21T16:55:58+00:00\",\"dateModified\":\"2025-04-21T16:55:58+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/31631.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/31631.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/31631.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u83b7\u53d6\u670d\u52a1\u5668\u4fe1\u606f\u76f8\u5173\u811a\u672c\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u83b7\u53d6\u670d\u52a1\u5668\u4fe1\u606f\u76f8\u5173\u811a\u672c - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/31631.html","og_locale":"zh_CN","og_type":"article","og_title":"\u83b7\u53d6\u670d\u52a1\u5668\u4fe1\u606f\u76f8\u5173\u811a\u672c - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb1.9k\u6b21\uff0c\u70b9\u8d5e39\u6b21\uff0c\u6536\u85cf26\u6b21\u3002\u6807\u9898\u4f7f\u7528 Paramiko \u548c Tkinter \u5b9e\u73b0\u8fdc\u7a0b\u670d\u52a1\u5668\u4fe1\u606f\u91c7\u96c6\u5de5\u5177\u7b80\u4ecb\u8fd9\u7bc7\u6587\u6863\u4ecb\u7ecd\u4e86\u4e00\u6b3e\u4f7f\u7528 Paramiko\u3001Tkinter \u548c Openpyxl \u5f00\u53d1\u7684\u8fdc\u7a0b\u670d\u52a1\u5668\u4fe1\u606f\u91c7\u96c6\u5de5\u5177\u3002\u7528\u6237\u53ef\u4ee5\u901a\u8fc7\u4e00\u4e2a\u7b80\u5355\u7684\u56fe\u5f62\u754c\u9762\u5bf9\u591a\u4e2a\u670d\u52a1\u5668\u6267\u884cCPU\u3001\u5185\u5b58\u3001\u7f51\u7edc\u3001\u78c1\u76d8\u53caGPU\u7b49\u6570\u636e\u7684\u91c7\u96c6\uff0c\u5e76\u5c06\u7ed3\u679c\u4fdd\u5b58\u81f3Excel\u6587\u4ef6\u4e2d\u3002\u529f\u80fd\u7279\u70b9\u901a\u8fc7SSH\u8fde\u63a5\u8fdc\u7a0b\u670d\u52a1\u5668\u91c7\u96c6\u4fe1\u606f\u652f\u6301\u591a\u79cd\u4fe1\u606f\u7c7b\u578b\uff1a\u5185\u5b58\u3001CPU\u3001\u78c1\u76d8IO\u3001\u7f51\u7edc\u4fe1\u606f\u53caGPU\u4fe1\u606f\u6570\u636e\u81ea\u52a8\u4fdd\u5b58\u81f3Excel\u6587\u4ef6\uff0c\u5e76\u63d0\u4f9b\u5408\u5e76\u529f\u80fd\u652f\u6301\u591a\u79cdGPU\u7c7b\u578b\uff08NVIDIA\u3001_\u6293\u53d6\u670d\u52a1\u5668\u72b6\u6001\u4fe1\u606f\u7684\u811a\u672c\u7a0b\u5e8f","og_url":"https:\/\/www.wsisp.com\/helps\/31631.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2025-04-21T16:55:58+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250421165557-6806789d792c7.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"16 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/31631.html","url":"https:\/\/www.wsisp.com\/helps\/31631.html","name":"\u83b7\u53d6\u670d\u52a1\u5668\u4fe1\u606f\u76f8\u5173\u811a\u672c - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2025-04-21T16:55:58+00:00","dateModified":"2025-04-21T16:55:58+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/31631.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/31631.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/31631.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"\u83b7\u53d6\u670d\u52a1\u5668\u4fe1\u606f\u76f8\u5173\u811a\u672c"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/31631","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=31631"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/31631\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/31630"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=31631"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=31631"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=31631"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=31631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}