How To Handle All Types of Connection Issues in 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.