Help me about VPS

[redpanty]

Hi, currently I have a 512mb ram 1 core vps, my question is

1. if I want to install phpmyadmin and cpanel to my vps, does it uses more ram or does it slows down my websites on that vps? sorry for this noob question because I saw someone said that phpmyadmin and cpanel use a lot of resources, and by that Resources thing I do not know what that person is talking about, is it on ram, cpu usage, or it is just storage, thats why I got confuse. please help me to understand this.

2. phpmyadmin and cpanel slows down websites on a small vps plan, does it slows down while just using phpmyadmin and cpanel or it slows down even i am not using phpmyadmin and cpanel?

3. Is there other option to import wordpress database aside from server to server and phpmyadmin? can I upload the database via FTP?

please help me

 

[Bots-Scrapers]

Pm me. And google is your friend. Use it.. Here nobody gonna say words..

 

[redpanty]

I tried to google it and search on this forum but I can not get the answer, why no one will say words? I thought BHW is a family and helps each other.

 

[HudsonWebServices]

Pm me. And google is your friend. Use it.. Here nobody gonna say words..

Oh really? I beg to differ in that regard as I always c0mment on this.

OP you are going to run into issues with that small amount of ram. We aren't in the 1990s, you most definitely will need to upgrade to at least a gig. Cpanel requires at least a gig, but I would highly suggest getting two gigs

 

[redpanty]

What kind of issues will I get? yes I will try to get 1gb or 2gb, can you please help me with my question? Thanks

 

[FaithlessDbo]

Pm me. And google is your friend. Use it.. Here nobody gonna say words..

Actually I am feeling generous Everyone has to start somewhere, right?

Hi, currently I have a 512mb ram 1 core vps, my question is
1. if I want to install phpmyadmin and cpanel to my vps, does it uses more ram or does it slows down my websites on that vps? sorry for this noob question because I saw someone said that phpmyadmin and cpanel use a lot of resources, and by that Resources thing I do not know what that person is talking about, is it on ram, cpu usage, or it is just storage, thats why I got confuse. please help me to understand this.
2. phpmyadmin and cpanel slows down websites on a small vps plan, does it slows down while just using phpmyadmin and cpanel or it slows down even i am not using phpmyadmin and cpanel?
3. Is there other option to import wordpress database aside from server to server and phpmyadmin? can I upload the database via FTP?
please help me

1) Of course installing something on your VPS will cost resources. First of all it will take disk space (like duh)... Linux also makes use of something called a cron job. This is an automatic process that happens x amount of time per day. I'm not quite sure how many times per day. This will cost CPU power and so it will also cost RAM, these 2 work together.

2) Basicly I already answered this question in the first question. Essentially, yes it will slow down your website. How much? Can't really tell without the CPU specs, but I don't think it will be a massive amount. Of course "a massive amount" for me can be different for you, depends on the situation.

3) Yes there is another way to import them. Search for something called remote MySQL access.

I hope this information was useful to you

 

[redpanty]

1) Of course installing something on your VPS will cost resources. First of all it will take disk space (like duh)... Linux also makes use of something called a cron job. This is an automatic process that happens x amount of time per day. I'm not quite sure how many times per day. This will cost CPU power and so it will also cost RAM, these 2 work together.

2) Basicly I already answered this question in the first question. Essentially, yes it will slow down your website. How much? Can't really tell without the CPU specs, but I don't think it will be a massive amount. Of course "a massive amount" for me can be different for you, depends on the situation.

3) Yes there is another way to import them. Search for something called remote MySQL access.

I hope this information was useful to you

First of all thank you for being generous

If I installed phpmyadmin, does it slows down while I am log in to phpmyadmin or it still slows down even I am not log in and using phpmyadmin at the moment?

will search for emote MySQL access

Thanks

 

[HudsonWebServices]

What kind of issues will I get? yes I will try to get 1gb or 2gb, can you please help me with my question? Thanks

Everything, you will run into errors when ram runs out. cPanels bare minimum recommendations are at least 1gb, but you should NEVER go with the bare. Upgrade to 2gbs of ram and save yourself the headache.

 

[HudsonWebServices]

First of all thank you for being generous

If I installed phpmyadmin, does it slows down while I am log in to phpmyadmin or it still slows down even I am not log in and using phpmyadmin at the moment?

