Troubleshoot MySQL crashing on WordPress server with minimal load

Job ID: 37236520

Budget: $10 – $11 USD

I am looking for a freelancer who can troubleshoot the issue of MySQL crashing on my WordPress server, even with minimal load.

I use a cheap shared Linode server (Nanode 1GB RAM $5/month) on Linux CentOS 7, with aaPanel and LEMP.

I’m trying to install a vanilla WordPress+WooCommerce, but the moment I access the admin UI of WooCommerce, the server reaches 100% load, and it crashes MySQL (I need to restart MySQL by hand every time). No visitors on the website, only me working on the Admin panel.

I am aware that adding more RAM and CPU cores fixes my issue, but I would prefer to not invest more at this stage (even if that involves a slow server). My main priority is to stop MySQL crashing every time.

I have allowed 256MB of memory in PHP to the Wordpress instance (required by WooCommerce) but still have the same issue. I have a Caching plugin and CloudFlare is properly setup too.

I am not a backend developer and have no idea of how to edit the MySQL configuration appropriately to avoid the crashes.

To confirm that you have really read the project, write "DOGE" somewhere in your bid (otherwise it will be ignored). Also, bid at 10$ only (higher bids will be ignored).
Related categories: PHP Linux WordPress Apache MySQL