Fix database and website issues

Lezárva Kiadva: 5 évvel ezelőtt Kiszállításkor fizetve
Lezárva Kiszállításkor fizetve

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

Code:

=== TOP 10 of 10 (total) Slow Queries for the past 24 hours ==========

1. Executed 6h 46m 33s ago for 63.005867 sec on Database --> Unknown (NOT FOUND / DELETED)

Date: 2018-04-18 03:58:14 Query_time: 63.005867 Rows_examined: 5243057: Rows_sent 5243057 Lock_time: 0.000053

# Schema: rodneyw3_hung Last_errno: 0 Killed: 0 select * from `table_temp_property1`;

2. Executed 3h 31m 35s ago for 58.577935 sec on Database --> Unknown (NOT FOUND / DELETED)

Date: 2018-04-18 07:13:12 Query_time: 58.577935 Rows_examined: 5243073: Rows_sent 5243073 Lock_time: 0.000103

# Schema: rodneyw3_hung Last_errno: 0 Killed: 0 select * from `table_temp_property1`;

3. Executed 3h 50m 4s ago for 51.287363 sec on Database --> Unknown (NOT FOUND / DELETED)

Date: 2018-04-18 06:54:43 Query_time: 51.287363 Rows_examined: 5243073: Rows_sent 5243073 Lock_time: 0.000168

# Schema: rodneyw3_hung Last_errno: 0 Killed: 0 select * from `table_temp_property1`;

4. Executed 3h 25m 52s ago for 49.663176 sec on Database --> Unknown (NOT FOUND / DELETED)

Date: 2018-04-18 07:18:55 Query_time: 49.663176 Rows_examined: 5243073: Rows_sent 5243073 Lock_time: 0.000131

# Schema: rodneyw3_hung Last_errno: 0 Killed: 0 select * from `table_temp_property1`;

5. Executed 3h 35m 9s ago for 49.333351 sec on Database --> Unknown (NOT FOUND / DELETED)

Date: 2018-04-18 07:09:38 Query_time: 49.333351 Rows_examined: 5243073: Rows_sent 5243073 Lock_time: 0.000110

# Schema: rodneyw3_hung Last_errno: 0 Killed: 0 select * from `table_temp_property1`;

6. Executed 3h 41m 7s ago for 49.228277 sec on Database --> Unknown (NOT FOUND / DELETED)

Date: 2018-04-18 07:03:40 Query_time: 49.228277 Rows_examined: 5243073: Rows_sent 5243073 Lock_time: 0.000127

# Schema: rodneyw3_hung Last_errno: 0 Killed: 0 select * from `table_temp_property1`;

7. Executed 3h 38m 10s ago for 48.759099 sec on Database --> Unknown (NOT FOUND / DELETED)

Date: 2018-04-18 07:06:37 Query_time: 48.759099 Rows_examined: 5243073: Rows_sent 5243073 Lock_time: 0.000097

# Schema: rodneyw3_hung Last_errno: 0 Killed: 0 select * from `table_temp_property1`;

8. Executed 5h 26m 12s ago for 47.89025 sec on Database --> Unknown (NOT FOUND / DELETED)

Date: 2018-04-18 05:18:35 Query_time: 47.890250 Rows_examined: 5243057: Rows_sent 5243057 Lock_time: 0.000104

# Schema: rodneyw3_hung Last_errno: 0 Killed: 0 select * from `table_temp_property1`;

9. Executed 4h 14m 11s ago for 47.849691 sec on Database --> Unknown (NOT FOUND / DELETED)

Date: 2018-04-18 06:30:36 Query_time: 47.849691 Rows_examined: 5243073: Rows_sent 5243073 Lock_time: 0.000058

# Schema: rodneyw3_hung Last_errno: 0 Killed: 0 select * from `table_temp_property1`;

--

10. Executed 3h 22m 11s ago for 47.695407 sec on Database --> Unknown (NOT FOUND / DELETED)

Date: 2018-04-18 07:22:36 Query_time: 47.695407 Rows_examined: 5243073: Rows_sent 5243073 Lock_time: 0.000071

# Schema: rodneyw3_hung Last_errno: 0 Killed: 0 select * from `table_temp_property1`;

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.

Based on the report there are a few things that you can focus on in order to improve the overall performance and increased the loading speed for the site.

In the YSlow section, you have recommendations on what exactly can be improved. I would recommend performing the following changes:

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

Adatbázisfelügyelet Adatbázis-programozás HTML MySQL PHP

Projektazonosító: #16732105

A projektről

16 ajánlat Távolról teljesíthető projekt Utoljára aktív: 5 évvel ezelőtt

16 szabadúszó tett átlagosan 156$ összegű árajánlatot erre a munkára

drgold03

I can do this now Hello I am good in mysql and have a lot experience Looking forward to connecting and working with you soon. Regards

$155 USD 3 napon belül
(171 vélemény)
7.5
gursukh

A proposal has not yet been provided

$111 USD 2 napon belül
(249 vélemény)
6.9
michealperfect

I am a professional web designer and developer. Experience in with HTML, CSS, JS, jQuery, PHP, Laravel,MySQL. Very familiar with WordPress , MAgento , wooCommerce , Bootstrap ,Plugins ,API's and its customization. I Továbbiak

$155 USD 3 napon belül
(190 vélemény)
6.9
RizwanaNawaz

Hi i am ready to Fix database and website issues according your requirement . my objectives is customer satisfaction i will give you 100% result when you want to start work? i am waiting for your response ?

$111 USD 3 napon belül
(15 vélemény)
5.5
julienmoutier

Hi, I can do it now. Please contact me to discuss it further, thanks ! --------------------------------------------------------------------

$88 USD 1 napon belül
(29 vélemény)
5.2
chandandubey

I can do it now

$77 USD 2 napon belül
(96 vélemény)
5.4
amiexpart

Hello, I have more than 10 years experience in web server admin. I can fix/audit this issue. Please let me know when can I start. Thanks, Amita G

$66 USD 3 napon belül
(44 vélemény)
4.8
BlackBeard9

I have +6 years experience in web development..I worked along time with MySql and I will do what you want in a really short time..JUST GIVE IT A TRY AND YOU WILL NOT REGRET!

$55 USD 3 napon belül
(15 vélemény)
4.6
Yorkiebar15

I can do this now. Hello, Is your website built in WordPress or is it custom PHP files? It appears from your logs that the issue is with one query which is selecting all 5.2 million rows within your table at once. Továbbiak

$190 USD 1 napon belül
(29 vélemény)
4.7
hamzasajid424

Hi, i a professional software engineer and can fix your website for you. contact me to further discuss this project. thanks

$155 USD 3 napon belül
(4 vélemény)
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 Továbbiak

$222 USD 3 napon belül
(6 vélemény)
2.7