Optimize MySQL Database

  • Status Closed
  • Budget $30 - $250 USD
  • Total Bids 12

Project Description

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.

Get free quotes for a project like this
Awarded to:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online