Suljettu

Fix database and website issues and optimize database

he memory usage/spike is a result of the slow MySQL queries for your account:

I was able to reproduce the issue and it is caused due to slow MySQL queries as my colleague previously explained. While the website is loading, there are constant running MySQL queries such as the following:

Code:

+--------+------------+-----------+------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+-----------+---------------+

| Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined |

+--------+------------+-----------+------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+-----------+---------------+

| 328537 | rodneyw3_1 | localhost | rodneyw3_1 | Query | 17 | Sending data | SELECT post_id FROM wp3c_postmeta WHERE meta_key = '_wp_attached_file' AND meta_value = '2018/04/map | 1 | 0 |

| 328544 | rodneyw3_1 | localhost | rodneyw3_1 | Query | 2 | Sending data | SELECT post_id FROM wp3c_postmeta WHERE meta_key = '_wp_attached_file' AND meta_value = '2018/04/map | 1 | 0 |

| 328570 | rodneyw3_1 | localhost | rodneyw3_1 | Query | 8 | Sending data | SELECT [login to view URL] FROM wp3c_posts wposts, wp3c_postmeta wpostmeta WHERE [login to view URL] = wpostmeta.post_id | 0 | 0 |

| 328571 | rodneyw3_1 | localhost | rodneyw3_1 | Query | 7 | Sending data | SELECT post_id FROM wp3c_postmeta WHERE meta_key = '_wp_attached_file' AND meta_value = '2018/04/tex | 1 | 0

The website is loading slowly as each query takes too much time to access the needed data and there are multiple MySQL queries executed during a request. This cannot be resolved by adding more resources to the server, but the database will have to be reviewed and optimized. Especially the table with name wp3c_postmeta that has almost one million rows inside of it.

Slow queries cause a delay in the response time of websites and consume more CPU seconds and memory. They could also account for intermittent or sporadic 504 Gateway timeout errors. Optimizing them should reduce the CPU & Memory usage and may have a performance impact on the website.

Be advised that we are a hosting company and although we strive to provide the best support possible for you, database optimization is beyond our support scope as it requires deeper knowledge and skills of a professional MySQL developer.

Although our goals are to provide a high-quality hosting environment for WordPress websites, our Technical Support Team is specialized in providing assistance in case your script is not accessible due to a problem with your host server or a vital service running on it. Third-party application-related problems such as this are at times beyond the scope of our expertise.

You can also contact a professional developer who is familiar with the WordPress application and has the required knowledge and skill set to provide you with assistance on this issue.

Despite that I am unable to recommend such a developer, you should be able to find one from the freelance websites available online. You can also check our article on this here:

[login to view URL]

To assist you, I have placed the latest slow query logs in the file [login to view URL], located in your $HOME folder (/home/rodneyw3).

You will need optimize your databases as much as possible, to ensure better performance and to reduce server-side memory spikes.

For WordPress-based sites, we have the following optimization guides:

How to optimize a MySQL database using phpMyAdmin

How to Optimize WordPress for Better Performance

I' [login to view URL]), and based on the results your site would indeed benefit from optimizations.

Read the files as well

Read entire post below. If you can do it type "I can do this now"

Taidot: Tietokannan hallinto, Tietokantaohjelmointi, HTML, MySQL, PHP

Näytä lisää: fix website issues, how to fix website certificate errors, free fix website errors, fix website errors free, fix website compatibility issues, fix and optimize database queries in existing app, joomla website broken fix database, beer database type website showing beers tap bar, fix website database error, fix website compatibility issues dreamweaver, 504 gateway timeout error fix, safari fix website errors, fix website html errors, fix browser issues website, fix security issues website, fix database website, fix website errors, microsoft access database website, add simple database website, spider crawl database website

Tietoa työnantajasta:
( 9 arvostelua ) wichita falls, Germany

Projektin tunnus: #16761259

24 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

ysergeyevich

"I can do this now" Hello! Nice to meet you. I read your project carefully and what I want is, I'll finish your project more perfectly. I have rich experience with web development! Have more than 10 years experi Lisää

$116 USD 10 päivässä
(23 arvostelua)
0.0
adamlachut

