please help, need best Innodb config of Linode 16G VPS

My usual approach: use http://mysqltuner.com/ to tune it, with your real workload.

For InnoDB, the immediate advice I would give is to set it to use per-table tablespaces before creating your tables: https://dev.mysql.com/doc/refman/5.1/en … paces.html">https://dev.mysql.com/doc/refman/5.1/en/innodb-multiple-tablespaces.html … everything else will kinda settle out from there.

Thank you very much for Help

I will do my best to collect a good configuration of my.cnf file, from mysqltuner output results and applying tablespaces …

regards
@hoopycat:

My usual approach: use http://mysqltuner.com/ to tune it, with your real workload.

For InnoDB, the immediate advice I would give is to set it to use per-table tablespaces before creating your tables: https://dev.mysql.com/doc/refman/5.1/en … paces.html">https://dev.mysql.com/doc/refman/5.1/en/innodb-multiple-tablespaces.html … everything else will kinda settle out from there.