I’m getting a 300mb RAM VPS and I’d like to know what would be a good MySQL configuration for InnoDB database.
Any tips on that?
What kind of queries will you be running? How many concurrent connections do you expect? How much RAM can you commit to MySQL alone? Will you be sorting joined table with text/blobs in them? Will you be accessing mostly the same data, or are your access patterns spread out across all your data? How big is your database (data+indexes)?