After using a tool such as SSH or navicat to connect to a database (note: After the link database Oh, not directly after SSH, so prompt command error)
Execute the following command (the purpose is to defragment all tables in the ASTGO database except for the phone, especially the user table and top-up card table, with very high compression rates)
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.
Try MySQL data defragmentation to solve the problem that Astgo often crashes and slows down.