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