安装MySQL后无法SSH到Google Cloud VM

I experienced a similar issue with a MySQL Instance in GCP, the first issue was related with the type of the VM instance I used, I had a f1-micro machine type on this VM Instance and suddenly I wasn’t able to access the ssh. As this type of VM Instance has only 0.6GB of memory, it became out of memory soon, I changed it to a e2-medium that is value by default and it resolved my problems this time. As the Instance was out of memory the services in the instance started to fail, it was the reason that I can't access my instance.

At another time I started again with similar issues, but this time, the problem was the disk, I only had 10 GB and there was a process filling my disk, when a partition was out of space, the instance started to fail again. I only resized my disk, now my instance disk is 20GB and is working fine.

Having said that, I suggest increasing your resources per your convenience to enhance your performance, because to have the problems you described is a good indicator that your existing machine type is not a good fit for your workloads you run on that instance.

So, I suggest to change the machine type to adjust your memory and you can follow the next steps for these tasks please visit the following link to get further information about it.

Changing a machine type

1.- Go to the VM Instances page.

2.- In the Name column, click your instance.

3. From the instance details page, complete the following steps:

   a) Click the Stop button to stop the instance, if you have not stopped it yet.

   b) After the instance stops, click the Edit button at the top of the page.

   c) Under the Machine configuration section, select the machine type you want to use, or create a custom machine type to increase only the Memory.

   d) Save your changes and start again your VM Instance.

You can resize your disk following this guide or with the following command:

gcloud compute disks resize DISK_NAME --size DISK_SIZE

Or with the Console:

1. Go to the Disks page to see a list of zonal persistent disks in your project.
2. Click the name of the disk that you want to resize.
3. On the disk details page, click Edit.
4. In the Size field, enter the new size for your disk.
5. Click Save to apply your changes to the disk.

After you resize the disk, you must resize the file system so that the operating system can access the additional space.

注意：请勿将引导磁盘的大小调整为超过2 TB，因为这是限制。