Annulleret

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.

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

Om arbejdsgiveren:
( 1 bedømmelse ) United Kingdom

Projekt-ID: #13450662

Tildelt til:

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 Mere

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

31 freelancere byder i gennemsnit $175 for dette job

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
(500 bedømmelser)
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 Mere

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

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

$180 USD in 3 dage
(283 bedømmelser)
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 in 5 dage
(138 bedømmelser)
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:/ Mere

$155 USD in 5 dage
(108 bedømmelser)
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 Mere

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

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

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

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

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

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

$155 USD in 3 dage
(1 bedømmelse)
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 Mere

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

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

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

$200 USD in 3 dage
(2 bedømmelser)
2.1