Major Database Performance issue on opencart 1.5.6.4 website

$250-750 USD

Closed

Posted

almost 7 years ago

$250-750 USD

Paid on delivery

Hi, 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 1.5.6.4) 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 1.5.6.4). 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.

Database Administration

Database Programming

MySQL

PHP

Project ID: 14514361

About the project

16 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

16 freelancers are bidding on average $449 USD for this job

@ntiersolutions

I am an expert Opencart developer, and I can optimize your opencart store speed. Relevant Skills and Experience Opencart Proposed Milestones $263 USD - On Completion Send me your Opencart store URL to analyse speed.

$263 USD in 8 days

4.9

(448 reviews)

7.8

@Ginjag

Hi, I am interested in your project. Relevant Skills and Experience I have 5-year experience on Opencart. You can check my profile to know clearly about this. Proposed Milestones $400 USD - Init

$400 USD in 3 days

5.0

(86 reviews)

6.4

@vinaysinghh

I am mysql dba having more then 10 yrs of experience

$277 USD in 1 day

4.6

(52 reviews)

5.4

@WebExpertsx

We read your requirement about opencart and we want you to know that we have a good past experience in PHP,wordprss,laravel ,angular.js, javascript, Bootstrap, SEO, .net, html and css . Relevant Skills and Experience Database Administration, Database Programming, MySQL, PHP Proposed Milestones $288 USD - default what is time frame ?

$288 USD in 10 days

4.9

(6 reviews)

4.7

@lawrence37

I have over 15 years system administration experience with a number of distributions of linux / unix and windows server, working for a large number of blue chip companies here in the UK. Skill-List (Including but not limited to): Windows 2000-2016 Server Exchange 2003-2016, Office365 Linux / Unix Administration SAN Storage (NetApp, EMC Clariion, HP MSA/EVA/Lefthand) Server Virtualization (Vmware ESX, XenServer, Openstack) Desktop Virtualization (Vmware View, Xen Desktop) Application Virtualization (Thinapp, Xenapp) Networking (Cisco, Juniper, HP, Extreme, Ubiquiti) Firewall / IDS (Cisco, Fortigate, Juniper) Backup (CA Arcserve, HP Data protector, R1Soft, Veeam) Server administration (MsSQL, MySQL, Oracle (inc forms & reports), InnoDB, IIS, Apache, SCCM, WSUS) VoIP Solutions (Nortel, Avaya, Shoretel, Asterisk, FreePBX) Penetration Testing / Server Security/Hardening WHMCS, DirectAdmin, cPanel, Webmin AWS, Azure Config/Management

$400 USD in 1 day