We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Website always down when doing some heavy stuff
Website always down when doing some heavy stuff
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 ?
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 ?
-
- Posts: 31
- Joined: Wed Jul 13, 2016 1:35 pm
Re: Website always down when doing some heavy stuff
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.
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.
Re: Website always down when doing some heavy stuff
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.DarthVader wrote: ↑Mon Mar 12, 2018 9:25 pmWhat 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.
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.
Re: Website always down when doing some heavy stuff
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.
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.
Re: Website always down when doing some heavy stuff
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.DarthVader wrote: ↑Mon Mar 12, 2018 9:25 pmWhat 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.
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.