I was having reocurring issues with MySQL which I thought I had solved. Here is the closed ticket, it came back to haunt me with a vengence this week: MySQL crashing regularly - Insights needed)
I found this thread on jobs board Looking for new clients, and I contracted Scott, and he quickly fixed the mysql issue and helped explain where I went wrong (not enough virtual mem, mysql set to huge instead of medium).
It was a huge relief since I am more of an ambitious hobbyist than a system admin! Hope that it is ok post here, the previous posts were both closed, and thought this was worth a shout out.
Nice one Ilia, that is really good to know. I think I choose ‘Huge’ because it said recommended in caps, me being none the wiser, choose it for a vastly under-resourced server.
Hi Illia, I have 4 gb now (when set up the system It was only 2gb) but only had around 270mb for swap. Its currently got 2GB for swap, set on medium and is running smoothely.
When looking at the wizard, are the bracketed numbers (eg 256mb for small system) total system RAM or memory that is need for mysql? My understanding at the time that it was that it was for total system RAM.