Fix database and website issues

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"