Hi, I am still pretty new and have a few Linode 2-4GB servers for development. I just had a client get a 16GB for a production site running Magneto.

When setting up the stack I am sure I can get better performance but I am not sure what config to use as there is no live data yet for comparison.

This is what the tutorial proposes for a 1GB Linode:

/etc/mysql/my.cnf
max_connections = 75
key_buffer = 32M
max_allowed_packet = 1M
thread_stack = 128K
table_cache = 32

Any suggestions is greatly appreciated.

Let it run for a week and run this https://raw.githubusercontent.com/major ... qltuner.pl it'll give you some ideas.

max_connections looks a little low for a 16GB I assume you're expecting a lot of traffic for a node that size.

Other useful options are innodb_file_per_table and innodb_buffer_pool_size if possible set innodb_buffer_pool_size to larger than your database size.

_________________
Paid support
How to ask for help
1. Give details of your problem
2. Post any errors
3. Post relevant logs.
4. Don't hide details i.e. your domain, it just makes things harder
5. Be polite or you'll be eaten by a grue

Are you using InnoDB or MyISAM (or both)?