kettle pdi日志级别修改
✅kettle-8.2\data-integration\classes
❌data-integration\system\osgi\log4j.xml

日志定时删除
@echo off
setlocal

rem 设置日志文件目录
set “log_dir=D:\kettle-8.2\data-integration\logs”
rem 设置保留的天数
set “days_to_keep=60”

rem 计算要删除的日期
for /f “tokens=1-3 delims= “ %%a in (‘wmic os get localdatetime ^| find “.”‘) do (
set year=%%a
set month=%%b
set day=%%c
)
set today=%year%%month%%day%

rem 删除指定日期之前的日志文件
forfiles /p “%log_dir%” /s /m *.log /d -%days_to_keep% /c “cmd /c del @path”

endlocal

kettle定时任务15分钟和小时优化

查询sql优化

索引优化

修改mysql缓存