php mysql做网站,上海千途网站建设,全国十大网站建设公司,手游app平台排行榜背景
数据库的订单数量过多#xff0c;需要分出热表用于快速查询#xff0c;热表仅保存10天的订单数据。
解决思路
每次数据库订单表触发增删改时#xff0c;同步操作到trigger_order_mul_info表#xff0c;然后trigger_order_mul_info会定期删除超过10天的数据。
增删…背景
数据库的订单数量过多需要分出热表用于快速查询热表仅保存10天的订单数据。
解决思路
每次数据库订单表触发增删改时同步操作到trigger_order_mul_info表然后trigger_order_mul_info会定期删除超过10天的数据。
增删改触发器
增加数据触发的触发器
BEGIN
INSERT INTO trigger_order_mul_info(id,del_flag,create_time,update_time,remarks,business_id,order_serial_num,order_status,real_name,phone,true_phone,order_stage,order_type,is_pay_later,place_type,type)
values(new.id,new.del_flag,new.create_time,new.update_time,new.remarks,new.business_id,new.order_serial_num,new.order_status,
NULL,new.repast_user_phones,new.take_phone,new.order_stage,new.order_type,new.is_pay_later,new.place_type,1);
END更新数据触发的触发器
BEGIN
update trigger_order_mul_info set idnew.id,del_flagnew.del_flag,create_timenew.create_time,update_timenew.update_time,remarksnew.remarks,
business_idnew.business_id,order_serial_numnew.order_serial_num,order_statusnew.order_status,real_nameNULL,phonenew.repast_user_phones,
true_phonenew.take_phone,order_stagenew.order_stage,order_typenew.order_type,is_pay_laternew.is_pay_later,place_typenew.place_type,type1 where idnew.id;
END删除数据触发的触发器
BEGIN
delete from trigger_order_mul_info where idold.id ;
END对应添加到触发器