Đã Đóng

Fix database and website issues2

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 [url removed, login to view] FROM wp3c_posts wposts, wp3c_postmeta wpostmeta WHERE [url removed, login to view] = 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:

[url removed, login to view]

To assist you, I have placed the latest slow query logs in the file [url removed, login to view], 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' [url removed, login to view]), 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"

Kĩ năng: Quản trị cơ sở dữ liệu, Lập trình cơ sở dữ liệu, HTML, MySQL, PHP

Xem nhiều hơn: fix website issues, Fix current code issues with dobryprad.pl website, joomla website broken fix database, fix database website, microsoft access database website, add simple database website, spider crawl database website, connecting database website, fix browser compatibility issues, fix database error, baby name database website, movie database website, fix browser alignment issues, update access database website script, creating product database website, database website using excel, fix database problems, website let type japanese, database website form newsletter

Về Bên Thuê:
( 9 nhận xét ) wichita falls, Germany

ID dự án: #16735627

22 freelancer đang chào giá trung bình $180 cho công việc này

AltiuseCreaton

Hello, "I can do this now" I checked your database issue with wordpress refine work in brief. I am ready to start and fix asap today itself Regards Rina

$233 USD trong 1 ngày
(82 Nhận xét)
7.2
Avinavkr

[login to view URL]

$166 USD trong 3 ngày
(104 Nhận xét)
6.7
Alka700

Dear Sir, I have gone through your requirement and things are clear to [login to view URL] share details and ping me for further discussion. Spare a moment on our previous work [login to view URL] http://editorialsl. Thêm

$155 USD trong 3 ngày
(47 Nhận xét)
6.2
ykarora26

Hello Sir, I am an experienced professional web master, working with Word press, joomla, magneto, open cart, prestashop , Shopify, big commerce volusion for over 8 years now. I have knowledge of HTML, CSS, jQuery Thêm

$133 USD trong 4 ngày
(114 Nhận xét)
6.3
mizanbdit

Hi, I ready your full description, understood that problem is with database mainly and then in the website. I will optimize both database tables and website to speed up the site. I will clean these queries, I know h Thêm

$250 USD trong 4 ngày
(92 Nhận xét)
6.2
Lavlu

Hello, Please check my portfolio. [login to view URL] I am comfortable to do this project. We can worked on many such project for our clients. I have few questions related to the requirement . Please confirm and we Thêm

$244 USD trong 3 ngày
(31 Nhận xét)
6.8
deepakgoyal92

I can do this

$200 USD trong 3 ngày
(44 Nhận xét)
5.5
$111 USD trong 3 ngày
(27 Nhận xét)
5.3
adamlachut

Hi there, These are usual WP queries, but, most likely, the problem is here: "" the table with name wp3c_postmeta that has almost one million rows inside of it."" In many cases (if you don't have tens of thousands o Thêm

$50 USD trong 1 ngày
(49 Nhận xét)
5.0
piasys

I can do this now Hi, I have gone through the information provided (including the links) and I see that there are other issues besides MySQL queries wrt headers and caching. Additionally, the MySQL queries are Thêm

$250 USD trong 21 ngày
(10 Nhận xét)
4.7
amitpandeyposin

Hello I can do this now As I have more than 6 years of experience in website development using PHP and have quite good hands in the database as well so I will fix the database and website issue and assure that yo Thêm

$201 USD trong 4 ngày
(25 Nhận xét)
4.6
awnishdubey1990

I can do this Now Dear sir, I'm very interested for this database & Mysql project, I have 4+ Year of experience in this Field & I can surely do this project, I work with My Experienced Team who always looki Thêm

$100 USD trong 3 ngày
(13 Nhận xét)
3.5
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 Thêm

$222 USD trong 3 ngày
(6 Nhận xét)
2.7
nubeorbsolutions

i can do this now. i can do this now. 'i can do this now. i can do this now. i can do this now. i can do this now. i can do this now. 'i can do tihs now. i can do this now. i can do this Thêm

$155 USD trong 3 ngày
(3 Nhận xét)
2.8
varyavega

Hello Sir/Madam, I have gone through your post and delighted to say that I am looking forward to work with you. Having garnered years of experience and expertise in the relevant field, I am sure that I can swimmingl Thêm

$200 USD trong 3 ngày
(2 Nhận xét)
2.1
$155 USD trong 3 ngày
(0 Nhận xét)
0.0
guptaranjeet

Hi there, Greeting. I have reviewed you are looking Developer for Fix database and website issue. I'm quite interested in your project. Let me explain my experience. I have 8 years strong Web Development and Front-end Thêm

$100 USD trong 2 ngày
(0 Nhận xét)
0.0
bapixyrs

Hello, I am skilled in developing Android ,Iphone, and Ipad apps. My skills includes Android SDK, JAVA ,Android Development Webservices, Cocoa Framework ,React Native, XCode ,iPhone SDK ,Cocos2D,OpenGL ES, Master Da Thêm

$155 USD trong 3 ngày
(1 Nhận xét)
0.0
rabiamasood

we need to transform your queries. it needs a week or two May be. if you are interested then contact me

$277 USD trong 7 ngày
(0 Nhận xét)
0.0
$155 USD trong 3 ngày
(0 Nhận xét)
0.0