|
em 512MB，checkpoint_segments = 16，获得了稳定而持久的生产力提升。
测试：
插入4条数据
-
insert into base_table_machine1 (dvalue,sample_time,machine_code,max_res,
curr_res) values (22.17273,'2012-06-01 11:22:11','SC3010-192.168.1.12',1,2);
-
insert into base_table_machine1 (dvalue,sample_time,machine_code,max_res,curr_
res) values (12.8273,'2012-07-12 10:23:01','SC3010-192.168.1.14',1,2);
-
insert into base_table_machine2 (dvalue,sample_time,machine_code,manu_id,manu_
value) values (4412.1928,'2011-01-21 02:08:34','PK937-192.168.1.113','TP1','E54DF');
-
insert into base_table_machine2 (dvalue,sample_time,machine_code,manu_id,manu_
value) values (4412.1928,'2011-12-31 04:21:31','PK937-192.168.1.112','TP2','CB67D');
看看 select 语句的结果
select * from base_table;
select * from base_table_machine2;
select * from base_table_machine1;
explain select * from base_table where sample_time >='2012-06-21 00:00:00' and sample_
time <='2012-07-21 00:00:00';
自动使用索引关联到每个子表。
|
