Understanding VPS Memory
-
Ben
MemberHowdy
I've been on a 256mb VPS, and have been more than happy with the performance (all thanks to the VPS Bible of course!). Its absolutley kicked my shared host's backside in terms of speed & performance.
My VPS provider have kindly upgraded all our packages, for free - so I'm now on a 500 MB VPS.
What sort of performance improvements will I see? Or will it only be noticeable when reaching the max memory?
Cheers
Ben.Posted 1 year ago # -
depends on your traffic Ben but, sure, that's a big difference .. pageload/caching should improve and you have room to add other processes if you want them.
you'll have to reboot to enable the extra ram.
who are you with?
Posted 1 year ago # -
Ben
MemberHowdy Olly
Cheers for the info.
At the mo, I only have a handful of minimal traffic sites running - sub 1k visitors a month, as I dont feel ready to move a bigger site (yet) until I nail my back-up routine. But I'm more than happy with the performance to date...the speed is immense :)
I'm with http://www.bytemark.co.uk - top notch so far & customer support is very good, friendly & helpful........well impressed.
They rebooted the host machine after the upgrade - so the extra memory shows up.
Happy days
Ben.Posted 1 year ago # -
Simon
MemberHi Ben
I'm also with Bytemark, they're a great company :-)
One thing that I have done since the free memory upgrade is to change MySQL settings to take advantage of the extra memory. I've increased the cache size, etc, so that it performs much better.
Let me know if you're interested and I'll post my settings here.
Cheers
SimonPosted 1 year ago # -
Ben
MemberHi Simon
Yes post away mate.....always interested in trying to eek out every last bit of performance from the VPS.
Have you got a backup routine going? I know Bytemark have an rsync tutorial.....but not managed to get it going yet, so just doing manual backups (not ideal).
Cheers
Posted 1 year ago # -
Simon
MemberHi Ben
Here is my my.cnf file. Please bear in mind I'm still learning & tweaking so these settings may not be the best (any feedback from anyone here is much appreciated).
[client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user = mysql socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp skip-external-locking bind-address = 127.0.0.1 key_buffer = 16M max_allowed_packet = 16M thread_stack = 192K thread_cache_size = 8 myisam-recover = BACKUP query_cache_limit = 1M query_cache_size = 16M log_error = /var/www/logs/mysql.error.log expire_logs_days = 28 max_binlog_size = 100M skip-innodb max_connections = 100 tmp_table_size = 64M max_heap_table_size = 64M query-cache-type = 1 key_buffer_size = 16M table_cache = 256 interactive_timeout=100 wait_timeout = 20 connect_timeout=15 log-slow-queries=/var/www/logs/mysql.slow.log long_query_time = 1 log-queries-not-using-indexes [mysqldump] quick quote-names max_allowed_packet = 16M !includedir /etc/mysql/conf.d/I also use the very handy MySQLTuner script: http://www.howtoforge.com/tuning-mysql-performance-with-mysqltuner
Bytemark backups: I've written a script which backs up my web folders and databases which you can see at http://bash.pastebin.com/6CmG7JKS - it's a bit rudimetary and could probably be improved a lot (e.g. to use stunnel for security). I run it as a cron job at 1am every night.
Cheers
SimonPosted 1 year ago # -
nice tips Simon .. guess there's a big gap for a tut tuning up some of these variables ..
Posted 1 year ago #
Reply
You must log in to post.
Want HTML?
a blockquote code em strong ul ol liPlace code between backticks `codeHere`
You've got it.