I am really new to MySql tuning. I have just set up a 256MB VPS, running nginx and a mongrel rails cluster (3 processes). The mongrels take up about 70MB each … so I think I have about 32MB for MySql.
All my tables need to use InnoDB.
Are there any ‘templates’ around for my.cnf for a similar set up to this?
Can I use the default my.cnf, or is it best to tune for InnoDb?
When InnoDB settings, for example, speak of setting the buffer to 60-80% of memory would that refer to the 32MB, or the total 256MB? If I set this buffer, do I need to reduce anything else from the default set up?
ANY help or guidance would be really really appreciated.