MySQL configuration for 16GB Linode
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
maxallowedpacket = 1M
thread_stack = 128K
table_cache = 32
Any suggestions is greatly appreciated.
2 Replies
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 innodbfilepertable and innodbbufferpoolsize if possible set innodbbufferpool_size to larger than your database size.
