Dibatalkan

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.

Kemahiran: MySQL, SQL, Wordpress

Lihat lebih lanjut: 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

Tentang Majikan:
( 1 ulasan ) United Kingdom

ID Projek: #13450662

Dianugerahkan kepada:

TakeReal

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 Lagi

$150 USD dalam 3 hari
(1152 Ulasan)
7.6

32 pekerja bebas membida secara purata $174 untuk pekerjaan ini

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 Lagi

$100 USD dalam 3 hari
(395 Ulasan)
7.7
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 dalam 3 hari
(484 Ulasan)
7.5
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 dalam sehari
(257 Ulasan)
7.0
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 Lagi

$180 USD dalam 3 hari
(273 Ulasan)
6.8
scriptphp87

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 Lagi

$222 USD dalam 7 hari
(127 Ulasan)
7.4
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 dalam 5 hari
(132 Ulasan)
6.3
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 Lagi

$255 USD dalam 2 hari
(28 Ulasan)
6.0
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: https://www.solomonbrothers.com http://charleskrypell.com/ http:/ Lagi

$155 USD dalam 5 hari
(87 Ulasan)
5.8
$98 USD dalam 3 hari
(15 Ulasan)
4.8
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 Lagi

$222 USD dalam 3 hari
(16 Ulasan)
4.5
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 Lagi

$88 USD dalam 3 hari
(19 Ulasan)
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 Lagi

$250 USD dalam 0 hari
(13 Ulasan)
3.8
biswas108

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 Lagi

$80 USD dalam sehari
(11 Ulasan)
3.9
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 Lagi

$250 USD dalam 3 hari
(17 Ulasan)
3.5
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 Lagi

$250 USD dalam 3 hari
(3 Ulasan)
4.5
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 Lagi

$250 USD dalam 2 hari
(2 Ulasan)
3.4
$155 USD dalam 3 hari
(4 Ulasan)
2.0
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 Lagi

$246 USD dalam 3 hari
(2 Ulasan)
1.9
mobi20

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 Lagi

$77 USD dalam 3 hari
(2 Ulasan)
1.0
asin1987

Dear Employer, I will build the website for you. Below is my portfolio: Heavy Websites: 1) https://remitradar.com/ 2) http://www.acehardware.com.eg/ 3) http://www.v2leagues.com/realm-adventure-league/ 4) ht Lagi

$250 USD dalam 3 hari
(0 Ulasan)
0.0