VOS3000 删除话单 清理无通话时长话单 清理表碎片 优化表空间

VOS3000 删除话单  清理无通话时长话单  清理表碎片  优化表空间

 

delete from e_cdr_20220701 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220702 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220703 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220704 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220705 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220706 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220707 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220708 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220709 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220710 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220711 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220712 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220713 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220714 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220715 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220716 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220717 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220718 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220719 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220720 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220721 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220722 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220723 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220724 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220725 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220726 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220727 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220728 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220729 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220730 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220731 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220801 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220802 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220803 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220804 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220805 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220806 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220807 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220808 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220809 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220810 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220811 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220812 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220813 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220814 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220815 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220816 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220817 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220818 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220819 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220820 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220821 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220822 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220823 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220824 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220825 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220826 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220827 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220828 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220829 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220830 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220831 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220901 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220902 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220903 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220904 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220905 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220906 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220907 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220908 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220909 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220910 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220911 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220912 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220913 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220914 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220915 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220916 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220917 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220918 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220919 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220920 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220921 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220922 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220923 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220924 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220925 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220926 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220927 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220928 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220929 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220930 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221001 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221002 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221003 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221004 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221005 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221006 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221007 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221008 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221009 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221010 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221011 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221012 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221013 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221014 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221015 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221016 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221017 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221018 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221019 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221020 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221021 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221022 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221023 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221024 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221025 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221026 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221027 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221028 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221029 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221030 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221031 where holdtime = 0 and fee = 0 and feetime=0;

optimize table e_cdr_20220701;
optimize table e_cdr_20220702;
optimize table e_cdr_20220703;
optimize table e_cdr_20220704;
optimize table e_cdr_20220705;
optimize table e_cdr_20220706;
optimize table e_cdr_20220707;
optimize table e_cdr_20220708;
optimize table e_cdr_20220709;
optimize table e_cdr_20220710;
optimize table e_cdr_20220711;
optimize table e_cdr_20220712;
optimize table e_cdr_20220713;
optimize table e_cdr_20220714;
optimize table e_cdr_20220715;
optimize table e_cdr_20220716;
optimize table e_cdr_20220717;
optimize table e_cdr_20220718;
optimize table e_cdr_20220719;
optimize table e_cdr_20220720;
optimize table e_cdr_20220721;
optimize table e_cdr_20220722;
optimize table e_cdr_20220723;
optimize table e_cdr_20220724;
optimize table e_cdr_20220725;
optimize table e_cdr_20220726;
optimize table e_cdr_20220727;
optimize table e_cdr_20220728;
optimize table e_cdr_20220729;
optimize table e_cdr_20220730;
optimize table e_cdr_20220731;
optimize table e_cdr_20220801;
optimize table e_cdr_20220802;
optimize table e_cdr_20220803;
optimize table e_cdr_20220804;
optimize table e_cdr_20220805;
optimize table e_cdr_20220806;
optimize table e_cdr_20220807;
optimize table e_cdr_20220808;
optimize table e_cdr_20220809;
optimize table e_cdr_20220810;
optimize table e_cdr_20220811;
optimize table e_cdr_20220812;
optimize table e_cdr_20220813;
optimize table e_cdr_20220814;
optimize table e_cdr_20220815;
optimize table e_cdr_20220816;
optimize table e_cdr_20220817;
optimize table e_cdr_20220818;
optimize table e_cdr_20220819;
optimize table e_cdr_20220820;
optimize table e_cdr_20220821;
optimize table e_cdr_20220822;
optimize table e_cdr_20220823;
optimize table e_cdr_20220824;
optimize table e_cdr_20220825;
optimize table e_cdr_20220826;
optimize table e_cdr_20220827;
optimize table e_cdr_20220828;
optimize table e_cdr_20220829;
optimize table e_cdr_20220830;
optimize table e_cdr_20220831;
optimize table e_cdr_20220901;
optimize table e_cdr_20220902;
optimize table e_cdr_20220903;
optimize table e_cdr_20220904;
optimize table e_cdr_20220905;
optimize table e_cdr_20220906;
optimize table e_cdr_20220907;
optimize table e_cdr_20220908;
optimize table e_cdr_20220909;
optimize table e_cdr_20220910;
optimize table e_cdr_20220911;
optimize table e_cdr_20220912;
optimize table e_cdr_20220913;
optimize table e_cdr_20220914;
optimize table e_cdr_20220915;
optimize table e_cdr_20220916;
optimize table e_cdr_20220917;
optimize table e_cdr_20220918;
optimize table e_cdr_20220919;
optimize table e_cdr_20220920;
optimize table e_cdr_20220921;
optimize table e_cdr_20220922;
optimize table e_cdr_20220923;
optimize table e_cdr_20220924;
optimize table e_cdr_20220925;
optimize table e_cdr_20220926;
optimize table e_cdr_20220927;
optimize table e_cdr_20220928;
optimize table e_cdr_20220929;
optimize table e_cdr_20220930;
optimize table e_cdr_20221001;
optimize table e_cdr_20221002;
optimize table e_cdr_20221003;
optimize table e_cdr_20221004;
optimize table e_cdr_20221005;
optimize table e_cdr_20221006;
optimize table e_cdr_20221007;
optimize table e_cdr_20221008;
optimize table e_cdr_20221009;
optimize table e_cdr_20221010;
optimize table e_cdr_20221011;
optimize table e_cdr_20221012;
optimize table e_cdr_20221013;
optimize table e_cdr_20221014;
optimize table e_cdr_20221015;
optimize table e_cdr_20221016;
optimize table e_cdr_20221017;
optimize table e_cdr_20221018;
optimize table e_cdr_20221019;
optimize table e_cdr_20221020;
optimize table e_cdr_20221021;
optimize table e_cdr_20221022;
optimize table e_cdr_20221023;
optimize table e_cdr_20221024;
optimize table e_cdr_20221025;
optimize table e_cdr_20221026;
optimize table e_cdr_20221027;
optimize table e_cdr_20221028;
optimize table e_cdr_20221029;
optimize table e_cdr_20221030;
optimize table e_cdr_20221031;