Custom Wordpress theme crashes mysql - repost

Closed

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

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'

LIMIT 1;

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.

Skills: HTML, HTML5, MySQL, PHP, WordPress

See more: how to make wordpress custom theme, how to make a custom wordpress theme, get a custom wordpress theme made, wordpress theme setup, custom name server, wordpress touch, wordpress theme php files, wordpress fix errors, mysql join, php join tables, mysql optimise, query_time lock_time, need someone custom wordpress theme, wordpress theme repost, theme repost wordpress, php wordpress skills, optimise wordpress, huge traffic site, need custom wordpress theme, wordpress theme party, wordpress traffic server, wordpress custom theme design, wordpress db, tables wordpress, php traffic setup

Project ID: #4238301

15 freelancers are bidding on average $34/hour for this job

jhcannon

Hello - I'm available to look into your site issues with mysql. I have seen this kind of error before. Thanks - Janet

$35 USD / hour
(79 Reviews)
5.9
linuxfreak1985

Hi there, We are experts in PHP Open Source (any kind of PHP/MySQL work),wordpress and Ajax/Web 2.0 technology. Some of the projects we completed for php are mentioned below https://www.freelancer.com/projects/ More

$40 USD / hour
(68 Reviews)
5.9
bdweb

Thanks for giving me the opportunity to place a bid on your project. I would very much happy to work with you on your project and I think all your requirement meet with my skill and expertise level. First I woul More

$25 USD / hour
(90 Reviews)
5.9
softtonix

Hello, Review your project details and we are ready for your work.Please check your Private message box. Thank You Softtonix Team

$25 USD / hour
(31 Reviews)
5.9
naranili

Look at the clarification board

$25 USD / hour
(38 Reviews)
5.3
itsoftwarelab

Our main focus is to deliver the quality work with full support to our clients at very competitive rates. We will be happy to work with you on long term basis. So please consider us for your project. Hoping for the More

$50 USD / hour
(23 Reviews)
4.9
sotrue

Ready to start work straight away !!! Please check PM and our reviews from client for our past work.

$25 USD / hour
(8 Reviews)
4.8
raiseit

We are interested. Please check your private message.

$25 USD / hour
(11 Reviews)
4.7
suvendukm143

Hello Sir, Ready to start. Quick professional service guaranteed. Check PMB for more details. reagrds, Suvendu

$50 USD / hour
(3 Reviews)
2.3
getveltrod

Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and te More

$50 USD / hour
(7 Reviews)
1.6
Mobidevcorp

Hi Thank you for the DB comment. Without that details me may just speak about preliminary details. How fast your issues need to fix? We may provide the skilled WP developer from tomorrow. About us: Some our we More

$29 USD / hour
(0 Reviews)
0.0
XtrigonWebSoln

We are ready to work with you. Thanks & Regards, Xtrigon Web Solutions

$25 USD / hour
(0 Reviews)
0.0
sunnyarora22

Hello Sir, I am a Bussiness Manager. I have a proper team to work seriously on your project. I am very interested in your project. plz See your private message. we can start it now Thanks

$25 USD / hour
(0 Reviews)
0.0
sabinacreative

Hi, I have reviewed your project details and have expertise in the related field of software technology and will be looking forward to have a very positive reply from you soon! Best regards, Tauqeer Khan Crea More

$30 USD / hour
(0 Reviews)
0.0
miniric3

Hi, KIWI Team here at on2itonline would love to work for you on this project, we do "full service" websites on a clear and fixed budget. We have lots of offer that others don't, like our lifetime FREE hosting on every More

$50 USD / hour
(0 Reviews)
0.0