2024年2月7日发(作者：)

829363738394647484956575859606162 hadoop-common 3.0.3 guava hadoop-streaming 3.0.3 hadoop-yarn-common 3.0.3 guava hadoop-distcp 3.0.3 provided hadoop-mapreduce-client-core 3.0.3 guava hadoop-hdfs 3.0.3 guava hadoop-mapreduce-client-jobclient 3.0.3 provided

模块配置化对象：82936373839464748package ;

import p;import ;

import RegistrationBean;import tRegistrationBean;import ;import uration;

import ewServlet;import tFilter;/** * druid 监控配置 * @author zzg * */@Configurationpublic class DruidConfig { @Bean public ServletRegistrationBean druidServletRegistrationBean() { ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(); vlet(new StatViewServlet()); Mappings("/druid/*"); tParameter("allow", ""); tParameter("deny", ""); tParameter("loginUsername", "admin"); tParameter("loginPassword", "admin"); return servletRegistrationBean; }

/** * 注册DruidFilter拦截 * * @return */ @Bean public FilterRegistrationBean duridFilterRegistrationBean() { FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(); ter(new WebStatFilter()); Map initParams = new HashMap(); //设置忽略请求 ("exclusions", "*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*"); tParameters(initParams); Patterns("/*"); return filterRegistrationBean; }}

829303132package ;

import ties;

import ;import uration;

import lper;

/** * mybatis 配置对象 * @author zzg * */@Configurationpublic class MyBatisConfig { /** * 分页对象实列化 * @return */ @Bean public PageHelper pageHelper() { PageHelper pageHelper = new PageHelper(); Properties p = new Properties(); perty("offsetAsPageNum", "true"); perty("rowBoundsWithCount", "true"); perty("reasonable", "true"); perty("dialect", "mysql"); perties(p); return pageHelper; }}

82936373839464748495051# æå®æå¡ç«¯å£=7090# æå®æå¡ å称# t-path=/jreport#mybatis xml æ件éç½®-locations=classpath*:mapper/hadoop/*-aliases-package=# MyBatis mysql8 éç½®me=rd=******-class-name=# Druid éç½®# åå§åæ¶å»ºç«ç©çè¿æ¥ç个æ°l-size=5# æ大è¿æ¥æ± æ°é-active=30# æå°è¿æ¥æ± æ°é-idle=5# è·åè¿æ¥æ¶æ大çå¾æ¶é´ï¼åä½æ¯«ç§-wait=60000# éç½®é´éå¤ä¹æè¿è¡ä¸æ¬¡æ£æµï¼æ£æµéè¦å³éç空é²è¿æ¥ï¼åä½æ¯æ¯«ç§-between-eviction-runs-millis=60000# è¿æ¥ä¿æ空é²èä¸è¢«é©±éçæå°æ¶é´-evictable-idle-time-millis=300000# ç¨æ¥æ£æµè¿æ¥æ¯å¦ææçsqlï¼è¦æ±æ¯ä¸ä¸ªæ¥è¯¢è¯å¥tion-query=SELECT 1 FROM -while-idle=true# ç³è¯·è¿æ¥æ¶æ§è¡validationQueryæ£æµè¿æ¥æ¯å¦ææï¼åäºè¿ä¸ªéç½®ä¼éä½æ§è½ã-on-borrow=false# å½è¿è¿æ¥æ¶æ§è¡validationQueryæ£æµè¿æ¥æ¯å¦ææï¼åäºè¿ä¸ªéç½®ä¼éä½æ§è½ã-on-return=false# æ¯å¦ç¼åpreparedStatementï¼ä¹å°±æ¯PSCacheãPSCache对æ¯æ游æ çæ°æ®åºæ§è½æå巨大ï¼æ¯å¦è¯´oracleãå¨mysqlä¸å»ºè®®å³éã-prepared-statements=true# è¦å¯ç¨PSCacheï¼å¿é¡»é置大äº0ï¼å½å¤§äº0æ¶ï¼poolPreparedStatementsèªå¨è§¦åä¿®æ¹ä¸ºtrueã-pool-prepared-statement-per-connection-size=50# éç½®çæ§ç»è®¡æ¦æªçfiltersï¼å»æåçæ§çé¢sqlæ æ³ç»è®¡#s=stat,wall# éè¿connectPropertieså±æ§æ¥æå¼mergeSqlåè½ï¼æ¢SQLè®°å½tion-properties=ql=true;lMillis=500# å并å¤ä¸ªDruidDataSourceççæ§æ°æ®-global-data-source-stat=true# éç½®sql 注å¥æ¹å¼s=stat# æ¥å¿æ件éç½®#=classpath:

# hadoop hdfs éç½®åæ°th=hdfs://192.168.60.204:me==jdbc:mysql://192.168.**.**:3306/boot-security?serverTimezone=UTC&useSSL=false&allowPublicKeyRetrieval=true&allowMultiQueries=# 建议é置为trueï¼ä¸å½±åæ§è½ï¼å¹¶ä¸ä¿è¯å®å¨æ§ãç³è¯·è¿æ¥çæ¶åæ£æµï¼å¦æ空é²æ¶é´å¤§äºtimeBetweenEvictionRunsMillisï¼æ§è¡validationQ