will search for emote MySQL access

Thanks

FYI, if you install cpanel phpmyadmin comes with it as a default.

 

[FaithlessDbo]

First of all thank you for being generous

If I installed phpmyadmin, does it slows down while I am log in to phpmyadmin or it still slows down even I am not log in and using phpmyadmin at the moment?

will search for emote MySQL access

Thanks

To get an accurate answer on this I would advice you to install an application called htop. This can be done by writing the following command in your VPS (through SSH)

sudo apt-get install htop

When it's installed you can just write htop in your prompt. You will see a list of running processes. Search for phpmyadmin and monitor it. When you acces it you will see a spike, and when you are not using it you may see a few Bytes running through. Perhaps even a few MiB's. Nothing really to worry about.

Overall this is a very nice tool to have on your server to monitor your processes.

 

[redpanty]

Everything, you will run into errors when ram runs out. cPanels bare minimum recommendations are at least 1gb, but you should NEVER go with the bare. Upgrade to 2gbs of ram and save yourself the headache.

Ok, will take note on that. will use it to my servers that has cpanel Thanks

FYI, if you install cpanel phpmyadmin comes with it as a default.

Some servers that I have I will not install cpanel just phpmyadmin to upload files.

To get an accurate answer on this I would advice you to install an application called htop. This can be done by writing the following command in your VPS (through SSH)

sudo apt-get install htop

When it's installed you can just write htop in your prompt. You will see a list of running processes. Search for phpmyadmin and monitor it. When you acces it you will see a spike, and when you are not using it you may see a few Bytes running through. Perhaps even a few MiB's. Nothing really to worry about.

Overall this is a very nice tool to have on your server to monitor your processes.

Will use htop, this is new to me and this is very helpful, will search more about htop to learn more.

Ok, I get it now, I thought If am not using the phpmyadmin at the moment It will still give spikes from the server load, few Bytes is ok, Will use htop on this to see it myself. Thank you so much you are veryhelpful

 

[wooph]

Just curious @redpanty have you tried server pilot? Might be worth looking into if you haven't already.

 

[Archard]

Actually, installing phpMyAdmin on that vps will be ok, as it will consume resources only when used. I can confirm 512 Mb ram will be enough to import your .sql file and do exports once in a while.
cPanel is another deal and sadly, you can not run it on that vps, and you don't need it that much, as phpMyAdmin will be enough.
Just do this:
1) yum install epel-release
2) yum install phpMyAdmin

 

[redpanty]

Just curious @redpanty have you tried server pilot? Might be worth looking into if you haven't already.

No I did not tried it yet, but I think serverpilot and other same services are great. I just want to setup my vps on my own. by the way thank you for your recommendation.

 

[redpanty]

Actually, installing phpMyAdmin on that vps will be ok, as it will consume resources only when used. I can confirm 512 Mb ram will be enough to import your .sql file and do exports once in a while.
cPanel is another deal and sadly, you can not run it on that vps, and you don't need it that much, as phpMyAdmin will be enough.
Just do this:
1) yum install epel-release
2) yum install phpMyAdmin

I see, I will just need phpmyadmin to import/export database. I will not use cpanel on 512mb server. Will put some sites on a 512mb server that do not have traffic yet once it got traffic will transfer it to my other severs.

I am just worried that phpmyadmin will cause slow website speed on a lowend server. I am glad that you and other members here are there to help beginners like me Thank you so much

 

[reko888]

Want to +1 for phpmyadmin will not slow down your website.

Phpmyadmin is just a front end for your database. If you aren't actively using it, it will be like a staic site taking up disk space, nothing more.

 

[redpanty]

Want to +1 for phpmyadmin will not slow down your website.

Phpmyadmin is just a front end for your database. If you aren't actively using it, it will be like a staic site taking up disk space, nothing more.

Thanks for the help and recommendation, really appreciate it sir

 

[Deleted member 657006]

why would you pay for a cpanel lic when you can get a really good hired host ?

 

[Couch Monkey Media]

If you are planning on running cPanel then you want to have atlas 1 GB of ram. Anything less than that then you are going to run into issues.

 

[HudsonWebServices]

Pm me. And google is your friend. Use it.. Here nobody gonna say words..

Man, so little words being said on this post.