What exactly bottlenecking my VPS ?
FIrst thing first. I am using vestacp, I don't know if it matters or not.
I am using adminer to import a database (about 25.000 rows). The thing is, before the database import is completed, I can not visit or interact with my website. **However ** the website on other users just fine.
I can visit my control panel just fine, i can visit phpmyadmin, i can visit another user websites just fine. The only thing that seemingly to be blocked is the website that I use to import database.
And how does it work anyway ? if it's a matter of lack of resource (I am pretty sure it's not, based on my server monitor), why it's only affecting one user ? I want to be able to use 100% of my resource, even if it means bring the entire vps down.