Janyour Posted March 19, 2013 Share Posted March 19, 2013 Hi evry one, i think this topic will interest many membres here :D well, i have two VPS, the first is 1GB of memory to host IP. board files, the second is a 512MB with only mysql server installed to host the database, Did you think that wa can optimize the second one, mysql server VPS ? i heard that InnoDB is good for example ! regards Link to comment Share on other sites More sharing options...
Janyour Posted March 20, 2013 Author Share Posted March 20, 2013 any idea ? Link to comment Share on other sites More sharing options...
.Nuno. Posted March 21, 2013 Share Posted March 21, 2013 You can start with tuning-primer and mysqltuner. You don't tell us the size of your board, but inno db is not always the better option. I'm using mariadb with myisam with a great performance Link to comment Share on other sites More sharing options...
AlexJ Posted March 21, 2013 Share Posted March 21, 2013 PM me the details and I can help you out. Link to comment Share on other sites More sharing options...
Janyour Posted March 21, 2013 Author Share Posted March 21, 2013 thank you guys, i use APC and Memcache in the same time, did you think that will cause a conflict ? it seems that my board work correctly ! Link to comment Share on other sites More sharing options...
Maksim Posted March 21, 2013 Share Posted March 21, 2013 stupid question, but why not have them on one? as vps seem small as it is? Link to comment Share on other sites More sharing options...
.Nuno. Posted March 21, 2013 Share Posted March 21, 2013 thank you guys, i use APC and Memcache in the same time, did you think that will cause a conflict ? it seems that my board work correctly ! You don't need memcache ... just run APC. Memcache should only be used in a multi server environment Link to comment Share on other sites More sharing options...
Janyour Posted March 21, 2013 Author Share Posted March 21, 2013 thank you i am just deactivating memcache, i have only one server ! i will install mysql tunner et return to you ;) Link to comment Share on other sites More sharing options...
Grumpy Posted March 22, 2013 Share Posted March 22, 2013 stupid question, but why not have them on one? as vps seem small as it is? Could be that the db node is on db specific hardware like SSD instead of HDD, or something like amazon db cloud. Otherwise, it's sort of a waste of money and unnecessary increase in latency. Link to comment Share on other sites More sharing options...
Janyour Posted March 22, 2013 Author Share Posted March 22, 2013 exactly that, my server had a SSD hard disk, i'd installed mysqltunner and changed my.cnf parameters as indicated in the recommandations, is there any other thing that i can do ? Link to comment Share on other sites More sharing options...
.Nuno. Posted March 22, 2013 Share Posted March 22, 2013 You could try mariadb. It uses xtra db from percona and myisam engine it's better than mysql. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.