Optimization of MySQL queries for a website on OpenCart 3
I am looking for a specialist with experience in MySQL and PHP to optimize database queries. The main issue is exceeding the max_user_connections limit due to slow queries. It is necessary to analyze and optimize the queries, and configure the database to improve performance.
Requirements:
- Experience in optimizing MySQL queries.
- Knowledge of PHP and caching mechanisms.
- Ability to work with
slow query logandEXPLAIN.
We expect an improvement in website performance and a reduction in database load.
-
1 day275 USD
1 day275 USD
Good day, I am interested in your proposal. I would be happy to collaborate.
Cost calculations for deadlines after discussing the details.
Please review the portfolio.
-
1 day22 USD
311 10 0 1 day22 USD
Mark, hello. I really like this kind of tasks, so feel free to reach out. We will help each other)
-
2 days33 USD
2847 63 5 2 days33 USD
Hello! I can install a module that optimizes the database and removes all issues.
-
Добрий день! можна посилання на сам сайт?
-
07.01.2025 14:03 680 15 912 202 6 800 06:27:42 00:01:35 91.206.200.248 SELECT DISTINCT p.product_id FROM `oc_category_pat
07.01.2025 14:50 135 1 490 462 135 02:38:45 02:18:45 127.0.0.1 SELECT COUNT(DISTINCT p.product_id) AS total FROM
07.01.2025 14:51 74 823 378 666 01:32:57 01:22:59 127.0.0.1 SELECT p.product_id, (SELECT AVG(rating) AS total
-
Current freelance projects in the category Databases & SQL
It is necessary to check the scripts and update the data in the Postgres database.It is necessary to correct the SQL scripts for the Postgres database. It is required to check the scripts and update data from external Excel tables and between two Postgres databases (different servers). Scripts will be run through AnyDesk using Navicat. List of data for… Databases & SQL ∙ 1 day 10 hours back ∙ 18 proposals |
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 2 days 3 hours back ∙ 9 proposals |
Basketball Coaching Education Platform + Custom CMSBasketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational… Databases & SQL, Web Programming ∙ 2 days 20 hours back ∙ 88 proposals |
Integration of Viber in 8.3
223 USD
Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist… Databases & SQL, Bot Development ∙ 3 days back ∙ 16 proposals |
Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning
22 USD
Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always… C#, Databases & SQL ∙ 4 days 22 hours back ∙ 6 proposals |
Vatutino