Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted March 19, 201312 yr 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
March 21, 201312 yr 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
March 21, 201312 yr Author 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 !
March 21, 201312 yr 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
March 21, 201312 yr Author thank you i am just deactivating memcache, i have only one server ! i will install mysql tunner et return to you ;)
March 22, 201312 yr 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.
March 22, 201312 yr Author 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 ?
March 22, 201312 yr You could try mariadb. It uses xtra db from percona and myisam engine it's better than mysql.
Archived
This topic is now archived and is closed to further replies.