Major Database Performance issue on opencart website


We have a server that is generally running fine with a couple of hundred websites. Its a WHM server with Cloudlinux 6.8. Starting today one of the opencart websites (version started performing very bad. 45 second load times and sometimes 500 error message. There could have been a bit of a spike as they made a release today (but they do this monthly and never had this issue. site averages around 56000 visits per month). This also has affected the other opencart website on the server (same version And no other MYSQL based website is affected. So sites like WOrdpress are not affected. Whats strange is that these 2 opencart site have been running perfect for 3 years and this just started happening today. Interesting enough, we have a test opencart site setup and it was running fine. But as soon as we pointed that to the live opencart database, it started performing slowly. SO the issue seems to be MYSQL related. And no updates have been done to this site in years.

I had my server admin look into this and the results are in the text file attached.

I'm looking for an opencart expert who understands DB who understands and can fix the issue. This matter is urgent.

Taidot: Tietokannan hallinto, Tietokantaohjelmointi, MySQL, PHP

Näytä lisää: opencart blog, speed up opencart website, opencart speed optimization, why opencart slow, opencart performance, how to optimize website speed, website performance optimization, opencart caching, 9 7 1 6 4 6 3 4 9 5, 5-6 page website, upgrade prestashop 1.4 to 1.5, website design opencart, website powered opencart, commerce website using opencart, ecommerce website using opencart

Tietoa työnantajasta:
( 99 arvostelua ) Amherst, Canada

Projektin tunnus: #14513478

Myönnetty käyttäjälle:


I am expert in opencart mate and can optimize the database in such manner so website design and fucntionlity will never break down Relevant Skills and Experience You can checkout my profile to see my skilsl as oc e Lisää

165 $ USD 1 päivässä
(233 arvostelua)

18 freelanceria on tarjonnut keskimäärin 150 $ tähän työhön


Hi there - My name is Khorshed. I've read your brief and can see that you are in need of an expert OpenCart developer to check your website and fix issues with Database. I can help you on this. Relevant Skills and Exp Lisää

210 $ USD 4 päivässä
(1127 arvostelua)

Hi, I am Opencart expert and experience in DB and Speed Optimization. In this job I will optimize your opencart site Database and some basic speed optimizations. Please reply. Relevant Skills and Experience I have mor Lisää

184 $ USD 3 päivässä
(435 arvostelua)

I will fix database perfomance/website run issue successfully and fast as working these task on daily basis in data center servers. Relevant Skills and Experience I have more than 8 years experience in, Linux Servers Lisää

100 $ USD 1 päivässä
(137 arvostelua)
200 $ USD 3 päivässä
(83 arvostelua)

Hi,I am a professional OC developer and its quite easy to me to resolve this [url removed, login to view] you provide me actual log file from your server to take a look on this issue? Relevant Skills and Experience OC Proposed Mileston Lisää

133 $ USD 2 päivässä
(25 arvostelua)
155 $ USD 3 päivässä
(19 arvostelua)

Hey, I have near about 5 year experience I can share my work experience with you during chat. I'm always available here for work bcause I'm induvial not a compny. I always try to do best work so please give me any resp Lisää

111 $ USD 1 päivässä
(25 arvostelua)

I have worked with web design perfect in HTML/CSS with extended version html -5 and css-3. I am also gone in bootstrap for responsive design which will run perfectly in all platform and all browser. Relevant Skills an Lisää

200 $ USD 8 päivässä
(3 arvostelua)

Someone from India posted the exact same project?

225 $ USD 1 päivässä
(4 arvostelua)

Hello, i am open cart expert developer. i woukd like to diagnose your website and fix all the things. Thanks

222 $ USD 3 päivässä
(5 arvostelua)
138 $ USD 2 päivässä
(0 arvostelua)

Hello Sir/Ma'am, We combine a design-oriented approach with technical and commercial expertise and strategic decision-making. Client satisfaction is our pride. Relevant Skills and Experienc Lisää

50 $ USD 1 päivässä
(0 arvostelua)

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. I am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have c Lisää

208 $ USD 6 päivässä
(0 arvostelua)

Hello Sir. Please drop me a message then we can start discuss more about your project Thank so much! Relevant Skills and Experience Hello Sir. Please drop me a message then we can start discuss more about your project Lisää

155 $ USD 3 päivässä
(0 arvostelua)

I am OpenCart Expert and already developed/fixed so many Opencart sites. I have excellent experience of 4 years in Opencart Development/Customization, Opencart Database, Themes, Modules, Errors etc. Relevant Skills an Lisää

45 $ USD 3 päivässä
(0 arvostelua)

6+ year of experience. Worked on many database performance issues like this. I can complete this work on give time only. Ping me for discussion of this project further. Relevant Skills and Experience ORACLE MYSQL SQL Lisää

155 $ USD 3 päivässä
(0 arvostelua)

Hi, Please open a chat with me. Relevant Skills and Experience . Proposed Milestones $35 USD - .

35 $ USD 3 päivässä
(0 arvostelua)