En cours

MySQL OpenCart Issues (Queries hanging up)

We have a website, [url removed, login to view] 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.

Compétences : Développement de bases de données, HTML, MySQL, OpenCart, PHP

en voir plus : error 1064 mysql opencart line, upload data excel mysql opencart, php mysql opencart import, php, mysql, html, ecommerce, database development, open cart, css html java my sql php, mysql real estate queries, update stock mysql opencart, opencart issues, shipping address mysql opencart, wordpress mysql corruption issues, wordpress mysql memory issues, export mysql opencart, mysql lot locked queries, biggest issues cross platform compatibility website today, mysql slow sql queries

Concernant l'employeur :
( 7 commentaires ) Manchester, United States

Nº du projet : #15866793

Décerné à:

latatestTech

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 Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 5 jours
(151 Commentaires)
7.8

20 freelance font une offre moyenne de $174 pour ce travail

letshappy

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(155 Commentaires)
7.2
nsweb

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 P Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(94 Commentaires)
7.0
manojkhichar

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(139 Commentaires)
6.6
hjr122413

Hi. Thanks for your posting. I am familiar with opencart and optimization of database. I can redesign your database perfectly if it needs. I will sure give you 100% exact that you want. Thanks. Relevant Skills and Exp Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(65 Commentaires)
6.5
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(86 Commentaires)
6.3
Alka700

Dear Sir/Mam, As per your requirement.I would like to tell we are expertise in web designing and development.I would like to start my [login to view URL] a moment on our previous work. Thanks and Regards, CD Relevant Skills an Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(47 Commentaires)
6.2
protovosolutions

We're Opencart experts would like to help you with MySQL issue. Opencart customization, API integration, bug fixing, and advanced development is our expertise! Relevant Skills and Experience https://www.gyogyitokovek. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(51 Commentaires)
5.5
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(18 Commentaires)
5.9
symaticssolution

I have read your job description and understand your needs.I would like to discuss your project with [login to view URL] kindly ping me when you will be available for discussion. Relevant Skills and Experience Please have a look m Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(29 Commentaires)
5.5
WaheedGondal1

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 Dev Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(16 Commentaires)
5.4
Softinfoline

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 de Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(72 Commentaires)
5.2
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(39 Commentaires)
4.9
onlineitcare08

I have read your job proposal very carefully and I have noticed that this issue happen because of htp acess in MySQL I have create lot of opencart website here is the link [login to view URL] [login to view URL] Brandbags.i Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(8 Commentaires)
4.3
shahidabro8

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- Comme Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(26 Commentaires)
3.5
mjunaidriaz786

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 | Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(13 Commentaires)
3.5
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
1.4
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(0 Commentaires)
0.0
AbdulWasai

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...!!! Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
p3andren

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0