Hi there, Same project :) https://www.freelancer.com/projects/php/Fix-database-website-issues-16735627/ So the same offer. Looking forward to hearing from you, Adam

$50 USD 3 päivässä
(52 arvostelua)
0.0
danale72

I can do this now It would be great to have the slow query log mentioned in the task description. Access to phpMyAdmin is enough to fix the issue. All the best Alex

$200 USD 10 päivässä
(60 arvostelua)
0.0
ludiac

I can do this now" Hi there, We've reviewed the description you posted and we can optimize MySQL DB to improve/fix your website. Let us know if you have any questions regarding our work history. Thank you!

$200 USD 5 päivässä
(17 arvostelua)
0.0
$200 USD 2 päivässä
(25 arvostelua)
0.0
hungvotan

with 10 years experience in Wordpress, PHP, Woocommerce, SEO. I can help you finish projects which you probose. we can communicate each other easily we had several year 's experience in this area. set your mind Lisää

$188 USD 10 päivässä
(6 arvostelua)
0.0
sreekrish87

Hi there, "I CAN DO THIS" I can help you with Fix database and website issues and optimize database. I do speak simple good English and is available 24/7 on all instant messengers for quick communication.. Kindl Lisää

$222 USD 10 päivässä
(33 arvostelua)
0.0
Minase

I can do this now. Hello, i'm an expert in database optimizations. I manage mysql databases that have milions of records. First i will need to analize the content of database, server resources available and after tha Lisää

$88 USD 1 päivässä
(8 arvostelua)
0.0
mizanbdit

Hi, I will clear / delete all unnecessary queries from the server and reduce database size, then will optimize all tables to speed up website. You will not see time out error from admin and you visitors will able to Lisää

$200 USD 3 päivässä
(94 arvostelua)
0.0
hawkscodeau

"I can do this now" Greetings, I hope you are fine. I am a Full Stack Developer. I would like to tell you that We are an IT firm in Australia. Currently, We are working on Web Development, App Development, IOS Lisää

$150 USD 10 päivässä
(7 arvostelua)
0.0
saurav1404

A proposal has not yet been provided

$166 USD 7 päivässä
(0 arvostelua)
0.0
forcitCample

Hi there, How are you? I get that you looking for web Expert To Optimize your website to load faster and fix the issues in the database code. I would like to tell you that I have Extensive experience working with PH Lisää

$250 USD 10 päivässä
(137 arvostelua)
0.0
$116 USD 10 päivässä
(14 arvostelua)
0.0
TheV927

I can do this now Hi there, I can help you out. I have extensive experience working with WordPress & MySQL Optimization and should be able to analyze your existing issues and optimize the databases and the querie Lisää

$200 USD 1 päivässä
(11 arvostelua)
0.0
amitpandeyposin

Hello I can do this now I have read the job description and understood the requirements and will fix the database and website issues as I have more than 6 years of experience in PHP and MySql database and if you Lisää

$200 USD 5 päivässä
(35 arvostelua)
0.0
abstractsoftweb

[login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] Lisää

$200 USD 10 päivässä
(103 arvostelua)
0.0
originitsolution

I can do this now Dear Sir, I researched your project Fix database on freelancer.com. Which is posted recently. Actually I have lot of experience in website development & designing. I work on various platforms Lisää

$15 USD 5 päivässä
(34 arvostelua)
0.0
CodeApex

"I can do this now" I am professional and will Fix database, website issues and optimize database. If we can discuss the attach & given issues in detail then will provide a much better solution. Assure quality of Lisää

$116 USD 5 päivässä
(3 arvostelua)
0.0
digitalsymantec

Hi, Trust you are doing good. We have a dedicated team on PHP and we can start working on your project right away, let’s discuss your requirement in more detail Here's a brief showcase of our expertise: Lisää

$222 USD 10 päivässä
(1 arvostelu)
0.0
diwanlive

"I can do this now" Hello, I read carefully your requirements and understand the task. I can start it right away if you allow me. I have 6+ years experience in PHP (Core/Laravel/CodeIgniter/Cake PHP), WordPress( Lisää

$100 USD 2 päivässä
(2 arvostelua)
0.0