Register
|
Forum Index
|
FAQ
|
Search
|
Usergroups
|
Log in
Visit HostMySite.com
Forum Index
»
VPS (Virtual Private Servers)
» Post a reply
Post a reply
Username
Subject
Message body
Emoticons
View more Emoticons
Font colour:
Default
Dark Red
Red
Orange
Brown
Yellow
Green
Olive
Cyan
Blue
Dark Blue
Indigo
Violet
White
Black
Font size:
Tiny
Small
Normal
Large
Huge
Close Tags
Options
HTML is
OFF
BBCode
is
ON
Smilies are
ON
Disable BBCode in this post
Disable Smilies in this post
All times are GMT
Select a forum
HostMySite Forum Topics
----------------
Announcements
General Discussion
Domain Name Information
Email & SmarterMail
VPS (Virtual Private Servers)
Web Design
Programming
Ruby on Rails
ASP & .NET
ColdFusion
PHP
Dedicated Servers
Hosted Exchange and SharePoint Beta
Database
WordPress Blog
Networking Forum
SmarterStats
MIVA Merchant & Ecommerce
Operating Systems
MarketPlace
World's Fastest Server
Topic review
<table border="0" cellpadding="3" cellspacing="1" width="100%" class="forumline"> <tr> <th width="22%" height="25">Author</th> <th>Message</th> </tr> <tr> <td width="22%" align="center" valign="top" class="row"><span class="name"><a name=""></a><b>Josh</b></span></td> <td class="row" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="templates/Morpheus/images/gray/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="genmed">Posted: Mon Feb 09, 2009 8:03 pm<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">If you're running MySQL on a Windows VPS your low resources are going to cause most of the issues. So I'll quote... <br /> <br /><div align="center"><table width="90%" cellspacing="1" cellpadding="2" border="0" align="center" class="quote"><tr> <td class="quote" align="left">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 ‘<span style="font-weight: bold">innodb_flush_log_at_trx_commit</span>‘ 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. <br /> <br />You should consider changing ‘<span style="font-weight: bold">key_buffer size</span>‘; 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 ‘<span style="font-weight: bold">innodb_buffer_pool_size</span>‘; 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.</td> </tr></table></div> <br /> <br /><a href="http://blog.eukhost.com/webhosting/optimizing-vps-performance/" target="_blank">http://blog.eukhost.com/webhosting/optimizing-vps-performance/</a></span></td> </tr> </table></td> </tr> <tr> <td colspan="2" class="spacerow"><img src="./templates/Morpheus/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> <tr> <td width="22%" align="center" valign="top" class="row"><span class="name"><a name=""></a><b>nathacof</b></span></td> <td class="row" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="templates/Morpheus/images/gray/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="genmed">Posted: Mon Feb 09, 2009 3:08 pm<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Reference: <a href="http://forums.hostmysite.com/viewtopic.php?t=9376" target="_blank">http://forums.hostmysite.com/viewtopic.php?t=9376</a></span></td> </tr> </table></td> </tr> <tr> <td colspan="2" class="spacerow"><img src="./templates/Morpheus/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> <tr> <td width="22%" align="center" valign="top" class="row"><span class="name"><a name=""></a><b>jamie</b></span></td> <td class="row" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="templates/Morpheus/images/gray/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="genmed">Posted: Sat Feb 07, 2009 4:28 am<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">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.</span></td> </tr> </table></td> </tr> <tr> <td colspan="2" class="spacerow"><img src="./templates/Morpheus/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> <tr> <td width="22%" align="center" valign="top" class="row"><span class="name"><a name=""></a><b>lstockman</b></span></td> <td class="row" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="templates/Morpheus/images/gray/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="genmed">Posted: Fri Feb 06, 2009 9:24 pm<span class="gen"> </span> Post subject: Re: ColdFusion VPS permormance</span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody"><div align="center"><table width="90%" align="center" cellspacing="1" cellpadding="2" border="0" class="quote"><tr> <td class="quote_user" align="left">MarFan wrote:</td></tr><tr> <td class="quote" align="left">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. <br /> <br />-- thanks</td> </tr></table></div> <br /> <br />Hello, <br /> <br />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? <br /> <br />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?</span></td> </tr> </table></td> </tr> <tr> <td colspan="2" class="spacerow"><img src="./templates/Morpheus/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> <tr> <td width="22%" align="center" valign="top" class="row"><span class="name"><a name=""></a><b>MarFan</b></span></td> <td class="row" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="templates/Morpheus/images/gray/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="genmed">Posted: Thu Feb 05, 2009 9:43 pm<span class="gen"> </span> Post subject: ColdFusion VPS permormance</span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">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. <br /> <br />-- thanks</span></td> </tr> </table></td> </tr> <tr> <td colspan="2" class="spacerow"><img src="./templates/Morpheus/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> </table>
Powered by
phpBB
© phpBB Group
Design by
phpBBStyles.com
|
Styles Database
.
Content ©
DupeDB
