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...

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...