Optimization of a private Mysql server VPS

[Janyour]

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

[Janyour]

any idea ?

[.Nuno.]

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

[AlexJ]

PM me the details and I can help you out.

[Janyour]

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 !

[Maksim]

stupid question, but why not have them on one? as vps seem small as it is?

[.Nuno.]

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

[Janyour]

thank you i am just deactivating memcache, i have only one server !

i will install mysql tunner et return to you ;)

[Grumpy]

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.

[Janyour]

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 ?

[.Nuno.]

You could try mariadb. It uses xtra db from percona and myisam engine it's better than mysql.