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"