The speed of VPS - Caching in RAM, Fastening of MySQL

coolice

Owner
dmb каза:
Is there a way to compensate the lack of RAM? It’s been always a main component because of the slow hard disk. That is true for the home PCs too. The software sees that and it tries to use the RAM more and more often because it is faster than the hard disk. That’s done by Apache and muscle. So if the RAM gets a cut when the SSDs are faster at that moment, will this make the servers slower than before? I’m using 4GB RAM now and if I use 2GB my server will be not fast enough to handle my needs even if it has SSD disks.

It is possible that some providers are overselling a lot, but Delta are offering high-quality services. using VPS. The new service with the SSD drives is very good too. I’m sure about that. My experience with them is excellent!.

The prices are getting lower and lower especially the prices of RAM. In 2010 a dedicated server with 2GB ram which I used cost 119 dollars, after that they’ve added another 2 gigabytes of RAM for free. There was a thread in 2011 about that and in 2013 there was an offer for 119 dollar. In exchange you will use 16 GB RAM i7 (8 threads) 2 x 500GB hard drives. That was offered by iWeb. I’m a subscriber of their newsletter and I’m always in touch with the promotions. Of course there is a catch! The hard disks you will use are 7200rpm. The server will cost a lot more if it uses SSD disks may be the disks are more expensive than the whole server.

Offtopic:

Since when you are spending over 100 dollars for a VPS? Some of the international provides including the US ones and the one you are talking about increased the RAM included in their VPS packages and the Dedicated servers.*

If it is not a secret for what are you using that 4 gigabytes? What is your web server and what is its configuration. Predpriemach.com is using 6 times less CPU since I remove Apache and started to use Nginx. Since I started to use MPM (first I used worker than Event) the RAM it is using is a few hundred megabytes. When I used apache without any optimizations it opened a process for every user that visited the forum. The used ram was 1,5 GB. Now when I use Nginx the site can use VPS. It uses almost no RAM. Only the PHP with its caching. You can hire someone to configure and optimize your server and you will find that a smaller VPS will suit your needs. The other option is to get a managed VPS from a company that offers them. Ask them for their optimized variations of the server configuration.
 
Последно редактирано от модератор:

dmb

New Member
Speeding VPS | RAM Caching | MySQL Fasting

I’m not a specialist. My experience points that the databases are overloading the machine when they are stuck with info.

The solution is to delete some old publications. For me 4 gigabytes of RAM are enough for a server when you make the maintenance early enough. Probably the forum is optimized script. This can’t be told about the popular free CMSs which are not. They are all hard to use.
 
Последно редактирано от модератор:

coolice

Owner
How to check connectivity / network speed of a VPS

Offtopic: If someone is interested in server caching I will make a thread about it ;)

In my opinion in 2009 the disk cache of Drupal was one of the best and it is still good enough, but the caching plugins for Wordpress are a few years ahead in the future. The good configuration of the forum is thanks to vBulletin, some caching, the fast webserver (I’ve tested a lot of options for this and I think that is the best one).

What is the free script you are using? How big is the database and what are the settings? Did you use, mysql tunner пускал ли си

Another option for you if you have more than 1 GB of RAM (it is the minimum for tocudb) you can try tokudb and their storage engine and fractional index. It is fast and a truly direct replacement of the popular engines. http://www.tokutek.com/products/tokudb-for-mysql/*(it is imported in MariaDB too and is a standard engine for some of the CMSs out there. It is a replacement of mysql) Too bad it can be used only on Fedora and Debian if you intend to run MariaDB.
 
Последно редактирано от модератор:

dmb

New Member
I’ve lost a lot of time to optimize my server. I even threw a lot of money on a specialist for consultations. He helped a bit but no enough. Things are going like in the past. When the database gets bigger and things get worse. The best results I’ve ever achieved are when I uploaded the whole DV in the RAM and then made it run in a virtual disk. Then on every hour a backup was made on the real hard drive. But there were still some processes that were slowing things down. I use Joomla and Wordpress. The Joomla I am using is kind of old but I follow the rule that says “If something works don’t change it.” The new versions are using the hardware at the same level so that is not a problem. RAM is the factor, there is no other solution. Well if you have a lot of money to hire a programmer to repair the code of the whole site.
 
Последно редактирано от модератор:

coolice

Owner
VPS port speed - VPS - Web hosting

I’ve made another thread about the caching. As well I agree about the rule but there is no way to learn something without some experiments.
I will not argue about the specialists (I will just add something), especially I don’t like the things said about RAM and synchronizing.
About the database the variation you use with the ram is the fastest one in the moment. (This is like that when you can afford 1 hour delay). In most of the cases the DB can’t get in the rAM because of its size. In that case you have to use some sort of compression but that will slow the insert time and the response time. I don’t know if this is good enough for your needs but you can have it mind when you pay for your next consultation.

Here are some test from the people I find to be specialists in this.


I will think about wordpress more complex because it works like charm even with PHP 5.5 and a cache plugin that will make the static pages load faster by making them html. (I hope you use this). The last but not least:

http://www.dashboardjunkie.com/test...-total-cache-vs-wp-super-cache-vs-quick-cache

A fast webserver (like nginx or something) and eventually you can use in the future something like varnish as a replacement of Apache or microcache for nginx if you need it.

If I needed to send the DB to the RAM I would make it smaller and divide the buffers / caches and see what will happen.
I can’t say anything about Joomla. I don’t have experience with it and I don’t know what the caching options are. (I will put it on another version without the WP if it has problems working with the new PHP versions).
 
Последно редактирано от модератор:

Горе