Vesta Control Panel - Forum

Ok,

Here is what I am trying to do.

I am importing mysql database (about 25.000 rows).

The thing is, I can't do anything before the import is done.
The website can't open. It throws 500 Internal Server Error, on Inspect Element, it throws 504 gateway timeout.

My server is not running out of resource. I still have a lot of to spare.


And I can open, vestacp, phpmyadmin and other site (under different user) just fine. I am using a wordpress plugin to import database. Before the job finished, I can't open the website.

The same thing if I am doing the import from phpyadmin. Can't open the phpmyadmin before the import is done.

Is there any way to do stuff without blocking the whole website ?

What is Your IOWait??
Did you have HDD or SSD storage?

I suggest, you have hdd.
All disk resources are in use when import db.
How much? Try use top (io section on header) or iotop.

I recomend change storage to ssd if you have hdd.

This is not vesta problem.

DarthVader wrote: ↑

Mon Mar 12, 2018 9:25 pm

What is Your IOWait??
Did you have HDD or SSD storage?

I suggest, you have hdd.
All disk resources are in use when import db.
How much? Try use top (io section on header) or iotop.

I recomend change storage to ssd if you have hdd.

This is not vesta problem.

The thing is , I can open vestacp, phpmyadmin, and other stuff just fine. The only thing that is getting blocked is the website I use to import DB.

Do you think it still relate to io problem ? How does it work anyway ? Is there some io speed limitations for each user or what ?

I want to remove limitation impose by vestacp , I want to be able to use 100% RAM, CPU, and I/O.

There's several ways around this depending on the error you get and experience level you have.

1) You could try to increase your max timeout valeus in /etc/php/7.0/fpm/php.ini ... to then be able to import using phpmyadmin.

2) use https://www.ozerov.de/bigdump/ script.

3) use WXR file splitter: https://wpsites.net/tools/split-wxr-xml ... ler-files/

4) use adminer, see: viewtopic.php?t=14386

5) use terminal / ssh (the time retraints dont apply): mysql -u root -password admin_dbname < file.sql

I can highly recommend you start with 5 ;-) cause if that ain't working? It's either a corrupt SQL file, or some MySQL DB setting that ain't configured correctly / restriction that first has to be lifted.

DarthVader wrote: ↑

Mon Mar 12, 2018 9:25 pm

What is Your IOWait??
Did you have HDD or SSD storage?

I suggest, you have hdd.
All disk resources are in use when import db.
How much? Try use top (io section on header) or iotop.

I recomend change storage to ssd if you have hdd.

This is not vesta problem.

Probably this is not vesta problem. I just want to know what settings to change, to make me be able to use 100% of my resource.

Because right I now, I can't seem to do that.

Because right now, it's still inconsistent.

1 user is locked down (can't open the website) because doing some very intensive works, but other user works just fine.

I want to make so that, when 1 user doing some intensive works (whatever that case may be), it will use 100% of the server resource available, even if it means, making other users websites down as well. Right now, it seems vesta is limiting one user to specific amount of resource available so they won't disturb another user.