Why mysql crashes when importing goods and how to set up vds for faster data loading?

Question

MySQL

The site is written in yii (I won't say anything about how mysql queries are written). Located on a dedicated vds server: nginx, apache, php, mysql. Configuration - Processor: 2 x 2.7 GHz, RAM: 1024 MB, HD - 30 GB.
Long loading pages (queries to the mysql database). Mysql also often crashes when importing and exporting goods.
At once I will tell here wrote in search of the programmer-administrator. Are there experts in setting up servers and optimizing queries from St. Petersburg?

Answer 1

Is mysqld itself crashing? or the import/export page returns 504?
Regarding the programmer-administrator, you can visit https://freelansim.ru/ (and why is it necessary from St. Petersburg?)

Answer 2

Gig memory is very small
Run mysqltuner
Analyze mysql slow log
If you don't figure it out yourself, write to the mail