Improve MySQL Connection Speed

To improve MySQL connection speed add skip-name-resolve to your MySQL server's my.ini or my.cnf under [mysqld]. Then restart the MySQL server.

[mysqld]
skip-name-resolve

If you have a large database you can improve performance by changing your tables to the Innodb engine. Execute these commands on your database:

ALTER TABLE tc_api_config ENGINE = InnoDB;
ALTER TABLE tc_company_info ENGINE = InnoDB;
ALTER TABLE tc_countries ENGINE = InnoDB;
ALTER TABLE tc_custom_variables ENGINE = InnoDB;
ALTER TABLE tc_datacenters ENGINE = InnoDB;
ALTER TABLE tc_datasource_fields ENGINE = InnoDB;
ALTER TABLE tc_default_variables ENGINE = InnoDB;
ALTER TABLE tc_dynamic_form_items ENGINE = InnoDB;
ALTER TABLE tc_dynamic_forms ENGINE = InnoDB;
ALTER TABLE tc_file_providers ENGINE = InnoDB;
ALTER TABLE tc_file_servers ENGINE = InnoDB;
ALTER TABLE tc_game_bukkit_config ENGINE = InnoDB;
ALTER TABLE tc_game_cmdlines ENGINE = InnoDB;
ALTER TABLE tc_game_config_files ENGINE = InnoDB;
ALTER TABLE tc_game_fast_download ENGINE = InnoDB;
ALTER TABLE tc_game_general_config ENGINE = InnoDB;
ALTER TABLE tc_game_identity ENGINE = InnoDB;
ALTER TABLE tc_game_keys ENGINE = InnoDB;
ALTER TABLE tc_game_links ENGINE = InnoDB;
ALTER TABLE tc_game_mail_templates ENGINE = InnoDB;
ALTER TABLE tc_game_map_packs ENGINE = InnoDB;
ALTER TABLE tc_game_mods ENGINE = InnoDB;
ALTER TABLE tc_game_packages ENGINE = InnoDB;
ALTER TABLE tc_game_paths ENGINE = InnoDB;
ALTER TABLE tc_game_permissions ENGINE = InnoDB;
ALTER TABLE tc_game_ports ENGINE = InnoDB;
ALTER TABLE tc_game_protocols ENGINE = InnoDB;
ALTER TABLE tc_game_punkbuster_config ENGINE = InnoDB;
ALTER TABLE tc_game_query_monitoring ENGINE = InnoDB;
ALTER TABLE tc_game_scripts ENGINE = InnoDB;
ALTER TABLE tc_game_service_custom_cmdlines ENGINE = InnoDB;
ALTER TABLE tc_game_service_detailed_stats ENGINE = InnoDB;
ALTER TABLE tc_game_service_historical_stats ENGINE = InnoDB;
ALTER TABLE tc_game_service_live_stats ENGINE = InnoDB;
ALTER TABLE tc_game_services ENGINE = InnoDB;
ALTER TABLE tc_game_steam_config ENGINE = InnoDB;
ALTER TABLE tc_game_templates ENGINE = InnoDB;
ALTER TABLE tc_game_text_console ENGINE = InnoDB;
ALTER TABLE tc_game_tracker_config ENGINE = InnoDB;
ALTER TABLE tc_game_updates ENGINE = InnoDB;
ALTER TABLE tc_game_variables_config ENGINE = InnoDB;
ALTER TABLE tc_game_web_console ENGINE = InnoDB;
ALTER TABLE tc_games ENGINE = InnoDB;
ALTER TABLE tc_info ENGINE = InnoDB;
ALTER TABLE tc_lang_datasource_fields ENGINE = InnoDB;
ALTER TABLE tc_lang_page_icons ENGINE = InnoDB;
ALTER TABLE tc_lang_panelbar_categories ENGINE = InnoDB;
ALTER TABLE tc_lang_properties ENGINE = InnoDB;
ALTER TABLE tc_lang_site_map ENGINE = InnoDB;
ALTER TABLE tc_languages ENGINE = InnoDB;
ALTER TABLE tc_mail_config ENGINE = InnoDB;
ALTER TABLE tc_mail_template_types ENGINE = InnoDB;
ALTER TABLE tc_mail_templates ENGINE = InnoDB;
ALTER TABLE tc_module_commands ENGINE = InnoDB;
ALTER TABLE tc_module_processes ENGINE = InnoDB;
ALTER TABLE tc_module_server_components ENGINE = InnoDB;
ALTER TABLE tc_modules ENGINE = InnoDB;
ALTER TABLE tc_object_required_permissions ENGINE = InnoDB;
ALTER TABLE tc_packages ENGINE = InnoDB;
ALTER TABLE tc_page_icons ENGINE = InnoDB;
ALTER TABLE tc_panelbar_categories ENGINE = InnoDB;
ALTER TABLE tc_permission_categories ENGINE = InnoDB;
ALTER TABLE tc_permissions ENGINE = InnoDB;
ALTER TABLE tc_private_networks ENGINE = InnoDB;
ALTER TABLE tc_recurring_tasks ENGINE = InnoDB;
ALTER TABLE tc_role_permissions ENGINE = InnoDB;
ALTER TABLE tc_roles ENGINE = InnoDB;
ALTER TABLE tc_script_engines ENGINE = InnoDB;
ALTER TABLE tc_security ENGINE = InnoDB;
ALTER TABLE tc_server_enabled_components ENGINE = InnoDB;
ALTER TABLE tc_server_ips ENGINE = InnoDB;
ALTER TABLE tc_servers ENGINE = InnoDB;
ALTER TABLE tc_services ENGINE = InnoDB;
ALTER TABLE tc_site_map ENGINE = InnoDB;
ALTER TABLE tc_support_categories ENGINE = InnoDB;
ALTER TABLE tc_support_config ENGINE = InnoDB;
ALTER TABLE tc_support_ticket_attachments ENGINE = InnoDB;
ALTER TABLE tc_support_ticket_replies ENGINE = InnoDB;
ALTER TABLE tc_support_tickets ENGINE = InnoDB;
ALTER TABLE tc_task_categories ENGINE = InnoDB;
ALTER TABLE tc_task_steps ENGINE = InnoDB;
ALTER TABLE tc_tasks ENGINE = InnoDB;
ALTER TABLE tc_teamspeak_permissions ENGINE = InnoDB;
ALTER TABLE tc_teamspeak_servers ENGINE = InnoDB;
ALTER TABLE tc_teamspeak_service_snapshots ENGINE = InnoDB;
ALTER TABLE tc_teamspeak_services ENGINE = InnoDB;
ALTER TABLE tc_user_messages ENGINE = InnoDB;
ALTER TABLE tc_user_packages ENGINE = InnoDB;
ALTER TABLE tc_user_widgets ENGINE = InnoDB;
ALTER TABLE tc_usercontrols ENGINE = InnoDB;
ALTER TABLE tc_users ENGINE = InnoDB;