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
Project Budget$250 - $750 USD
Completed In20 days
I need someone to optimize or repair out database queries. They are bogging down the database.
Here is what I have been reported.
+Large rows and slow queries
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online