I run a small community with a database size of 800MB.
I run a 2Gb kvm vps and when I use innodb with 1gb pool size the server start to swap.
For now I convert to myisam so I can gradually move to innodb.
Things are running ok for now.
My concern is related to the balance between the amount of ram my vps needs and the pool size.
Do I need more ram to run a xf with a 800mb database?