Find Jobs
Hire Freelancers

MySQL OpenCart Issues (Queries hanging up)

$30-250 USD

Status
Publicerad över sex år sedan

$30-250 USD

Betalning vid leverans
We have a website, [login to view URL] running Opencart 2.3.0.2 Multiple times a day we are getting 500 Server errors, and MySQL server has gone away; error 2006 We are on a dedicated server, and our web host tells us that the above errors are happening for the following reason: "After reviewing this further it appears that the issue is caused by slow MySQL queries generated by the database As you can see there are queries executed longer than 35 seconds while the standard execution time for a single query is under 1 second. I see that my colleagues had to restart the MySQL service due to the same issue in ticket 2524515. Please note that this is only a temporary solution and the issue needs to be addressed by a professional developer who will be able to optimize the database and apply a permanent solution. It is also recommended to try reducing the database size (currently around 3.2 GB):". These errors do not happen all of the time, but they do happen several times a day. This project would be to find and fix the queries that are "bottlenecking" and causing our SQL server to freeze up and restart. One of the ways we can recreate the error, is by exporting a high number of products, but it appears that the error creates itself at random. We are getting a lot of errors in the Opencart Admin dashboard as well, that may or may not be related. Please see the attached logs, and screenshots.
Project ID: 15866793

Om projektet

18 anbud
Distansprojekt
Senaste aktivitet sex år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
Tilldelad till:
Använd avatar
A great team is here for your service!! I read the project description properly, and I agreed to fulfill 100% of all your requirements. I can start your important project right away. Relevant Skills and Experience Let's start! To achieve goal with 100% quality we have team of 27 Professional Software Engg. Reply us so that we can move ahead to get this software successfully run. Proposed Milestones $200 USD - Project Milestone
$200 USD Om 5 dagar
4,8 (187 omdömen)
8,1
8,1
18 frilansar lägger i genomsnitt anbud på $174 USD för detta uppdrag
Använd avatar
hello, i read the project and i am ready to fix all issues from opencart thanks Relevant Skills and Experience mysql, php, opencart , css Proposed Milestones $208 USD - 208
$208 USD Om 4 dagar
4,8 (204 omdömen)
7,4
7,4
Använd avatar
I'm interested in doing your work so finally would like to start work now. I'm ready for interview and feel free if you have any query and contact me anytime 24*7 will be available here. Relevant Skills and Experience Open source (WordPress, Joomla, Drupal, Magento, Zend, Express Engine, CakePhp, Codeigniter), MySQL, Jquery, Ajax, HTML5, Xhtml, CSS3, WP theme and Plugin development, Magento Extension development. Proposed Milestones $150 USD - initial milestone request.
$150 USD Om 2 dagar
4,9 (226 omdömen)
7,1
7,1
Använd avatar
Hello. I have big experience with eCommerce solutions (Presatshop, Opencart, ZenCart etc.). I can debug your mysql queries and will identify and fix the queries. Relevant Skills and Experience MySql, Php, Opencart Proposed Milestones $120 USD - total Stay tuned, I'm still working on this proposal.
$120 USD Om 2 dagar
4,9 (95 omdömen)
7,0
7,0
Använd avatar
This is server setting issue and I'll fix it. This is mainly due to server overload and memory exhaust. I'll both optimize setting for mysql & Apache/Nginx. Relevant Skills and Experience I'm professional ecommerce developer and server provider & expert (centos, Ubuntu, windows server like plesk). Handle complex installation task. Proposed Milestones $45 USD - Project cost You are using Nginx or Apache? Not need to reduce size of database. I'll increase to 500 query process from 100 query at a time.
$45 USD Om 1 dag
5,0 (141 omdömen)
6,2
6,2
Använd avatar
Hello, Hope you are fine. I have read the job description, I am willing to work with you as per your requirements. I have already done similar work and get great feedback. Relevant Skills and Experience Database Development HTML MySQL Open Cart PHP Proposed Milestones $250 USD - Project Milestone
$250 USD Om 10 dagar
5,0 (18 omdömen)
5,4
5,4
Använd avatar
Contact ME for more details I have read all your requirements for this project. i can do it as soon as possible Relevant Skills and Experience Php | Wordpress | Magento | Codeignetor | Open Cart | Joomla | Shopify | Drupal | Prestashop | Html | Js | Css | Bootstrap | Graphic Design | Photoshop | Photoshop Design | Website Design Proposed Milestones $250 USD - project
$250 USD Om 3 dagar
4,7 (15 omdömen)
4,4
4,4
Använd avatar
PHP, HTML5, CSS3, WordPress, Bootstrap, E-Commerce, CodeIgniter, Website Design, Woo- Commerce Relevant Skills and Experience PHP, HTML5, CSS3, WordPress, Bootstrap, E-Commerce, CodeIgniter, Website Design, Woo- Commerce Proposed Milestones $155 USD - PHP, HTML5, CSS3, WordPress, Bootstrap, E-Commerce, CodeIgniter, Website Design, Woo- Commerce PHP, HTML5, CSS3, WordPress, Bootstrap, E-Commerce, CodeIgniter, Website Design, Woo- Commerce
$155 USD Om 3 dagar
5,0 (27 omdömen)
3,5
3,5
Använd avatar
Hi, Contact me for Quality Work I would like to work with you Relevant Skills and Experience Database Development, HTML, MySQL Proposed Milestones $140 USD - When Job Done Waiting for your Response. Thank You...!!!!!
$140 USD Om 3 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
I’ve solved theese problems a number of times, slow queries that’s cousing a lot of problems. Been working with MySql for many years now.
$222 USD Om 2 dagar
0,0 (0 omdömen)
0,0
0,0

Om kunden

Flagga för UNITED STATES
Manchester, United States
5,0
16
Verifierad betalningsmetod
Medlem sedan sep. 1, 2015

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.