Wordpress Database Expert Required

Lukket

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.

Færdigheder: MySQL, SQL, WordPress

Se mere: 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

Projekt-ID: #13450662

Tildelt til:

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 Mere

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

32 freelancere byder i gennemsnit $174 for dette job

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

$100 USD in 3 dage
(395 bedømmelser)
7.7
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 på 1 dag
(257 bedømmelser)
7.0
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 Mere

$222 USD in 7 dage
(127 bedømmelser)
7.4
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 Mere

$180 USD in 3 dage
(273 bedømmelser)
6.8
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 in 5 dage
(132 bedømmelser)
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 Mere

$255 USD in 2 dage
(28 bedømmelser)
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:/ Mere

$155 USD in 5 dage
(87 bedømmelser)
5.8
$98 USD in 3 dage
(15 bedømmelser)
4.8
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 Mere

$88 USD in 3 dage
(19 bedømmelser)
4.3
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 Mere

$222 USD in 3 dage
(16 bedømmelser)
4.5
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 Mere

$80 USD på 1 dag
(11 bedømmelser)
3.9
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 Mere

$250 USD in 0 dage
(13 bedømmelser)
3.8
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 Mere

$250 USD in 2 dage
(2 bedømmelser)
3.4
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 Mere

$250 USD in 3 dage
(3 bedømmelser)
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 Mere

$250 USD in 3 dage
(17 bedømmelser)
3.5
$155 USD in 3 dage
(4 bedømmelser)
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 Mere

$246 USD in 3 dage
(2 bedømmelser)
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 Mere

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

Hello there! I can do it for 200$. I read your requirement and would like to work with you. I have been working for Web Development industry from last 3 years. I worked for 190+ we Mere

$111 USD in 2 dage
(2 bedømmelser)
0.0