astgo平时死机变慢?试试mysql数据碎片整理吧,

发布时间:2019-05-25  栏目:NoSQL  评论:0 Comments

astgo平日死机变慢?试试mysql数据碎片整理吧,

选拔SSH之类的工具或navicat链接数据库后(注意:是链接数据库后哦,不是直接SSH后就弄,那样提醒命令错误的)

试行上边发号施令(指标是对ASTGO的数据库内除话单之外的全部表进行多少碎片整理,极度是用户表和充钱卡表,压缩率相当高的)

optimize table acct,acct_gatewaygroup,acct_ratepackage,acct_user,acct_user_consumerpackage,acct_user_periodrate,acct_user_ratepackage,accttype,agent_vouchercard,app_recharge,ast_log,ast_reload,astgo_login_try,astgo_urlmenu,btobtel,btobtellist,callback_bindtel,callback_book,calleegroup,calleelist,callergroup,callerlist,calllist,cbsubmit,cbsubmitex,cbsubmitex1,cbsubmitivr,cc_authority,cc_blacklist,cc_brecord,cc_callerlist,cc_config,cc_customer,cc_customer_list,cc_ivr_call,cc_ivr_flow,cc_ivr_flowlist,cc_outcalltask,cc_sendsms,cc_sendsmstask,cc_sms,cc_submit_call,cc_submit_sms,cc_vocfiles,click_call_submit,code_verify,conference_call_submit,consumerpackage,consumerpackage_log,crm_businesstype,crm_cdr,crm_customer_information,crm_fax_revlist,crm_outcall_task,crm_userstate_log,crm_workorder,fax_outcall_task,fax_ratepackage,fax_timeline,gateway,gatewaygroup,gatewaygrouplist,gatewaypolicy,httpcallsubmit,inboundcode,inboundcodetype,mobileparycode,musiconhold,musiconhold_list,partcodes,pay_config,pay_softphone_list,paydirect,phone_imei,pub_config,queue_member_table,queue_table,rate,rategroup,rategrouplist,ratepackage,recommend_getfee,reg_getfee,sip_bindexten_buddies,sip_reg_error_count,sms_cdr,sms_send_submit,speeddial,syslog,tiffiles,trunkbill,trunkbillpartcodes,ttsfiles,version,voicefiles,vouchercard,vouchercard_consumerpackage,vouchercard_ratepackage,voucherlog

转载自 http://www.51voip.org/post/66.html

http://www.bkjia.com/Mysql/1213856.htmlwww.bkjia.comtruehttp://www.bkjia.com/Mysql/1213856.htmlTechArticleastgo经常死机变慢?试试mysql数据碎片整理吧,
使用SSH之类的工具或navicat链接数据库后(注意:是链接数据库后哦,不是间接SSH后就弄,那…

使用SSH之类的工具或navicat链接数据库后(注意:是链接数据库后哦,不是一贯SSH后就弄,那样提醒命令错误的)

实行上面发号施令(指标是对ASTGO的数据库内除话单之外的全体表举行多少碎片整理,非常是用户表和充钱卡表,压缩率异常高的)

optimize table acct,acct_gatewaygroup,acct_ratepackage,acct_user,acct_user_consumerpackage,acct_user_periodrate,acct_user_ratepackage,accttype,agent_vouchercard,app_recharge,ast_log,ast_reload,astgo_login_try,astgo_urlmenu,btobtel,btobtellist,callback_bindtel,callback_book,calleegroup,calleelist,callergroup,callerlist,calllist,cbsubmit,cbsubmitex,cbsubmitex1,cbsubmitivr,cc_authority,cc_blacklist,cc_brecord,cc_callerlist,cc_config,cc_customer,cc_customer_list,cc_ivr_call,cc_ivr_flow,cc_ivr_flowlist,cc_outcalltask,cc_sendsms,cc_sendsmstask,cc_sms,cc_submit_call,cc_submit_sms,cc_vocfiles,click_call_submit,code_verify,conference_call_submit,consumerpackage,consumerpackage_log,crm_businesstype,crm_cdr,crm_customer_information,crm_fax_revlist,crm_outcall_task,crm_userstate_log,crm_workorder,fax_outcall_task,fax_ratepackage,fax_timeline,gateway,gatewaygroup,gatewaygrouplist,gatewaypolicy,httpcallsubmit,inboundcode,inboundcodetype,mobileparycode,musiconhold,musiconhold_list,partcodes,pay_config,pay_softphone_list,paydirect,phone_imei,pub_config,queue_member_table,queue_table,rate,rategroup,rategrouplist,ratepackage,recommend_getfee,reg_getfee,sip_bindexten_buddies,sip_reg_error_count,sms_cdr,sms_send_submit,speeddial,syslog,tiffiles,trunkbill,trunkbillpartcodes,ttsfiles,version,voicefiles,vouchercard,vouchercard_consumerpackage,vouchercard_ratepackage,voucherlog

转载自 http://www.51voip.org/post/66.html

留下评论

网站地图xml地图