Astgo often crashes and slows down? Try MySQL data defrag.

After using a tool such as SSH or navicat linked 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

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

Astgo often crashes and slows down? Try MySQL data defrag.