Astgo Often crashes and slows down? Try mysql Data fragmentation,

Astgo Often crashes and slows down? Try mysql Data fragmentation,

Use tools such as SSH or navicat to connect to the database (Note: It is done after the database is connected, instead of directly using SSH, and a command error is prompted)

Run the following command (the purpose is to fragment all the tables except the phone list in the ASTGO database, especially the user table and recharge card table, with a very high compression rate)

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

Reprinted from http://www.51voip.org/post/66.html