brashquido Posted March 7, 2007 Share Posted March 7, 2007 Hi All, I'm got several fairly low trafficked sites (nothing over 10,000 page views a month) on a VPS with 512MB RAM running Windows 2003 Server, IIS6, PHP 4.4.4, MySQL 4.1.20 and a handful of other services. So basically I have very limited system resources. I've been trying to tune MySQL over the past few days and am finding I've very limited on the amount of memory I can allocate to it. Just wondering if it would be better in my case to only use MyISAM? My sites are not heavy on writes (not much forum activity, etc) and that way I could free up the memory being used for the InnoDB cache for other services. What would the pros/cons of doing this be? Quote Link to comment Share on other sites More sharing options...
artacus Posted March 7, 2007 Share Posted March 7, 2007 Sounds like you would be fine either way. MyISAM will be faster for you. So on a system with limited resources, I'd stick with that unless there was a compelling reason to use InnoDB Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.