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
[quote="tedjtw"]Have you contacted support ? We have had zero problems in over 2 years. Have you logged into the virtuozzo control panel and looked at your logs ?[/quote]
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>whitesites</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: Wed Feb 11, 2009 4:03 am<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">I remember you mentioning you were going to post the article before. I will have to read up on it. 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> <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: Wed Feb 11, 2009 2:12 am<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Whitesites, did you check out the article I posted in the database section? It's sticky so you can't miss it. <br /> <br />The writers of <a href="http://oreilly.com/catalog/9780596101718/" target="_blank">High Performance MySQL</a>, have a <a href="http://www.mysqlperformanceblog.com/" target="_blank">blog</a>, which isn't too great of a read for a novice, however their book certainly goes a long way to fill the knowledge gap. I would recommend it to anyone who is looking to set up a MySQL server for production use. Also you should be able to understand the blog a bit better after reading it as well. <img src="images/smiles/icon_wink.gif" alt="Wink" border="0" /> <br /> <br />Remember that relational databases are no laughing matter, and in order to grasp the concepts fully, you're probably going to have to be doing this stuff full time.</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>whitesites</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: Tue Feb 10, 2009 10:33 pm<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">What we need is tutorial for dummies on optimizing both queries and the server itself for MySQL. Even something that explains to developers how and why you setup indexes would greatly help. Its needs to be written at a very basic level so even the noobs can understand it.</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: Tue Feb 10, 2009 10:17 pm<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Josh, <br /> <br />I'm not stating it's not doable. We have a large number of clients using MySQL on Windows. I am basically relaying the information provided to me by the official MySQL instructor, along with my personal experience trouble shooting hardware node issues. <br /> <br />Hope this helps.</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>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 7:54 pm<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Just to be clear... I thought that with MySQL 5.1 and InnoDB ACID compliance was met? <br /> <br />Also, we run MySQL on Windows servers and notice that as long as our hardware is up to spec that what seems to make the most difference is queries. Knowing how to fully optimize the dataset via MySQL so that the application logic has to do nothing, or next to nothing, is where the money's at. <br /> <br />Don't get me wrong, we did have to perform some performance tuning and configuration in order to get things running the way we wanted, but we do that with every application server that we run. <br /> <br />Any thoughts?</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: Sun Jan 18, 2009 7:23 am<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Thanks Nate - I've long heard that MySQL on Windows was 'less than ideal' but I never knew the specifics as to why.</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>whitesites</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 Jan 17, 2009 11:10 pm<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Thanks I will do so, Anything you call share with us to help us increase the performance of our VPS would be greatly appreciated. Maybe something specific about indexes, and how to properly use them would be a good idea. There are a lot of DB noobies out there that could really use the schooling on these types of issues.</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: Sat Jan 17, 2009 11: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">Whitesites, look to the Database forums in the next couple of days I'll try to throw together a quick write up for you guys.</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>whitesites</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 Jan 17, 2009 10:25 pm<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">I am running MySQL 5 on my Windows VPS ( 1 GB ). <br /> <br />Turns out the problem was a corrupt installation of MySQL. <br />A fresh installation seemed to fix the problem. <br />This server doesn't do too much traffic., but my other VPS does <br /> <br />For anyone wants to get the most bang for your buck with running a single site on a VPS. I recommend getting a Windows VPS for your applicaiton and a Linux Shared Hosting account for your Mail Server, MySQL, and STats server. This way your Windows VPS can just focus on your APP pool. <br /> <br />I have a rather high traffic site setup like this and it has been working well. <br /> <br />If you have a more detailed list of performance tips for MySQL I am all ears.</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: Sat Jan 17, 2009 4:18 pm<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">@WhiteSites, <br /> <br />Are you running MySQL on a Windows VPS? <br /> <br />Myself and a number of other employees had the benefit of obtaining on site training from MySQL. During this training we learned the troubles of running MySQL on Windows. I'll give you the short list: <br /><ol type="1"> <br /><li> MySQL Performance suffers (according to the trainer difference in performance can be up to 300% depending on the number and size of your queries) <br /><li> Not ACID compliance. You lose durability because Windows does not write it's cache to disk before telling mysql that is has. Meaning the data is stored in cache, but mysql think's it has been written to the disk. There are patches to correct this behavior, but the average joe probably isn't interested. <br /><li>The primary limitation of our current hardware nodes is the fact that we are running 32 bit operating systems. This means that there is a limit on the Paged and Non-Paged Pool kernel memory for Windows. <br /> <br />Reference: <a href="http://msdn.microsoft.com/en-us/library/aa366778.aspx" target="_blank">http://msdn.microsoft.com/en-us/library/aa366778.aspx</a> <br /> <br />Through out the course of my investigation I have found that a number of MySQL instances on a single node can be detrimental to both of these memory pools. When they fill up, the server as a whole is unable to maintain any new connections. <br /></ol> <br />It is my recommendation that any one who is running MySQL on their Windows VPS either setup a shared MySQL server, or perhaps go so far as to purchase a linux VPS for handling your database needs. <br /> <br />If there is enough demand for these services, like we have with MS SQL databases, perhaps we can setup dedicated Linux VPS servers to house your MySQL databases. Unfortunately MySQL on Windows is one of the primary causes for these problems, amongst others such as unruly mail servers, or any service which makes a large number of socket connections.</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>whitesites</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: Wed Jan 14, 2009 8:49 am<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">I agree with you Jamie, putting all of them on one dedicated box, or event colocating a box would be ideal. But unfortunately I don't have a huge number of clients and I would rather set them up direct with HMS. This way if I ever needed to eliminate my clients for more dedicated projects, I don't have to go through moving them to their own hosts.</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: Wed Jan 14, 2009 8:38 am<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">The VPS environment is nice because it offers more disk space and flexibility than a typical shared environment, however there still exists the chance that some other user on the same hardware node as you will overutilize and cause performance issues on your website. <br /> <br />We're looking to eliminate this problem with our VPS 2.0 offering, which is likely due out by the end of Q1, or Q2 at the very latest, however if questioned about that fact I will swear ignorance. <br /> <br />Even with VPS 2.0 I would still advocate that a dedicated server is a much more stable environment however, since in that setting the only problems that occur are due to either insufficient hardware or issues with the code on sites that you have direct control over. In your last post you mentioned having 4 VPS plans with us - given that I would urge you to consider consolidating all of your plans into a single dedicated server (or better yet, a dedicated webserver and a dedicated mailserver if you have DB-heavy apps) for the sake of performance and stability. Granted, it will cost as much (if not more) than your current setup, but in this case I think the pros of stability and ease of upgrade are well worth it.</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>whitesites</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: Wed Dec 17, 2008 12:51 am<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">I have been having these same issues for the past month. First it was some jackass on the node who was going through 6TB of transfer. Then I came to realize mySQL had become corrupt. Then after a reinstall of MySQL, everything seemed fine. Now I am getting Connection Interrupted errors randomly to all my sites. Not sure what the cause of it is, I am about to request HMS move me to a new box, and not just move me to a different node on the same box. This sucks because migrating all my data and DNS will eat up an entire day. I am normally pro HMS but right now it seems like I am calling them daily with VPS issues. <br /> <br />I do have 4 other VPS with HMS and none of them have these problems. Wish they could find the cause.</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>farost</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 Oct 30, 2008 12:51 am<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Yes, we have contact them. They said that the datacenter was under stress by a server sending lots of traffic, so we want to know if someboby besides us is having th same problem. <br /> <br />Tonight the intermittency is really heavy <img src="images/smiles/icon_cry.gif" alt="Crying or Very sad" border="0" /></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>tedjtw</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 Oct 30, 2008 12:07 am<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Have you contacted support ? <br /> <br />We have had zero problems in over 2 years. Have you logged into the virtuozzo control panel and looked at your logs ?</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
