Question

How To Handle All Types of Connection Issues in MySQL

  • Posted April 9, 2020
  • MySQL

Hello,

I was working on Windows 8 Single Language 64-Bit Operating System and on my website for the last 10 years.

But after creating MySQL Database, my system faced various number of errors and connection issues from time to time.

I have mainly 2 or 3 major problems which make me unable to work further in MySQL Database Server.

Whenever I want to perform a large number of databases using MySQL then I notice that my system is affected in this whole process. Sometimes it can affect my power system and automatically reboot the computer system.

I read certain blogs and they gave me a suggestion to create my own Database using RAM which will help to run any big operation without halting my computer system.

Is the above reason is the best for performing the big operations or it is just a myth?

Secondly, Whenever my internet connections do not worked properly in the middle of data transferring in MySQL

then I am getting a certain number of error messages and do not recover from it till the end of the operation.

I hope you read all my doubts and came with the best solution so that I can easily work on MySQL without any fear of losing data and connection.

Thanks for reading my query and please reply as soon as possible.

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Hi @smithhenrryy24,

Each MySQL error will be different; I would suggest you do capacity planning to get more resources (CPU&RAM) for your database server based on the size of the database.

You can reach out to DO support to check on the issue you are facing and help you better.

https://docs.digitalocean.com/support/

Regards, Rajkishore