Expression Engine & MySQL Database Repair

IN PROGRESS
Bids
15
Avg Bid (USD)
$577
Project Budget (USD)
$250 - $750

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/mysqld.slow.log

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.

Skills required:
Expression Engine, MySQL, Website Management
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 631
in 20 days
Hire donkyaw
$ 500
in 10 days
$ 773
in 10 days
$ 555
in 7 days
$ 526
in 3 days
$ 736
in 21 days
Hire e3d
$ 495
in 5 days
$ 773
in 30 days
$ 388
in 3 days
$ 500
in 30 days