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' )


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.

Færdigheder: MySQL, SQL, WordPress

Se mere: import recipe database wordpress, import access database wordpress, convert database wordpress, import post database wordpress, clean mysql database wordpress, access database wordpress, import mysql database wordpress, import sql database wordpress, import database wordpress, joomla database wordpress, database wordpress joomla, prestashop database wordpress merge

Om arbejdsgiveren:
( 1 bedømmelse ) United Kingdom

Projekt-ID: #13450662

Tildelt til:


Hello, My name is Sergey. I am Freelancer from St.Petersburg, 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 Mere

$150 USD in 3 dage
(1152 bedømmelser)

32 freelancere byder i gennemsnit $174 for dette job


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 Mere

$100 USD in 3 dage
(395 bedømmelser)

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 in 3 dage
(484 bedømmelser)

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 på 1 dag
(257 bedømmelser)

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 Mere

$180 USD in 3 dage
(273 bedømmelser)

Hello, I'm a professional programmer for web programming with php language to build the system website, Besides, I'm also expert in MySQL , HTML,HTML5,CSS, JS I'm always top in Vietnam freelancer https://www.freela Mere

$222 USD in 7 dage
(127 bedømmelser)

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 in 5 dage
(132 bedømmelser)

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 Mere

$255 USD in 2 dage
(28 bedømmelser)

Greetings from Webs Cybernetics!! We read your project description very carefully however it was not that long. :) Take a look to my last work: http:/ Mere

$155 USD in 5 dage
(87 bedømmelser)
$98 USD in 3 dage
(15 bedømmelser)

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 Mere

$222 USD in 3 dage
(16 bedømmelser)

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 Mere

$88 USD in 3 dage
(19 bedømmelser)

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 Mere

$250 USD in 0 dage
(13 bedømmelser)

Hello, I have very much sincerely gone through the job description & understood your requirements.As a professional web developer I am developing Wordpress website & plugin for many years & I am an advanced web de Mere

$80 USD på 1 dag
(11 bedømmelser)

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 Mere

$250 USD in 3 dage
(17 bedømmelser)

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 Mere

$250 USD in 3 dage
(3 bedømmelser)

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 Mere

$250 USD in 2 dage
(2 bedømmelser)
$155 USD in 3 dage
(4 bedømmelser)

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 Mere

$246 USD in 3 dage
(2 bedømmelser)

Helloo, I can do this.Are you still online. Discuss for more project detail. Here is my portfolio: I'm talented and highly experienced Web developer and WordPress Expert. Over the last 7 years. I have a wide var Mere

$77 USD in 3 dage
(2 bedømmelser)

Dear Employer, I will build the website for you. Below is my portfolio: Heavy Websites: 1) 2) 3) 4) ht Mere

$250 USD in 3 dage
(0 bedømmelser)