Completed

Expression Engine & MySQL Database Repair

This project was successfully completed by webaccelerator for $631 USD in 20 days.

Get free quotes for a project like this
Employer working
Completed by:
Project Budget
$250 - $750 USD
Completed In
20 days
Total Bids
15
Project Description

I need someone to optimize or repair out database queries. They are bogging down the database.
Here is what I have been reported.
1.
+Large rows and slow queries
Severity: High

Many tables such as exp_member_homepage (704,825 rows) exp_members (704,840 rows), and exp_member_data (704,838 rows) are very large in size. Besides these, I also counted about 10+ tables with 10,000-20,000 rows. The size of these tables used in conjunction with inefficient queries leads to slow queries, which I believe is the biggest culprit for the slow site speeds. Your MySQL slow queries log has grown to almost 358MB in just a few days. This log can be found at the following path:

/var/log/[url removed, login to view]

As a courtesy, I analyzed some of your slow queries, and see a large amount of queries that use 'SELECT *' in some of your largest tables. These types of queries appear to be the largest cause of your bottleneck, as they have to comb through 704,000+ records. Optimizing how your site utilizes MySQL will benefit you the greatest.

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