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, drupal page found database performance, website using opencart, database performance fix, resolve database performance issue, database performance audit

Tietoa työnantajasta:
( 104 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ä
(253 Arvostelua)

17 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% 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ä
(1173 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ä
(476 arvostelua)
$200 USD 3 päivässä
(87 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ä
(165 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ä
(179 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ä
(78 arvostelua)

Hi,I am a professional OC developer and its quite easy to me to resolve this [login to view URL] 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ä
(44 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ä
(15 arvostelua)
$155 USD 3 päivässä
(23 arvostelua)

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

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

Someone from India posted the exact same project?

$225 USD 1 päivässä
(7 arvostelua)
$138 USD 2 päivässä
(7 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)

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)

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)