Optimize MySQL Database


I need someone who is an expert in mysql & has lots of experience in optimizing mysql databases, so the site loads very fast.

The web site is [url removed, login to view] the web site is running very, very slow, it is on a vps acct & using a lot of cpu & slowing down all the other accounts

iin my vps acct. My host, hostgator says, it is a mysql db problem, the db has to be optimized, too many process going on at the same time, per the host

In essence, there is this process:

mysql 0 131% 5.6 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/[url removed, login to view] --open-files-limit=16384 --pid-file=/var/lib/mysql/[url removed, login to view]

It is using 131% of the processing power on your server. That is why the sites are slow and that's why it is taking so long to load everything. The database that is causing this error needs to be optimized and needs to configured not to run so out of control.

The store is using opencart which is made in php

I had a programmer fix the search on the web site because whenever somebody searched for something like a model # or a description it would never work. But he fixed that but when you do a search it takes forever & slows down the web site, so that could be the heart of the problem, anyway that needs to be fixed.

I have attached a screenshot from my whm acct showing the cpu usage, it is changing every second & too high.

Also in the admin, under System > Backup/Restore when I try & run that, I get a fatal error message:

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 81 bytes) in /home/y7hkr3t7/public_html/system/database/[url removed, login to view] on line 29

that needs to be fixed also.

I need this project done asap, within hours if chosen for this project, so you need to make time.

If you do it right & have it fixed right away, I have other projects for you.

Also if you have any other ideas on seo for this site, I already am using several methods for seo but would like to hear more.

Skills: Database Administration, eCommerce, Javascript, MySQL, PHP

See more: slow server, slow site, err open files limit, work out of home ideas, work at home database, why need seo expert, system err, seo expert opencart, get expert seo system, err com, database host opencart, c# database mysql, opencart slow load, mysql 5.1, vps error, optimize mysql, mysql backup, mrt, c# expert 5-6 hours of work, backup database, mysql memory load, whm mysql, javascript projects database, user limit usage, php backup mysql

Project ID: #3974080

Awarded to:


We can fix issues today. Check PMB.

$100 USD in 1 day
(162 Reviews)

11 freelancers are bidding on average $162 for this job


I've worked on MySQL extensively in the past - most notably at my old company where I worked with multiple 4TB MySQL servers running in MasterMaster replication with billions of rows and could return results in under a More

$150 USD in 1 day
(116 Reviews)

expert here ready to help you right away. Best regards.

$150 USD in 1 day
(139 Reviews)

Hi we checked your requirement,We could develop as per your need. u could check that out. we would work till your satisfaction. Thanks & Regards Techwelfare Please check inbox for our previous work.

$247 USD in 10 days
(41 Reviews)

I'm ready to help you on this

$225 USD in 0 days
(73 Reviews)

Check your PMb

$200 USD in 1 day
(45 Reviews)

Hi, This is jeni from Bistechsupport. We could able to work on this project. A very few samples are drop down over here for your reference: 1 Ecommerce http://www.argansilk.com/ 2 Members only http://m More

$150 USD in 4 days
(19 Reviews)

I can do this right away.

$100 USD in 1 day
(21 Reviews)

Hi, I am linux administrator with knowledge in optimizing database systems. I can handle this task.

$125 USD in 2 days
(7 Reviews)

Consider it done.

$210 USD in 0 days
(4 Reviews)

We can wheck this issues Today. For your Backup/Restore not really a problem, just an configuration of php.ini. Please consider our offer. We are expert on MySQL optimisation. Check your PMB

$150 USD in 1 day
(0 Reviews)

Toolkit Solutions today boasts of maintaining and working with a large database of desirable programmers. If you hired Toolkit Solutions today, you can be assured that at least someone professional will be looking a More

$125 USD in 5 days
(0 Reviews)