Đã Hủy

Wordpress Database Expert Required

I need to someone to fix an issue with my wordpress database which is causing site to hang and crash. Here is part of the issue

| localhost | nameofdatabase | Query | 3194 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS [url removed, login to view] FROM wp_posts LEFT JOIN wp_postmeta ON ( [url removed, login to view] = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ([url removed, login to view] = mt1.post_id AND mt1.meta_key = 'yst_prominent_words_version' ) WHERE 1=1 AND (

( wp_postmeta.meta_key = 'yst_prominent_words_version' AND wp_postmeta.meta_value != '1' )

OR

mt1.post_id IS NULL

) AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'future' OR wp_posts.post_status = 'draft' OR wp_posts.post_status = 'pending' OR wp_posts.post_status = 'private')) GROUP BY [url removed, login to view] ORDER BY wp_posts.post_date DESC LIMIT 11, 10 |

| 48341 | nameofdatabase | localhost | nameofdatabase | Query | 3129 | Waiting for table level lock | DELETE FROM wp_postmeta WHERE meta_id IN( 8414001 )

I am also looking to clean up the database and to minimise sql queries to help site load faster and more efficiently so looking to optimize the databse.

Please do no bid if you are not a database expert.

Kỹ năng: MySQL, SQL, WordPress

Xem thêm: import recipe database wordpress, import access database wordpress, convert database wordpress, import post database wordpress, import posts mysql database wordpress, clean mysql database wordpress, access database wordpress, integrating existing mysql database wordpress, creating pages imported database wordpress, import mysql database wordpress, import sql database wordpress, import database wordpress, joomla database wordpress, database wordpress joomla, prestashop database wordpress merge

Về Bên Thuê:
( 1 nhận xét ) United Kingdom

Mã Dự Án: #13450662

Đã trao cho:

TakeReal

Hello, My name is Sergey. I am Freelancer from [url removed, login to view], Russia. Your site hangs and crash due to slow SQL queries. I can find these issues and fix them. This is list of similar projects, successfully comp Thêm

$150 USD trong 3 ngày
(1188 Đánh Giá)
7.6

31 freelancer đang chào giá trung bình $175 cho công việc này

sapotacorp

Hi stevenaitchison. What is yoir WordPress website address? I can help you to fix those bugs quickly. Please contact for a further discussion. Thank you. M

$198 USD trong 1 ngày
(500 Đánh Giá)
7.8
niravvirani17

Give me chance to prove my ability and also quality work i am waiting your positive replay from your side i am highly interested to work with you We have 8 years’ experience in this field and completed many projec Thêm

$100 USD trong 3 ngày
(443 Đánh Giá)
7.8
GetReal

Freelance Professional! Ready to start now and have it done for you ASAP! Look forward to hear from you and work with you...Thanks!

$200 USD trong 3 ngày
(511 Đánh Giá)
7.6
AltiuseCreaton

Hi, I can do your job but need to make a short chat discussion with you. let me know if possible for you. please let me know. You can check my profile and feedbacks of clients which itself I got from them . Hope the Thêm

$255 USD trong 2 ngày
(44 Đánh Giá)
6.6
navneet008

Dear Hiring Manager, If you would like high quality work with a fast turn around for a fair price, contact me. You won't be disappointed. I enjoy working on all kinds of creative and innovative projects. I am capab Thêm

$180 USD trong 3 ngày
(283 Đánh Giá)
6.9
truongnguyen86

Hello there, i'm expert on database, i've done many project with tuning database before, also slow query i can help. About your query, many part need to be indexed. Waiting for your response if interested. Thank you!!

$250 USD trong 5 ngày
(138 Đánh Giá)
6.4
yogeshssanwal

Greetings from Webs Cybernetics!! We read your project description very carefully however it was not that long. :) Take a look to my last work: [url removed, login to view] [url removed, login to view] http:/ Thêm

$155 USD trong 5 ngày
(108 Đánh Giá)
6.2
hawkscodeaus

Hi, I can start work on your project immediately once you confirm me and i am also open for further discussion if you want. I have 7+ years in web designing & development with good experience in following skills Thêm

$250 USD trong 3 ngày
(35 Đánh Giá)
6.4
$98 USD trong 3 ngày
(21 Đánh Giá)
5.4
FreelancerNasim

Dear Sir/Madam Take my great respect. As a senior web programmer, i would like to request you highly to give me a chance to work on your project. Over the last 5 years, I have been working as a Web Developer. I h Thêm

$222 USD trong 3 ngày
(28 Đánh Giá)
5.0
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Thêm

$250 USD trong 2 ngày
(10 Đánh Giá)
4.6
biswas108

Hello, I have very much sincerely gone through the job description & understood your [url removed, login to view] a professional web developer I am developing Wordpress website & plugin for many years & I am an advanced web de Thêm

$80 USD trong 1 ngày
(16 Đánh Giá)
4.3
dchaidaris

Hello, I offer hosting on the best server-side configuration. My clients are mainly big news sites that want the best speed for their site with under 2 seconds on average. I can guarantee that yours will have sim Thêm

$88 USD trong 3 ngày
(23 Đánh Giá)
4.5
Zordeex

I have developed 157+ CUSTOM WEBSITE only in 2016 (Fiverr, Upwork and Freelancer marketplace), also having 8 years of experience in this era. My strongest skill is “WORDPRESS” website building and highly expert in Thêm

$250 USD trong 3 ngày
(19 Đánh Giá)
4.3
dezines99

Hi, Expert here,ready to start immediately. I will always available to discuss project specs.I have reviewed all your requirements and can deliver exactly what you are looking for, 100% guaranteed. I am confident to Thêm

$250 USD trong 0 ngày
(15 Đánh Giá)
4.3
BlitzCodeSys

WE KNOW HOW TO SOLVE THIS ISSUE. WE HAVE SOLVED THIS BEFORE FOR MANY WEBSITES. WE CAN GET IT DONE WITHIN A FEW HOURS. LET'S TALK AND GET IT DONE ALREADY. WE ARE A TEAM OF SOFTWARE PROFESSIONALS WITH AN EXPERIE Thêm

$155 USD trong 3 ngày
(1 Đánh Giá)
3.3
asin1987

Dear Employer, I will build the website for you. Below is my portfolio: Heavy Websites: 1) [url removed, login to view] 2) [url removed, login to view] 3) [url removed, login to view] 4) ht Thêm

$250 USD trong 3 ngày
(1 Đánh Giá)
3.4
Arbutus9

We are a group of developers with a proven track record in Website Designing, Software and Mobile app development. We have a team of 20+ including Developers, Designer and Tester with an average 3 years of experience i Thêm

$135 USD trong 3 ngày
(5 Đánh Giá)
2.9
gauravpathania38

Hi, Greetings !! I have completed and successfully delivered 250+ projects during my last 6 years of career which includes simple one page website to highly configurable large level applications. WordPress Exp Thêm

$246 USD trong 3 ngày
(3 Đánh Giá)
2.0
Ocean7

Good day! I have reviewed the details of your job description and I am confident to work on this while meeting your expectations. Having 11+ years working experience in developing database driven mobile responsiv Thêm

$200 USD trong 3 ngày
(2 Đánh Giá)
2.1