My crm is running super slow and I dont how to make it faster?
This is really complex, depending on what are your system’s specs, if this is a new installation, if the cache system is working, and so on.
A proper answer could be “Buy a better server.” but this may not be the perfect solution for you.
You have to be more specific. Write to us your system’s spec. size of DB, and what actually is slow(browsing in the suitecrm, reporting, etc).
Sorry for not replying sooner. I was sick.
These are mi system specs : memory RAM 8 GB, processor: Xeon 3.20 Ghz; my suitecrm database is 300 MG.
My problem is browsing from another terminal. I remove the cache from the browser of the six terminals and still is very slow adding new prospects or just checking any thing in general from the terminal to the server.
Is there a class or course that I could take so I can resolve more problems like exporting and importing the database to a new siutecrmdatabase?
Thank you very much
You can read this
https://pgorod.github.io/Database-tables-size/
and start with that SQL command given there (you can put it in phpMyAdmin):
SELECT CONCAT(table_schema, '.', table_name),
CONCAT(ROUND(table_rows / 1000000, 3), 'M') rows,
CONCAT(ROUND(data_length / ( 1024 * 1024 * 1024 ), 3), 'G') DATA,
CONCAT(ROUND(index_length / ( 1024 * 1024 * 1024 ), 3), 'G') idx,
CONCAT(ROUND(( data_length + index_length ) / ( 1024 * 1024 * 1024 ), 3), 'G') total_size,
ROUND(index_length / data_length, 3) idxfrac
FROM information_schema.TABLES
ORDER BY data_length + index_length DESC
LIMIT 20;
This will give you a first notion of whether your problem is because of an overgrown database.
1 Like
Your system is strong enough to handle this. I assume this is a bare metal installation of the operating system and not a virtual enviroment.
You shouldn’t experience such a latency. Also clearing cache doesn’t help. Try the suggestion of pgr and let us know the results.
1 Like
suitecrm.email_cache;"0.046M";"0.018G";"0.029G";"0.047G";"1.591"
suitecrm.leads;"0.006M";"0.005G";"0.013G";"0.018G";"2.412"
suitecrm.tracker;"0.018M";"0.004G";"0.008G";"0.012G";"1.813"
suitecrm.leads_audit;"0.022M";"0.007G";"0.003G";"0.011G";"0.466"
suitecrm.reminders_invitees;"0.006M";"0.002G";"0.004G";"0.007G";"1.801"
suitecrm.aod_indexevent;"0.009M";"0.003G";"0.003G";"0.006G";"0.890"
suitecrm.email_addr_bean_rel;"0.006M";"0.001G";"0.003G";"0.004G";"2.000"
suitecrm.calls;"0.003M";"0.002G";"0.002G";"0.004G";"0.641"
suitecrm.calls_leads;"0.004M";"0.001G";"0.002G";"0.004G";"1.619"
suitecrm.sugarfeed;"0.006M";"0.003G";"0.000G";"0.004G";"0.093"
suitecrm.calls_users;"0.004M";"0.001G";"0.002G";"0.004G";"1.849"
suitecrm.leads_cstm;"0.006M";"0.003G";"0.000G";"0.003G";"0.000"
suitecrm.reminders;"0.004M";"0.001G";"0.001G";"0.003G";"0.825"
suitecrm.email_addresses;"0.006M";"0.001G";"0.001G";"0.002G";"0.680"
suitecrm.user_preferences;"0.001M";"0.001G";"0.000G";"0.002G";"0.140"
suitecrm.alerts;"0.001M";"0.001G";"0.000G";"0.001G";"0.000"
mysql.innodb_index_stats;"0.002M";"0.001G";"0.000G";"0.001G";"0.000"
suitecrm.emails_text;"0.000M";"0.001G";"0.000G";"0.001G";"0.030"
suitecrm.calls_leads_1_c;"0.001M";"0.000G";"0.000G";"0.001G";"1.000"
mysql.help_topic;"0.001M";"0.000G";"0.000G";"0.000G";"0.035"
suitecrm.acl_roles_actions;"0.000M";"0.000G";"0.000G";"0.000G";"3.000"
suitecrm.emails_email_addr_rel;"0.000M";"0.000G";"0.000G";"0.000G";"1.286"
suitecrm.acl_actions;"0.000M";"0.000G";"0.000G";"0.000G";"0.750"
suitecrm.relationships;"0.000M";"0.000G";"0.000G";"0.000G";"0.500"
suitecrm.favorites;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.aor_fields;"0.000M";"0.000G";"0.000G";"0.000G";"0.500"
suitecrm.contacts;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
suitecrm.emails;"0.000M";"0.000G";"0.000G";"0.000G";"0.800"
suitecrm.accounts;"0.000M";"0.000G";"0.000G";"0.000G";"1.333"
suitecrm.notes;"0.000M";"0.000G";"0.000G";"0.000G";"1.333"
suitecrm.emails_beans;"0.000M";"0.000G";"0.000G";"0.000G";"1.333"
mysql.help_keyword;"0.000M";"0.000G";"0.000G";"0.000G";"0.186"
suitecrm.cases;"0.000M";"0.000G";"0.000G";"0.000G";"5.000"
suitecrm.campaign_log;"0.000M";"0.000G";"0.000G";"0.000G";"5.000"
suitecrm.tasks;"0.000M";"0.000G";"0.000G";"0.000G";"5.000"
suitecrm.prospects;"0.000M";"0.000G";"0.000G";"0.000G";"5.000"
suitecrm.meetings;"0.000M";"0.000G";"0.000G";"0.000G";"4.000"
suitecrm.job_queue;"0.000M";"0.000G";"0.000G";"0.000G";"4.000"
suitecrm.securitygroups_users;"0.000M";"0.000G";"0.000G";"0.000G";"4.000"
suitecrm.bugs;"0.000M";"0.000G";"0.000G";"0.000G";"4.000"
suitecrm.projects_contacts;"0.000M";"0.000G";"0.000G";"0.000G";"3.000"
suitecrm.emailman;"0.000M";"0.000G";"0.000G";"0.000G";"3.000"
suitecrm.cases_bugs;"0.000M";"0.000G";"0.000G";"0.000G";"3.000"
suitecrm.projects_cases;"0.000M";"0.000G";"0.000G";"0.000G";"3.000"
suitecrm.projects_bugs;"0.000M";"0.000G";"0.000G";"0.000G";"3.000"
suitecrm.projects_accounts;"0.000M";"0.000G";"0.000G";"0.000G";"3.000"
suitecrm.accounts_bugs;"0.000M";"0.000G";"0.000G";"0.000G";"3.000"
suitecrm.opportunities_contacts;"0.000M";"0.000G";"0.000G";"0.000G";"3.000"
suitecrm.aow_processed;"0.000M";"0.000G";"0.000G";"0.000G";"3.000"
suitecrm.opportunities;"0.000M";"0.000G";"0.000G";"0.000G";"3.000"
suitecrm.contacts_users;"0.000M";"0.000G";"0.000G";"0.000G";"3.000"
suitecrm.prospect_list_campaigns;"0.000M";"0.000G";"0.000G";"0.000G";"3.000"
suitecrm.acl_roles_users;"0.000M";"0.000G";"0.000G";"0.000G";"3.000"
suitecrm.contacts_cases;"0.000M";"0.000G";"0.000G";"0.000G";"3.000"
suitecrm.projects_products;"0.000M";"0.000G";"0.000G";"0.000G";"3.000"
suitecrm.calls_contacts;"0.000M";"0.000G";"0.000G";"0.000G";"3.000"
suitecrm.meetings_users;"0.000M";"0.000G";"0.000G";"0.000G";"3.000"
suitecrm.contacts_bugs;"0.000M";"0.000G";"0.000G";"0.000G";"3.000"
suitecrm.projects_opportunities;"0.000M";"0.000G";"0.000G";"0.000G";"3.000"
suitecrm.meetings_leads;"0.000M";"0.000G";"0.000G";"0.000G";"3.000"
suitecrm.meetings_contacts;"0.000M";"0.000G";"0.000G";"0.000G";"3.000"
suitecrm.leads_contacts_2_c;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
suitecrm.roles_modules;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
suitecrm.accounts_contacts;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
suitecrm.campaigns;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
suitecrm.accounts_cases;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
suitecrm.email_marketing;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
suitecrm.fp_events_fp_event_delegates_1_c;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
suitecrm.aow_processed_aow_actions;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
suitecrm.cron_remove_documents;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
mysql.innodb_table_stats;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.prospect_lists_prospects;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
suitecrm.oauth_tokens;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
suitecrm.fp_event_locations_fp_events_1_c;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
suitecrm.securitygroups_records;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
suitecrm.documents_opportunities;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
suitecrm.am_tasktemplates_am_projecttemplates_c;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
suitecrm.documents_contacts;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
suitecrm.pgem_programadeestudiosmaestrias;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.folders_rel;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
suitecrm.documents_cases;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
suitecrm.documents_bugs;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
suitecrm.am_projecttemplates_project_1_c;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
suitecrm.fields_meta_data;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
suitecrm.roles_users;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
suitecrm.documents_accounts;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
suitecrm.accounts_opportunities;"0.000M";"0.000G";"0.000G";"0.000G";"2.000"
mysql.columns_priv;"0.000M";"0.000G";"0.000G";"0.000G";"0.273"
suitecrm.inbound_email_autoreply;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.users;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aos_products_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.am_projecttemplates_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aok_knowledgebase_categories;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.bnf_beneficios_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.import_maps;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aor_reports_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
phpmyadmin.pma__history;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.email_templates;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.pge_programasdeestudio_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.leads_contacts_1_c;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.roles;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.linked_documents;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.campaigns_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aok_knowledgebase_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.fp_events_prospects_1_c;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.outbound_email_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.documents;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.upgrade_history;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.email_marketing_prospect_lists;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aos_product_categories_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.cases_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.fp_events_leads_1_c;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.document_revisions;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
phpmyadmin.pma__export_templates;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aow_workflow_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aok_knowledge_base_categories_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.fp_events_fp_event_locations_1_c;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.campaign_trkrs;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aos_pdf_templates_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.releases;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aor_conditions;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aow_workflow;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.project_users_1_c;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.custom_fields;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.accounts_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.project_task_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.currencies;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
phpmyadmin.pma__column_info;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.jjwg_markers_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aod_indexevent_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.fp_events_contacts_c;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aop_case_updates_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.opportunities_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.calls_reschedule_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.fp_events_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.eapm;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.jjwg_maps_jjwg_markers_c;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aow_conditions;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aod_index_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.contacts_leads_2_c;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.jjwg_maps_jjwg_areas_c;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aos_line_item_groups_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aop_case_events_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aow_actions;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.project_contacts_1_c;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.prospect_lists;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aos_quotes_project_c;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.oauth_nonce;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.contacts_leads_1_c;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.dpm_diplomado_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.jjwg_maps_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.address_book;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.fp_event_locations_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aos_quotes_os_contracts_c;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.oauth_consumer;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aos_invoices_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.am_tasktemplates_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.vcals;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aos_quotes_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.pgem_programadeestudiosmaestrias_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.securitygroups_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.jjwg_areas_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.folders_subscriptions;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aos_contracts_documents;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.users_signatures;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
phpmyadmin.pma__savedsearches;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aos_quotes_aos_invoices_c;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.acl_roles;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.jjwg_address_cache_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.users_password_link;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
phpmyadmin.pma__relation;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.schedulers;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.contacts_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.bugs_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.am_projecttemplates_users_1_c;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.folders;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.users_last_import;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aos_products_quotes_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.pgee_programadeestudioespecialidades_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.saved_search;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aos_contracts_audit;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.accounts_pge_programasdeestudio_1_c;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.users_feeds;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
phpmyadmin.pma__pdf_pages;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aos_products_quotes;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.config;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.am_projecttemplates_contacts_1_c;"0.000M";"0.000G";"0.000G";"0.000G";"1.000"
mysql.help_relation;"0.001M";"0.000G";"0.000G";"0.000G";"2.041"
information_schema.COLUMNS;NULL;"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.cases_cstm;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.aor_scheduled_reports;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
phpmyadmin.pma__navigationhiding;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.pge_programasdeestudio_cstm;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.accounts_cstm;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.campaigns_cstm;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.inbound_email;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.pge_programasdeestudio;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.aos_products;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.bnf_beneficios;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.aor_reports;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
phpmyadmin.pma__favorite;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.aok_knowledgebase;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.outbound_email;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.aos_product_categories;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
information_schema.SYSTEM_VARIABLES;NULL;"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.opportunities_cstm;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
information_schema.PLUGINS;NULL;"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.templatesectionline;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
phpmyadmin.pma__designer_settings;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.aok_knowledge_base_categories;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
information_schema.ALL_PLUGINS;NULL;"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.aor_charts;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
information_schema.PARTITIONS;NULL;"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.project_task;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
information_schema.PARAMETERS;NULL;"0.000G";"0.000G";"0.000G";"1.000"
phpmyadmin.pma__central_columns;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.jjwg_markers;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.prospects_cstm;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
phpmyadmin.pma__users;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.project_cstm;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.spots;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
phpmyadmin.pma__bookmark;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.aos_pdf_templates;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.aop_case_updates;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.am_projecttemplates;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.fp_events;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
phpmyadmin.pma__usergroups;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.calls_reschedule;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.dpm_diplomado_cstm;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
phpmyadmin.pma__tracking;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.aod_index;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
phpmyadmin.pma__userconfig;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.aos_line_item_groups;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
phpmyadmin.pma__table_uiprefs;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.project;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.aobh_businesshours;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
mysql.gtid_slave_pos;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
phpmyadmin.pma__table_info;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.pgem_programadeestudiosmaestrias_cstm;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.contacts_cstm;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.securitygroups_default;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.dpm_diplomado;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.jjwg_maps;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
information_schema.ROUTINES;NULL;"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.calls_cstm;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.fp_event_locations;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
phpmyadmin.pma__table_coords;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.securitygroups_acl_roles;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.aos_invoices;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
information_schema.EVENTS;NULL;"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.jjwg_areas;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.securitygroups;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.am_tasktemplates;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.aos_contracts_cstm;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
information_schema.PROCESSLIST;NULL;"0.000G";"0.000G";"0.000G";"1.000"
mysql.slave_worker_info;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.aos_quotes;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.pgee_programadeestudioespecialidades_cstm;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
information_schema.VIEWS;NULL;"0.000G";"0.000G";"0.000G";"1.000"
mysql.slave_relay_log_info;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
phpmyadmin.pma__recent;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.meetings_cstm;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.jjwg_address_cache;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
mysql.slave_master_info;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.pgee_programadeestudioespecialidades;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
information_schema.TRIGGERS;NULL;"0.000G";"0.000G";"0.000G";"1.000"
suitecrm.inbound_email_cache_ts;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.aos_contracts;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.aop_case_events;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
suitecrm.bnf_beneficios_cstm;"0.000M";"0.000G";"0.000G";"0.000G";"0.000"
mysql.db;"0.000M";"0.000G";"0.000G";"0.000G";"2.430"
mysql.proxies_priv;"0.000M";"0.000G";"0.000G";"0.000G";"8.069"
mysql.tables_priv;"0.000M";"0.000G";"0.000G";"0.000G";"8.291"
mysql.procs_priv;"0.000M";"0.000G";"0.000G";"0.000G";"8.298"
mysql.proc;"0.000M";"0.000G";"0.000G";"0.000G";"5.069"
mysql.user;"0.000M";"0.000G";"0.000G";"0.000G";"6.095"
mysql.help_category;"0.000M";"0.000G";"0.000G";"0.000G";"2.743"
mysql.roles_mapping;"0.000M";"0.000G";"0.000G";"0.000G";NULL
mysql.index_stats;"0.000M";"0.000G";"0.000G";"0.000G";NULL
mysql.column_stats;"0.000M";"0.000G";"0.000G";"0.000G";NULL
mysql.host;"0.000M";"0.000G";"0.000G";"0.000G";NULL
mysql.table_stats;"0.000M";"0.000G";"0.000G";"0.000G";NULL
mysql.event;"0.000M";"0.000G";"0.000G";"0.000G";NULL
mysql.servers;"0.000M";"0.000G";"0.000G";"0.000G";NULL
mysql.plugin;"0.000M";"0.000G";"0.000G";"0.000G";NULL
mysql.ndb_binlog_index;"0.000M";"0.000G";"0.000G";"0.000G";NULL
mysql.time_zone_leap_second;"0.000M";"0.000G";"0.000G";"0.000G";NULL
mysql.time_zone;"0.000M";"0.000G";"0.000G";"0.000G";NULL
mysql.func;"0.000M";"0.000G";"0.000G";"0.000G";NULL
mysql.time_zone_transition_type;"0.000M";"0.000G";"0.000G";"0.000G";NULL
mysql.time_zone_transition;"0.000M";"0.000G";"0.000G";"0.000G";NULL
mysql.time_zone_name;"0.000M";"0.000G";"0.000G";"0.000G";NULL
information_schema.CHANGED_PAGE_BITMAPS;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_BUFFER_PAGE_LRU;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.table_io_waits_summary_by_table;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.TABLE_PRIVILEGES;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_waits_current;"0.001M";"0.000G";"0.000G";"0.000G";NULL
performance_schema.hosts;"0.001M";"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_statements_current;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_TABLESPACES_SCRUBBING;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_statements_summary_global_by_event_name;"0.001M";"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_stages_summary_global_by_event_name;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_TRX;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_MUTEXES;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.COLLATION_CHARACTER_SET_APPLICABILITY;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.table_io_waits_summary_by_index_usage;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.TABLE_CONSTRAINTS;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_FT_DELETED;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_stages_summary_by_user_by_event_name;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_CMP_PER_INDEX;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_SYS_TABLESPACES;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.COLLATIONS;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.socket_summary_by_instance;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.TABLESPACES;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_statements_summary_by_user_by_event_name;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_CHANGED_PAGES;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.XTRADB_RSEG;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_FT_INDEX_TABLE;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.CHARACTER_SETS;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.socket_summary_by_event_name;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.TABLES;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_statements_summary_by_thread_by_event_name;"0.001M";"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_stages_summary_by_thread_by_event_name;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_SYS_SEMAPHORE_WAITS;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.host_cache;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_SYS_INDEXES;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_CMP;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.APPLICABLE_ROLES;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.socket_instances;"0.001M";"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_statements_summary_by_host_by_event_name;"0.001M";"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_stages_summary_by_host_by_event_name;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_BUFFER_PAGE;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.XTRADB_READ_VIEW;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.setup_timers;"0.000M";"0.000G";"0.000G";"0.000G";NULL
information_schema.STATISTICS;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_statements_summary_by_digest;"0.001M";"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_stages_summary_by_account_by_event_name;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_FT_CONFIG;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.file_summary_by_instance;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.USER_STATISTICS;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_CMPMEM_RESET;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_CMP_PER_INDEX_RESET;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_stages_history_long;"0.010M";"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_SYS_COLUMNS;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.file_summary_by_event_name;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_SYS_TABLESTATS;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.setup_objects;"0.000M";"0.000G";"0.000G";"0.000G";NULL
information_schema.SESSION_VARIABLES;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_stages_history;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_SYS_TABLES;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.KEY_COLUMN_USAGE;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.file_instances;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.TABLE_STATISTICS;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.setup_instruments;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.SESSION_STATUS;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.users;"0.001M";"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_waits_summary_global_by_event_name;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_SYS_DATAFILES;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.setup_consumers;"0.000M";"0.000G";"0.000G";"0.000G";NULL
information_schema.SCHEMA_PRIVILEGES;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_stages_current;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_CMPMEM;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.KEY_CACHES;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.INDEX_STATISTICS;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.setup_actors;"0.000M";"0.000G";"0.000G";"0.000G";NULL
information_schema.SCHEMATA;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.cond_instances;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_FT_DEFAULT_STOPWORD;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.GLOBAL_VARIABLES;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.threads;"0.001M";"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_waits_summary_by_user_by_event_name;"0.001M";"0.000G";"0.000G";"0.000G";NULL
performance_schema.accounts;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_SYS_FIELDS;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_METRICS;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.GLOBAL_STATUS;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_waits_summary_by_thread_by_event_name;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.CLIENT_STATISTICS;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.session_connect_attrs;"0.001M";"0.000G";"0.000G";"0.000G";NULL
mysql.general_log;"0.000M";"0.000G";"0.000G";"0.000G";NULL
information_schema.XTRADB_INTERNAL_HASH_TABLES;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_SYS_FOREIGN;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.FILES;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_waits_summary_by_instance;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.SPATIAL_REF_SYS;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.session_account_connect_attrs;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.REFERENTIAL_CONSTRAINTS;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_FT_INDEX_CACHE;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.GEOMETRY_COLUMNS;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_waits_summary_by_host_by_event_name;"0.001M";"0.000G";"0.000G";"0.000G";NULL
performance_schema.rwlock_instances;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.PROFILING;NULL;"0.000G";"0.000G";"0.000G";NULL
mysql.slow_log;"0.000M";"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_TABLESPACES_ENCRYPTION;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_waits_summary_by_account_by_event_name;"0.001M";"0.000G";"0.000G";"0.000G";NULL
performance_schema.performance_timers;"0.000M";"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_statements_summary_by_account_by_event_name;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_LOCKS;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_BUFFER_POOL_STATS;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.ENGINES;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_statements_history_long;"0.010M";"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_LOCK_WAITS;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_CMP_RESET;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.ENABLED_ROLES;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.USER_PRIVILEGES;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_waits_history_long;"0.010M";"0.000G";"0.000G";"0.000G";NULL
performance_schema.objects_summary_global_by_type;"0.001M";"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_FT_BEING_DELETED;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.INNODB_SYS_FOREIGN_COLS;NULL;"0.000G";"0.000G";"0.000G";NULL
information_schema.COLUMN_PRIVILEGES;NULL;"0.000G";"0.000G";"0.000G";NULL
performance_schema.table_lock_waits_summary_by_table;"0.001M";"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_waits_history;"0.001M";"0.000G";"0.000G";"0.000G";NULL
performance_schema.mutex_instances;"0.001M";"0.000G";"0.000G";"0.000G";NULL
performance_schema.events_statements_history;"0.001M";"0.000G";"0.000G";"0.000G";NULLThis was my result. It is still running really slow. I even used the tool REPAIR and same thing.
That is not the result from my query, my query shows pretty results, and only the 20 biggest tables… but ok, I was able to look at your database. You some large tables but nothing that would necessarily involve big delays.
You need to diagnose, understand what exactly is taking excessively long.
-
Try to focus on a single operation (I suggest List views, they are simpler than the detail views with many subpanels), and quantify (instead of slow, say how many seconds).
-
try it on the local network, or better, on the same computer that is serving the pages, to see if these are network delays
-
look in the browser’s Web console, network tab to see which call is taking longer
-
set your log level to DEBUG, and run a command prompt to your server and do a
tail -f suitecrm.log… to watch your log happening in real-time. You will see a lot of meaningless crap flying by you, but in the middle you might also see a clear delay of a few seconds right after a database query, and this will point you in the right direction
- on your server, run “top” during the list view render, and see which process is taking up the CPU, if any.
2 Likes
Hi
How I can run this query?
I got an error:
UPD:
Can I make Mysql index for custom module? for better performance?