基于大数据下冶金行业钢后MES系统数据库服务器治理探索  

Exploration on Big Data Database Server Governance of Steel Rear MES System in Metallurgical Industry

作　　者：郭凌宙 郑芳 Guo Lingzhou;Zheng Fang(Fujian Sanming Iron&Steel Group,Sanming 365000,Fujian)

机构地区：[1]福建省三钢〔集团〕有限责任公司,福建三明365000

出　　处：《福建冶金》2023年第5期79-82,共4页Fujian Metallurgy

摘　　要：本文针对某钢铁企业正在进行智能制造、数字化转型、智慧管控中心项目建设需要对原钢后MES系统进行数据抽取,进行大数据呈现,由此给原有钢后MES系统数据库服务器性能造成巨大影响的问题,通过Linux主机优化,RAC集群参数优化,SQL优化手段,可以有效提升数据库服务器性能,更好对智慧管控中心提供数据服务。由优化前后的性能指标(主机CPU利用率,逻辑读,响应时间)对比可得,数据库服务器整体性能提升了3倍。In this paper,a steel enterprise is carrying out Intelligent Manufacturing,Digital Transformation,project of Management and Control Center data extraction needs to be used for the existing steel rear MES system data processing,transmission,to provide support for the big data presentation.The database server performance of the original steel rear MES system is greatly affected.To solve the problem,through Linux host optimization,RAC cluster parameter optimization,SQL optimization,we can effectively improve the database server performance,to provide data services for the Intelligent Management and Control Center.Before and after tuning the DB and host performance index(CPU usage,logical read,and response time)are compared.The general performance of the DB server is improved by 3 times.

关 键 词：大数据 服务器 RAC 执行计划 代码优化 

分 类 号：TF34[冶金工程—冶金机械及自动化] TP311.13[自动化与计算机技术—计算机软件与理论]