Custom Wordpress theme crashes mysql - repost
This project received 15 bids from talented freelancers with an average bid price of $34 USD / hour.Get free quotes for a project like this
Need someone really good in mysql & wordpress to fix my custom theme. server crashes once site is made live. There are many similar errors like these:
# Query_time: [url removed, login to view] Lock_time: [url removed, login to view] Rows_sent: 1 Rows_examined: 2432558
SELECT [url removed, login to view],[url removed, login to view],[url removed, login to view]
FROM wp_ngg_gallery AS A
INNER JOIN wp_ngg_pictures AS B ON [url removed, login to view] = [url removed, login to view]
WHERE [url removed, login to view] = 'mayuko_iwasa'
If you know how to optimise db errors like this, pls get in touch. We've already had 2 contractors failing to make this site work and we believe it is the way the db tables are setup, which makes it very inefficient causing the crashes.
SITE WORKS PERFECTLY WITH NO TRAFFIC
I understand the need to look at the db and files. But this is a huge site with a huge DB (>1GB) and we cannot be opening it to every interested party. As such, we request that you first give us an idea on how you will tackle these errors so we can be confident that you have some skills. Tks.
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