ColdFusion VPS permormance

Posts: 3 · Posted: Thu Feb 05, 2009 9:43 pm

I signed up with the CF VPS account, I disabled MSSQL and installed MySQL. I also installed an ftp server, that is all. I have very low performance. I am unable to run smartermail or any of the smarter apps. Has anyone else experienced any performance issues with this account? Currently I am only hosting 3 domains... A little frustrating.

-- thanks

Posts: 1 · Posted: Fri Feb 06, 2009 9:24 pm

MarFan wrote:

I signed up with the CF VPS account, I disabled MSSQL and installed MySQL. I also installed an ftp server, that is all. I have very low performance. I am unable to run smartermail or any of the smarter apps. Has anyone else experienced any performance issues with this account? Currently I am only hosting 3 domains... A little frustrating.

-- thanks

Hello,

Have you opened a ticket with our support department? If so, could you provide the ticket number so we're able to look into this for you?

You should be able to run SmarterMail as well as SmarterStats depending on the setup of your VPS and the resources that the sites are using. What FTP server have you installed?

Posts: 858 · Posted: Sat Feb 07, 2009 4:28 am

There was a post by one of our other reps, Nate Coffield, that gave some stats on MySQL performance on Windows. I forget how it was arrived at, and can't seem to find the post now, however basically it said that MySQL runs 300% WORSE on Windows than it does on Linux. With that in mind, it may be beneficial for you to get a shared MySQL database and use that instead of running MySQL off your Windows VPS.

Posts: 192 · Posted: Mon Feb 09, 2009 3:08 pm

Reference: http://forums.hostmysite.com/viewtopic.php?t=9376

Posts: 1047 · Posted: Mon Feb 09, 2009 8:03 pm

If you're running MySQL on a Windows VPS your low resources are going to cause most of the issues. So I'll quote...

One of the main things you can do to ensure that MySQL is able to run fast and effectively within your VPS is to ensure that MySQL has its dynamic durability settings enabled - this will mean setting a certain value for the ‘innodb_flush_log_at_trx_commit‘ option which is located within the MySQL configuration file; there are 3 main values which you are able to change this option to, these are: 0 - with this value, Innodb will flush the log approximately once per second, 1 - this should be chosen if you have high durability requirements since log records will be automatically pushed to the disk on transaction commit, 2 - this will ensure that data is flushed to the operating system cache.

You should consider changing ‘key_buffer size‘; this option can end up taking up as much as 30-40% of the memory which you have available on your VPS, although this is only really applicable if you have chosen to use MyISAM tables within your MySQL database server setup to serve your website. Another option which you should consider changing is ‘innodb_buffer_pool_size‘; this option is only applicable to you if your tables are using the Innodb framework since they are much more sensitive to the buffer pool size than MyISAM tables are.

http://blog.eukhost.com/webhosting/optimizing-vps-performance/