We have a website, [url removed, login to view] running Opencart 188.8.131.52
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.
21 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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
Hello Thank you for your post let me try for you Relevant Skills and Experience Database Development, HTML, MySQL, Open Cart, PHP Proposed Milestones $222 USD - good job Thank you
I have read your job description and understand your needs.I would like to discuss your project with [url removed, login to view] kindly ping me when you will be available for discussion. Relevant Skills and Experience Please have a look m Lisää
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 [url removed, login to view] [url removed, login to view] Brandbags.i Lisää