Custom Wordpress theme crashes mysql

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: 10.816952 Lock_time: 0.000168 Rows_sent: 1 Rows_examined: 2432558

SET timestamp=1360225556;

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.


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.

Taidot: HTML, Javascript, MySQL, PHP, WordPress

Näytä lisää: how to make wordpress custom theme, how to make a custom wordpress theme, get a custom wordpress theme made, wordpress theme setup, amp optimise, mysql amp, custom name server, wordpress touch, wordpress fix errors, mysql join, mysql optimise, query_time lock_time, need someone custom wordpress theme, optimise wordpress, huge traffic site, need custom wordpress theme, wordpress theme party, wordpress traffic server, wordpress custom theme design, wordpress db, tables wordpress, magento wordpress custom theme, implement custom theme wordpress, huge wordpress, graphic design wordpress custom theme design

Tietoa työnantajasta:
( 0 arvostelua ) Singapore

Projektin tunnus: #4238271

1 freelanceri on tarjonnut keskimäärin 40 $ tähän työhön


Hired by the Employer

$40 USD / tunti
(135 arvostelua)