Fix database and website issues
$30-250 USD
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"
Projektazonosító: #16732105
A projektről
16 szabadúszó tett átlagosan 156$ összegű árajánlatot erre a munkára
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
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
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 ?
Hi, I can do it now. Please contact me to discuss it further, thanks ! --------------------------------------------------------------------
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
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!
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
Hi, i a professional software engineer and can fix your website for you. contact me to further discuss this project. thanks