kettle pdi日志级别修改

✅kettle-8.2\data-integration\classes

❌data-integration\system\osgi\log4j.xml

日志定时删除

@echooff

setlocal

rem 设置日志文件目录

set “log_dir=D:\kettle-8.2\data-integration\logs”

rem 设置保留的天数

set “days_to_ke...

https://blog.csdn.net/weixin_45565886/article/details/128897346?ops_request_misc=&request_id=&biz_id=102&utm_term=xxl-job&utm_medium=distribute.pc_search_result.none-task-blog-2~all~sobaiduweb~default...

https://www.bilibili.com/video/BV19k4y1k7o9/?spm_id_from=333.337.search-card.all.click&vd_source=fd8128ae42b35905c9fc821432f9a40e

案例

https://www.bilibili.com/video/BV19k4y1k7o9?spm_id_from=333.788.video...

CREATE TABLE orders (

order_id INT NOT NULL AUTO_INCREMENT,

customer_id INT NOT NULL,

order_date DATE NOT NULL,

total_amount DECIMAL(10, 2),

PRIMARY KEY (order_id, order_date)

)

PARTITION BY RANGE (YEAR(orde...

缓冲池:

innodb_buffer_pool_size

innodb_buffer_pool_instances

innodb_log_buffer_size

innodb_log_file_size

临时表:

tmp_table_size

max_heap_table_size

磁盘临时表

innodb_tmpdir

innodb_tmp_tablespace

缓存刷新:

innodb_flush_log_at_tr...

java -jar myapp.jar arg1 arg2 arg3

java -Xmx512m -jar myapp.jar a b c

java -jar myapp.jar –port=8080 –env=prod

raid0 高性能,没有冗余,一个不能坏

raid1 只有一半容量可以用

raid5 N-1 有一块硬盘不能用

raid6 N-2 有两块硬盘不能用

raid10 结合raid0和raid1,高性能,一半容量不能用

kettle(水壶)

ETL工具

(Extract-Transform-Load)(抽取/转换/加载)

b站学习视频:

https://www.bilibili.com/video/BV1gP411a7JH/?spm_id_from=333.337.search-card.all.click&vd_source=fd8128ae42b35905c9fc821432f9a40e

验证kettle构建API使外...

PowerDesigner安装:

https://blog.csdn.net/LShuo666/article/details/124040859?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522171193390716800186513687%2522%252C%2522scm%2522%253A%252220140713.13010...